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 Dim strQuery As String = "select * from Products;" & "select * from Categories"
02 Dim cmd As New SqlCommand(strQuery, cnn)
03 cnn.Open()
04 Dim rdr As SqlDataReader = cmd.ExecuteReader()
05
06 rdr.Close()
07 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 05?
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()