Question:You create a Microsoft ASP.NET application by using the Microsoft .NET Framework version 3.5.
You create a Web form that contains the following code fragment.
<asp:TextBox runat="server" ID="txtSearch" />
<asp:Button runat="server" ID="btnSearch" Text="Search" OnClick="btnSearch_Click" />
<asp:GridView runat="server" ID="gridCities" />
You write the following code segment in the code-behind file. (Line numbers are included for reference only.)
01 protected void Page_Load(object sender,
02 EventArgs e) {
03 DataSet objDS = new DataSet();
04 SqlDataAdapter objDA = new SqlDataAdapter(objCmd);
05 objDA.Fill(objDS);
06 gridCities.DataSource = objDS;
07 gridCities.DataBind();
08 Session("ds") = objDS;
09 }
10 protected void btnSearch_Click(object sender,
11 EventArgs e)
13 }
You need to ensure that when the btnSearch Button control is clicked, the records in the gridCities GridView control are filtered by using the value of the txtSearch TextBox.
Which code segment you should insert at line 12?
A DataSet ds = gridCities.DataSource as DataSet;
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";
gridCities.DataSource = dv; gridCities.DataBind();B DataSet ds As DataSet = Session["ds"] as DataSet;
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";
gridCities.DataSource = dv; gridCities.DataBind();C DataTable dt = Session["ds"] as DataTable;
DataView dv = dt.DefaultView;
dv.RowFilter = "CityName LIKE '" + txtSearch.Text + "%'";
gridCities.DataSource = dv; gridCities.DataBind();D DataSet ds = Session["ds"] as DataSet;
DataTable dt = ds.Tables[0];
DataRow[] rows = dt.[Select]("CityName LIKE '" + txtSearch.Text + "%'");
gridCities.DataSource = rows; gridCities.DataBind();
+ AnswerB
+ Report
Total Preview: 2682