求帮忙!!!程序已正常运行,数据库里也有符合条件的数据。但为什么没有显示出来,求高手帮指出那里出错了,初学,希望可以详细些。
代码如下:private void button1_Click_1(object sender, EventArgs e)
{
string dl = Form1.dengluming;
SqlConnection conn = new SqlConnection();
string str = "Data Source=DJK-PC;Initial Catalog=图书管理系统;Integrated Security=True";
conn.ConnectionString = str;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from 借阅信息表 where reader_name =' dl ' ";
cmd.Connection = conn;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds,"借阅信息表");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "借阅信息表";
dataGridView1.AutoGenerateColumns = true;
cmd.ExecuteNonQuery();
conn.Close();
}
代码如下:private void button1_Click_1(object sender, EventArgs e)
{
string dl = Form1.dengluming;
SqlConnection conn = new SqlConnection();
string str = "Data Source=DJK-PC;Initial Catalog=图书管理系统;Integrated Security=True";
conn.ConnectionString = str;
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select * from 借阅信息表 where reader_name =' dl ' ";
cmd.Connection = conn;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds,"借阅信息表");
dataGridView1.DataSource = ds;
dataGridView1.DataMember = "借阅信息表";
dataGridView1.AutoGenerateColumns = true;
cmd.ExecuteNonQuery();
conn.Close();
}
二,把 cmd.ExecuteNonQuery(); 去掉
cmd.Connection = conn;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds,"借阅信息表");
dataGridView1.DataSource = ds.Tables["借阅信息表"];
conn.Close();
cmd.Connection = conn;
SqlDataAdapter ada = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ada.Fill(ds,"借阅信息表");
dataGridView1.DataSource = ds.Tables["借阅信息表"];
conn.Close();