在form1中我拖进一个datagridview2控件
在form1_load方法中队它进行设置;
this.dataGridView2.AutoGenerateColumns = true; SqlConnection projectconn = new SqlConnection(connstring);
DataSet rdset = new DataSet();
SqlDataAdapter projectadapter = new SqlDataAdapter(); string sqlstr2 = "select project_group,project_name from project";
SqlCommand comm2 = new SqlCommand(sqlstr2, projectconn);
projectadapter.SelectCommand = comm2; projectadapter.Fill(rdset);
dataGridView2.DataSource = rdset;
在dataGridView2.DataSource = rdset;设置断点发现projectadapter.Fill(rdset);已经将我要的数据读到了
欲将数据在datagridview2中显示,我将AutoGenerateColumns设置为true;然后datasource设置成rdset;
还缺少那些数据才能显示那些数据?
在form1_load方法中队它进行设置;
this.dataGridView2.AutoGenerateColumns = true; SqlConnection projectconn = new SqlConnection(connstring);
DataSet rdset = new DataSet();
SqlDataAdapter projectadapter = new SqlDataAdapter(); string sqlstr2 = "select project_group,project_name from project";
SqlCommand comm2 = new SqlCommand(sqlstr2, projectconn);
projectadapter.SelectCommand = comm2; projectadapter.Fill(rdset);
dataGridView2.DataSource = rdset;
在dataGridView2.DataSource = rdset;设置断点发现projectadapter.Fill(rdset);已经将我要的数据读到了
欲将数据在datagridview2中显示,我将AutoGenerateColumns设置为true;然后datasource设置成rdset;
还缺少那些数据才能显示那些数据?
string sqlstr2 = "select project_group,project_name from project"; SqlDataAdapter projectadapter = new SqlDataAdapter(sqlstr2, projectconn); DataSet rdset = new DataSet(); projectadapter.Fill(rdset); dataGridView2.DataSource = rdset.Tables[0];
dataGridView2.DataSource = rdset.Tables[0];
+1 将DataSet中第一张表与DataGridView绑定,或者你直接使用DataTable来储存数据,看你需要