private void RegUpd_Load(object sender, EventArgs e)
{ DataSet QryStudClassset = new DataSet(); string NewStuStrConnSql = "select NAME form CLASS";
this.NewStuConn = new SqlConnection(this.NewStuStrConn);
NewStuConn.Open();
this.NewStusqlda = new SqlDataAdapter(NewStuStrConnSql, this.NewStuConn);
QryStudClassset.Clear();
this.NewStusqlda.Fill(QryStudClassset, "Class");
for (int i = 1; i < QryStudClassset.Tables[0].Rows.Count; i++)
{
Class.Items.Add(QryStudClassset.Tables[0].Rows[i][0]);
} Class.SelectedIndex = 0;
} 提示名:未处理SqlException 内容: CLASS附近有语法错误, 连接字符串:private String NewStuStrConn="Data Source=WWW-F9EEA54BDCA;Initial Catalog=STUDENT;User ID=sa;Pwd=jxlsqd;Integrated Security=False"; 新手 请大家帮忙解决啊···
{ DataSet QryStudClassset = new DataSet(); string NewStuStrConnSql = "select NAME form CLASS";
this.NewStuConn = new SqlConnection(this.NewStuStrConn);
NewStuConn.Open();
this.NewStusqlda = new SqlDataAdapter(NewStuStrConnSql, this.NewStuConn);
QryStudClassset.Clear();
this.NewStusqlda.Fill(QryStudClassset, "Class");
for (int i = 1; i < QryStudClassset.Tables[0].Rows.Count; i++)
{
Class.Items.Add(QryStudClassset.Tables[0].Rows[i][0]);
} Class.SelectedIndex = 0;
} 提示名:未处理SqlException 内容: CLASS附近有语法错误, 连接字符串:private String NewStuStrConn="Data Source=WWW-F9EEA54BDCA;Initial Catalog=STUDENT;User ID=sa;Pwd=jxlsqd;Integrated Security=False"; 新手 请大家帮忙解决啊···
换个连接字符串试试!还有你定义连接对象的代码也没贴出来嘛!
Fill: SelectCommand.Connection 属性尚未初始化。
NewStuConn 我定义过了