private void button2_Click(object sender, EventArgs e)
{
string str = @"Data Source=zhang-pc\sql2005;Initial Catalog=档案管理;uid=sa;password=sa1234";
SqlConnection strconn = new SqlConnection(str);
strconn.Open();
string cbx = comboBox1.Text;
SqlDataAdapter dar = new SqlDataAdapter("select * from tb_word where '"+cbx+"'='"+textBox1.Text+"'", strconn);
SqlCommandBuilder cb = new SqlCommandBuilder();
DataSet ds = new DataSet();
ds.Clear();
dar.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
strconn.Close();
}
是不是上面红色部分错了?应该怎么改?
{
string str = @"Data Source=zhang-pc\sql2005;Initial Catalog=档案管理;uid=sa;password=sa1234";
SqlConnection strconn = new SqlConnection(str);
strconn.Open();
string cbx = comboBox1.Text;
SqlDataAdapter dar = new SqlDataAdapter("select * from tb_word where '"+cbx+"'='"+textBox1.Text+"'", strconn);
SqlCommandBuilder cb = new SqlCommandBuilder();
DataSet ds = new DataSet();
ds.Clear();
dar.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;
strconn.Close();
}
是不是上面红色部分错了?应该怎么改?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货