c#一个界面两个DataGridView控件分别绑定两张不同的表

weixin_41576202 2018-07-08 09:47:25

因为是大作业，所以语言是刚在自学网上自学的，希望有简单的解决方式。
代码如下：

第二章表加载不出来。。。我觉得可能绑定方式出错了

private void Choosetest_Load(object sender, EventArgs e)
{
// TODO: 这行代码将数据加载到表“zmyDataSet7.test”中。您可以根据需要移动或删除它。
this.testTableAdapter1.Fill(this.zmyDataSet7.test);
dgvbingmode.DataSource = BindModeSource().Tables[0];
dgvbindmode2.DataSource = BindModeSource2();

}
private DataSet BindModeSource()
{
string constr = "Server=desktop-pc92j7m;integrated security=SSPI;Initial Catalog=zmy";
SqlConnection mysqlCon = new SqlConnection(constr);
DataSet myds = new DataSet();
try
{
mysqlCon.Open();
string sql = "select * from student where sname='"+username+"'";
SqlDataAdapter myda = new SqlDataAdapter(sql, mysqlCon);
myda.Fill(myds, "personinformation");

}
catch (Exception ex)
{
MessageBox.Show("ex.message");

}
finally
{
mysqlCon.Close();
}

return myds;

}

private DataSet BindModeSource2()
{
string constr = "Server=desktop-pc92j7m;integrated security=SSPI;Initial Catalog=zmy";
SqlConnection mysqlCon = new SqlConnection(constr);
DataSet myds2 = new DataSet();
try
{
mysqlCon.Open();
string sql = "select * from studenttest where sname='" + username + "'";
SqlDataAdapter myda2 = new SqlDataAdapter(sql, mysqlCon);
myda2.Fill(myds2, "baominginfomation");
this.dgvbindmode2.DataSource = myds2.Tables["studenttest"];
}
catch (Exception ex)
{
MessageBox.Show("ex.message!");

}
finally
{
mysqlCon.Close();
}

return myds2;
}

...全文