2013年微软认证考试_70-562练习9

QUESTION 17

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.

You write the following code segment in the code-behind file to create a Web form. (Line numbers are included for reference only.)

01 string strQuery = "select * from Products;"

02 + "select * from Categories";

03 SqlCommand cmd = new SqlCommand(strQuery, cnn);

04 cnn.Open();

05 SqlDataReader rdr = cmd.ExecuteReader();

06

07 rdr.Close();

08 cnn.Close();

You need to ensure that the gvProducts and gvCategories GridView controls display the data that is contained in the following two database tables:

The Products database tabl The Categories database tabl Which code segment should you insert at line 06?

A.

gvProducts.DataSource = rdr;

gvProducts.DataBind();

gvCategories.DataSource = rdr;

gvCategories.DataBind();

B.

gvProducts.DataSource = rdr;

gvCategories.DataSource = rdr;

gvProducts.DataBind();

gvCategories.DataBind();

C.

gvProducts.DataSource = rdr;

rdr.NextResult();

gvCategories.DataSource = rdr;

gvProducts.DataBind();

gvCategories.DataBind();

D.

gvProducts.DataSource = rdr;

gvCategories.DataSource = rdr;

gvProducts.DataBind();

rdr.NextResult();

gvCategories.DataBind();

Answer: D QUESTION 18

You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.

You create a Web form that contains the following code fragment.

You write the following code segment in the code-behind file. (Line numbers are included for reference only.)

01 protected void Page_Load(object sender, EventArgs e)

02 {

03 DataSet objDS = new DataSet();

04 SqlDataAdapter objDA = new SqlDataAdapter(objCmd);

05 objDA.Fill(objDS);

06 gridCities.DataSource = objDs;

07 gridCities.DataBind();

08 Session["ds"] = objDS;

09 }

10 protected void btnSearch_Click(object sender, EventArgs e)

11 {

12

13 }

You need to ensure that when the btnSearch Button control is clicked, the records in the gridCities GridView control are filtered by using the value of the txtSearch TextBox.

Which code segment you should insert at line 12?

A.

DataSet ds = gridCities.DataSource as DataSet;

DataView dv = ds.Tables[0].DefaultView;

dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";

gridCities.DataSource = dv;

gridCities.DataBind();

B.

DataSet ds = Session["ds"] as DataSet;

DataView dv = ds.Tables[0].DefaultView;

dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";

gridCities.DataSource = dv;

gridCities.DataBind();

C.

DataTable dt = Session["ds"] as DataTable;

DataView dv = dt.DefaultView;

dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";

gridCities.DataSource = dv;

gridCities.DataBind();

D.

DataSet ds = Session["ds"] as DataSet;

DataTable dt = ds.Tables[0];

DataRow[] rows = dt.Select("CityName LIKE '" + txtSearch.Text + "%'");

gridCities.DataSource = rows;

gridCities.DataBind();

Answer: B