Which code segment should you insert at line 05?

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?

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



Leave a Reply 0

Your email address will not be published. Required fields are marked *