private void button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=4184085;database=students");
con.Open();
SqlCommand cmd = new SqlCommand("select stu_name,stu_psd from stu ", con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr.GetString(0);
textBox2.Text = sdr.GetString(1);
}
}我托了2个TextBox控件,用于读取数据库第一条students里姓名和密码的记录,为何调试不显示。
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=4184085;database=students");
con.Open();
SqlCommand cmd = new SqlCommand("select stu_name,stu_psd from stu ", con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr.GetString(0);
textBox2.Text = sdr.GetString(1);
}
}我托了2个TextBox控件,用于读取数据库第一条students里姓名和密码的记录,为何调试不显示。
2、你在调试状态下看看srd.GetString(0)是否有数据。
SqlDataReader sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
if(sdr.Read())
{
textBox1.Text = sdr.GetString(0);
textBox2.Text = sdr.GetString(1);
}
SqlDataReader sdr = cmd.ExecuteReader();
if(sdr.Read())
{
textBox1.Text = sdr["stu_name"];
textBox2.Text = sdr["stu_psd"];
}
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=4184085;database=students");
con.Open();
SqlCommand cmd = new SqlCommand("select stu_name,stu_psd from stu ", con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr.reader[0].ToString();
textBox2.Text = sdr.reader[0].ToString();
}
sdr.Close(); //这里的Reader对象必须要关闭
sdr.Dispose();
}
{
SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=4184085;database=students");
con.Open();
SqlCommand cmd = new SqlCommand("select stu_name,stu_psd from stu ", con);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
textBox1.Text = sdr[0].ToString();
textBox2.Text = sdr[1].ToString();
}
sdr.Close(); //这里的Reader对象必须要关闭
sdr.Dispose();
}