两种方式读取数据库显示。

来源：互联网发布：软件photocard 编辑：程序博客网时间：2024/06/08 04:19

第一种：用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);
            }

比较而言，最好用第二种方法。