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