按条件查询,显示数据库中的数据
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Data Source=.;Initial Catalog=Library;Integrated Security=True;Pooling=False;Asynchronous Processing=true";
SqlDataAdapter da = new SqlDataAdapter("select * from BorBookInfo", conn);
DataSet ds = new DataSet();
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
按照TEXTBOX1中的子段BookNo查询,在dataGridView1上显示,该怎么做?我试了好多方法都不行,