在操作将表中的数据填充到DateGrid中是出现如下图的问题,请朋友问指点迷津啊!
SqlConnection cnn=new SqlConnection();
cnn.ConnectionString="Data Source=myserver;initial catalog=school;uid=sa;ped=123";
DataSet ds=new DataSet();
SqlDataAdapter daStudent=new SqlDataAdapter("Select * From Student",cnn);
SqlCommandBuilder builderStudent=new SqlCommandBuilder(daStudent);
daStudent.Fill(ds,"Student");
SqlDataAdapter daSC=new SqlDataAdapter("Select * From SC",cnn);
SqlCommandBuilder builderSC=new SqlCommandBuilder(daSC);
daSC.Fill(ds,"SC");
SqlDataAdapter daCourse=new SqlDataAdapter("Select * From Course",cnn);
SqlCommandBuilder builderCourse=new SqlCommandBuilder(daCourse);
daCourse.Fill(ds,"Course");
this.cmbTables.Text="Student";
部分程序如上,想问哈在对不同的表格进行数据操作时,定义一个数据集可以吗?还是要定义多个数据集。小弟是刚接触这个软件,很多不懂的地方,望朋友们帮忙解释清楚点哈!