Question: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:
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();
+ AnswerD
+ Report
Total Preview: 1493