怎么根据TextBox中的内容查询并显示数据库里的记录

怎样根据TextBox中的内容查询并显示数据库里的记录？
求解

[解决办法]

C# code

SqlConnection conn = new SqlConnection("数据库连接字符串");string sql = " select * from 表 where 字段='" + textbox1.text + "'";//根据textbox中的text动态生成sql语句SqlDataAdapter dr = new SqlDataAdapter(sql, conn);DataTable dt = new DataTable();dr.Fill(dt);this.datagridview1.datasource = dt;
[解决办法]
C# code
            SqlConnection con = new SqlConnection();            con.ConnectionString = @"Data Source=MH\SQLEXPRESS;Initial Catalog=hs;User Id=sa;Password=;";            con.Open();            SqlDataAdapter adapter = new SqlDataAdapter("select * from BillList where code='"+textBox1.Text+"'",con);            DataSet ds = new DataSet();            adapter.Fill(ds, "BillList");            dataGridView1.DataSource = ds.Tables["BillList"];
[解决办法]
SqlConnection conn = new SqlConnection("数据库连接字符串");
string sql = textbox1.text //根据textbox中的text动态生成sql语句

SqlDataAdapter dr = new SqlDataAdapter(sql, conn);
DataTable dt = new DataTable();
dr.Fill(dt);
this.datagridview1.datasource = dt;
或者是这样
[解决办法]
http://blog.csdn.net/xianfajushi/article/details/7643705