第一种:用SqlDataReader
SqlCommand objcmd = new SqlCommand("select * from lab_rygl where ryid='" + Jryid + "'", alluse.Class1.conn1);
objcmd.CommandType = CommandType.Text;
SqlDataReader myreader1 = objcmd.ExecuteReader();
if (myreader1.Read())
{
this.comboBox12.Text = myreader1["dabh"].ToString();
this.comboBox1.Text = myreader1["xm"].ToString();
this.comboBox2.Text = myreader1["xb"].ToString();
this.comboBox3.Text = myreader1["mz"].ToString();
this.comboBox4.Text = myreader1["csdd"].ToString();
this.comboBox5.Text = myreader1["zzmm"].ToString();
this.comboBox6.Text = myreader1["zgxl"].ToString();
this.comboBox7.Text = myreader1["sxzy"].ToString();
this.comboBox8.Text = myreader1["xrzw"].ToString();
this.comboBox9.Text = myreader1["gzgw"].ToString();
this.comboBox10.Text = myreader1["jszc"].ToString();
this.comboBox11.Text = myreader1["jszcjb"].ToString();
this.dateTimePicker1.Value=(DateTime)myreader1["csrq"];
this.dateTimePicker2.Value=(DateTime)myreader1["bysj"];
this.dateTimePicker3.Value=(DateTime)myreader1["csjssj"];
this.dateTimePicker4.Value=(DateTime)myreader1["gzsj"];
this.dateTimePicker5.Value=(DateTime)myreader1["gbsj"];
this.dateTimePicker6.Value=(DateTime)myreader1["cssj"];
this.dateTimePicker7.Value=(DateTime)myreader1["hdsj"];
this.textBox1.Text = myreader1["bz"].ToString();
this.dateTimePicker8.Value = (DateTime)myreader1["jdsj"];
}
myreader1.Close();
第二种Dataset读取数据集。
SqlDataAdapter sda = new SqlDataAdapter("select * from lab_rygl where ryid='" + Jryid + "'", alluse.Class1.conn1);
DataSet ds = new DataSet();
sda.Fill(ds, "lab_rygl");
if (ds.Tables["lab_rygl"].Rows.Count > 0)
{
this.comboBox12.Text = ds.Tables["lab_rygl"].Rows[0]["dabh"].ToString();
this.comboBox1.Text = ds.Tables["lab_rygl"].Rows[0]["xm"].ToString();
this.comboBox2.Text = ds.Tables["lab_rygl"].Rows[0]["xb"].ToString();
this.comboBox3.Text = ds.Tables["lab_rygl"].Rows[0]["mz"].ToString();
this.comboBox4.Text = ds.Tables["lab_rygl"].Rows[0]["csdd"].ToString();
this.comboBox5.Text = ds.Tables["lab_rygl"].Rows[0]["zzmm"].ToString();
this.comboBox6.Text = ds.Tables["lab_rygl"].Rows[0]["zgxl"].ToString();
this.comboBox7.Text = ds.Tables["lab_rygl"].Rows[0]["sxzy"].ToString();
this.comboBox8.Text = ds.Tables["lab_rygl"].Rows[0]["xrzw"].ToString();
this.comboBox9.Text = ds.Tables["lab_rygl"].Rows[0]["gzgw"].ToString();
this.comboBox10.Text = ds.Tables["lab_rygl"].Rows[0]["jszc"].ToString();
this.comboBox11.Text = ds.Tables["lab_rygl"].Rows[0]["jszcjb"].ToString();
this.dateTimePicker1.Value = DateTime.Parse(ds.Tables["lab_rygl"].Rows[0]["csrq"].ToString());//以上依此类推就对了。用DateTime.Parse进行强制转换。。。。。。
this.dateTimePicker2.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["bysj"].ToString();
this.dateTimePicker3.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["csjssj"].ToString();
this.dateTimePicker4.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["gzsj"].ToString();
this.dateTimePicker5.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["gbsj"].ToString();
this.dateTimePicker6.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["cssj"].ToString();
this.dateTimePicker7.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["hdsj"].ToString();
this.textBox1.Text = ds.Tables["lab_rygl"].Rows[0]["bz"].ToString();
this.dateTimePicker8.Value = (DateTime)ds.Tables["lab_rygl"].Rows[0]["jdsj"].ToString();
}
else
{
MessageBox.Show("数据不存在!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
比较而言,最好用第二种方法。