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?
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();
Explanation:
You need to get the NextResult prior to performing the subsequent DataBind.