Выборка и поиск по полю

  DataTable dt = new DataTable();
 BindingSource bs = new BindingSource ();
 
SqlConnectionStringBuilder SqlConnect = new SqlConnectionStringBuilder();
            SqlConnect.InitialCatalog="BazaDannyh";
            SqlConnect.UserID="UserLogin";
            SqlConnect.Password="Password";
            SqlConnect.DataSource=@"Server";
 
 
 
            SqlConnection Connection = new SqlConnection(SqlConnect.connectionString);
                Connection.Open();
                SqlCommand cmd = new SqlCommand("Select * from table", Connection);
                SqlDataReader SqlReader = SqlReader = cmd.ExecuteReader();
                dt.Load(SqlReader);
 
Connection.Close();
 
 
bs.datasource=dt ;
 
bs.Filter=string.format("Field like '%{0}%'",Textbox1.text)

basaDataContext rt= new basaDataContext();
var basa = (from i in rt.table1
 where i.Name == textBox1.text
select new {i.id, i.Name});
 dataGridView1.DataSource = basa;

public DataTable GetDataTable(string query)
{
 
DataTable dt = new DataTable();
 BindingSource bs = new BindingSource ();
 
SqlConnectionStringBuilder SqlConnect = new SqlConnectionStringBuilder();
            SqlConnect.InitialCatalog="BazaDannyh";
            SqlConnect.UserID="UserLogin";
            SqlConnect.Password="Password";
            SqlConnect.DataSource=@"Server";
 
 
 
            SqlConnection Connection = new SqlConnection(SqlConnect.connectionString);
                Connection.Open();
                SqlCommand cmd = new SqlCommand(query, Connection);
                SqlDataReader SqlReader = SqlReader = cmd.ExecuteReader();
                dt.Load(SqlReader);
 
Connection.Close();
return dt;
 }

DatagridView.DAtaSource=GetDataTable("Select * from Table")