注册 登录
编程论坛 C# 论坛

c#模糊查询出错

lukebc 发布于 2016-08-29 13:32, 1356 次点击
SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "server=LUKE\\SQLEXPRESS;uid=sa;pwd=sa;database=luke";
            conn.Open();
            DataTable dt = new DataTable("resouce");
            dt.Clear();
            SqlDataAdapter adp = new SqlDataAdapter("select * from text1", conn);
            adp.Fill(dt);
            string sql = "select * from text1 where bh like %"+textBox1.Text+"%";
            SqlCommand command = new SqlCommand(sql, conn);
            SqlDataAdapter ad = new SqlDataAdapter();
            ad.SelectCommand = command;
            ad.Fill(dt);
            dt.Clear();
            dataGridView1.DataSource = dt.DefaultView;
我在textbox1中输入查询数字 2 提示出错   
只有本站会员才能查看附件,请 登录
1 回复
#2
over12302016-08-29 13:46
string sql = "select * from text1 where bh like '%"+textBox1.Text+"%'";
1