请教,在调用“Fill”前,SelectCommand 属性尚未初始化。这个如何解决
请问,在调用“Fill”前,SelectCommand 属性尚未初始化。这个怎么解决?
以下是代码
private void button1_Click(object sender, EventArgs e)
{
string DLBM, QSXZ, TBBH, DLMC, QSDWDM;
DLBM = textBox1.Text;
QSXZ = textBox2.Text;
TBBH = textBox3.Text;
DLMC = textBox4.Text;
QSDWDM = textBox5.Text;
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = "Data Source=carlowed;Initial Catalog=land;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlcon;
cmd.CommandText = "select(" + DLBM + "," + QSXZ + "," + TBBH + "," + DLMC + "," + QSDWDM + ") from dltb ";
sqlcon.Open();
DataSet dataset = new DataSet();
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.Fill(dataset);
dataGridView1.DataSource = dataset.Tables[0];
sqlcon.Close();
}
刚刚接触这个,还有很多不懂的,请大家见谅
------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter(sql语句,连接对象);
------解决思路----------------------
------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.Fill(dataset);
你这样用法,你上面的cmd不是白定义了,根本一点关系都没有了
SqlDataAdapter()有好几种重载,你找找有没有直接能把cmd传进去的
以下是代码
private void button1_Click(object sender, EventArgs e)
{
string DLBM, QSXZ, TBBH, DLMC, QSDWDM;
DLBM = textBox1.Text;
QSXZ = textBox2.Text;
TBBH = textBox3.Text;
DLMC = textBox4.Text;
QSDWDM = textBox5.Text;
SqlConnection sqlcon = new SqlConnection();
sqlcon.ConnectionString = "Data Source=carlowed;Initial Catalog=land;Integrated Security=True";
SqlCommand cmd = new SqlCommand();
cmd.Connection = sqlcon;
cmd.CommandText = "select(" + DLBM + "," + QSXZ + "," + TBBH + "," + DLMC + "," + QSDWDM + ") from dltb ";
sqlcon.Open();
DataSet dataset = new DataSet();
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.Fill(dataset);
dataGridView1.DataSource = dataset.Tables[0];
sqlcon.Close();
}
刚刚接触这个,还有很多不懂的,请大家见谅
------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter(sql语句,连接对象);
------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.SelectCommand = cmd;
------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter();
dataadapter.Fill(dataset);
你这样用法,你上面的cmd不是白定义了,根本一点关系都没有了
SqlDataAdapter()有好几种重载,你找找有没有直接能把cmd传进去的