Question

DataView中的RowFilter不起作用 没有出现过滤效果

DataView dv;
public void dv1()
{
string sqlconn = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CellphoneWeb;Data Source=FENG-ABB7091877\\SQLEXPRESS ";
SqlConnection myConnection = new SqlConnection(sqlconn);
myConnection.Open();
SqlCommand myCommand = new SqlCommand("SELECT model,brand,price,time FROM mobile", myConnection);
SqlDataAdapter Adapter = new SqlDataAdapter();
Adapter.SelectCommand = myCommand;
DataSet myDS = new DataSet();
Adapter.Fill(myDS);
myConnection.Close();
dv = myDS.Tables[0].DefaultView;
GridView1.DataSource = dv;
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
dv1();
dv.RowFilter = "brand like '索爱'";

}

Answer 1

protected void Button1_Click(object sender, EventArgs e)
{
dv1();
dv.RowFilter = "brand like '索爱'";
GridView1.DataSource = dv;
GridView1.DataBind();

}

Answer 2

要重新绑定吧