ADO.net 中的筛子 Ｂy Kinbor

string selet="select * from Employees ";
SqlConnection myConnection=new SqlConnection("server=localhost;database=Northwind;uid=sa;pwd=sa");
myConnection.Open();
SqlDataAdapter com=new SqlDataAdapter(selet,myConnection);
DataSet ds=new DataSet(); //数据集合
com.Fill(ds,"table");
ds.Tables["table"].DefaultView.RowFilter ="EmployeeID >4 and TitleOfCourtesy = 'Mr.'";
//筛子语句，条件用and连接 字符串用 单引号括起来。
dataGrid1.DataSource=ds.Tables["table"];
myConnection.Close();