PrepAway - Latest Free Exam Questions & Answers

Which code segment should you insert at line 06?

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 table
The Categories database table

Which code segment should you insert at line 06?

PrepAway - Latest Free Exam Questions & Answers

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();


Leave a Reply