mysql dataadapter.fill_关于MYSQLDataAdapter总是报错的问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

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总是停止运行的问题~~