该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
string connString = new MySQLConnectionString("localhost", "CourseSelectionSys", "root", "960727",3306).AsString;
MySQLConnection conn = new MySQLConnection();
//静态变量opennum用来指示页面是不是首次加载,为0时表示首次加载
private static int opennum = 0;
//静态变量dataset1用来存放窗体中的数据
public static DataSet dataset1;
private void MainForm_Load(object sender, EventArgs e)
{
opennum++;
conn.ConnectionString = connString;
conn.Open();
//填充第一个个选项卡上的DataGridView控件
string sqlString = "select cno 课程号,cname 课程名,ccredit 学分,cdetail 备注 from course";
MySQLCommand cmd = new MySQLCommand();
cmd.CommandText = sqlString;
cmd.Connection = conn;
MySQLDataAdapter dataadapter1 = new MySQLDataAdapter(); //出错点
dataadapter1.SelectCommand = cmd;
dataset1 = new DataSet();
//调用MYSQLDataAdapter的Fill方法,填充数据集
dataadapter1.Fill(dataset1,"Course");
conn.Close();
//将获得的数据集作为DataGridView的数据源
this.dataGridView1.DataSource = dataset1.Tables["Course"];
//填充第二个选项卡上的DataGridView控件
string sqlString1 = "select * from tcinfo";
cmd.CommandText = sqlString1;
cmd.Connection = conn;
dataadapter1.SelectCommand = cmd;
dataadapter1.Fill(dataset1, "TCInfo");
this.dataGridView2.DataSource = dataset1.Tables["TCInfo"];
this.dataGridView2.ReadOnly = true;
//填充第三选项卡上的控件
string sqlString2 = "select * from scinfoadmin";
cmd.CommandText = sqlString2;
cmd.Connection = conn;
conn.Close();
conn.Open();
dataadapter1.SelectCommand = cmd;
dataset1.Tables["SCInfo"].Clear();
dataadapter1.Fill(dataset1, "SCInfo");
this.dataGridView3.DataSource = dataset1.Tables["SCInfo"];
this.dataGridView3.ReadOnly = true;
}
在出错点设了断电,运行到这里点继续就会停止运行,为了测试我在数据库的每个表每个视图都添加了一行数据,不知道这会不会影响?嘤嘤嘤嘤~~~求大神解决MYSQLDataAdapter总是停止运行的问题~~