请教,在调用“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.SelectCommand = cmd;

------解决思路----------------------
SqlDataAdapter dataadapter = new SqlDataAdapter();
            dataadapter.Fill(dataset);
你这样用法,你上面的cmd不是白定义了,根本一点关系都没有了
SqlDataAdapter()有好几种重载,你找找有没有直接能把cmd传进去的