语法分析出错
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: 语法分析出错源错误:
行 91: try
行 92: {
行 93: cm.ExecuteNonQuery();
行 94: Lbl_note2.Text=" 选课成功!";
行 95: }
源文件: c:\DZY\xuanke1.aspx.cs 行: 93 堆栈跟踪:
[OleDbException (0x80040e14): 语法分析出错]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
Student_Class.xuanke1.Btn_yes_Click(Object sender, EventArgs e) in c:\DZY\xuanke1.aspx.cs:93
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4882 代码:
string strconn = ConfigurationSettings.AppSettings["dsn"];
OleDbConnection cn = new OleDbConnection(strconn);
cn.ConnectionString = "Provider=DMOLEDB.1; Data Source=LOCALHOST; Initial Catalog=S_CLASS; User ID=U1; Password=a123456; ";
cn.Open();
strsql = "insert into S_CLASS.CLASS.student_course(Student_id,Course_id)values@Student_id,@Course_id)";
OleDbCommand cm = new OleDbCommand(strsql, cn);
cm.Parameters.Add(new OleDbParameter("@Student_id", OleDbType.VarChar, 200));
cm.Parameters.Add(new OleDbParameter("@Course_id", OleDbType.VarChar, 200));
cm.Parameters["@Student_id"].Value=Session["User_id"].ToString();
cm.Parameters["@Course_id"].Value=Tbx_courseid.Text;
try
{
cm.ExecuteNonQuery();
Lbl_note2.Text=" 选课成功!";
}
catch(SqlException)
{
Lbl_note.Text="添加失败!";
}
cn.Close();
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。 异常详细信息: System.Data.OleDb.OleDbException: 语法分析出错源错误:
行 91: try
行 92: {
行 93: cm.ExecuteNonQuery();
行 94: Lbl_note2.Text=" 选课成功!";
行 95: }
源文件: c:\DZY\xuanke1.aspx.cs 行: 93 堆栈跟踪:
[OleDbException (0x80040e14): 语法分析出错]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +177
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +194
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +56
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +105
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() +88
Student_Class.xuanke1.Btn_yes_Click(Object sender, EventArgs e) in c:\DZY\xuanke1.aspx.cs:93
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +97
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4882 代码:
string strconn = ConfigurationSettings.AppSettings["dsn"];
OleDbConnection cn = new OleDbConnection(strconn);
cn.ConnectionString = "Provider=DMOLEDB.1; Data Source=LOCALHOST; Initial Catalog=S_CLASS; User ID=U1; Password=a123456; ";
cn.Open();
strsql = "insert into S_CLASS.CLASS.student_course(Student_id,Course_id)values@Student_id,@Course_id)";
OleDbCommand cm = new OleDbCommand(strsql, cn);
cm.Parameters.Add(new OleDbParameter("@Student_id", OleDbType.VarChar, 200));
cm.Parameters.Add(new OleDbParameter("@Course_id", OleDbType.VarChar, 200));
cm.Parameters["@Student_id"].Value=Session["User_id"].ToString();
cm.Parameters["@Course_id"].Value=Tbx_courseid.Text;
try
{
cm.ExecuteNonQuery();
Lbl_note2.Text=" 选课成功!";
}
catch(SqlException)
{
Lbl_note.Text="添加失败!";
}
cn.Close();
解决方案 »
- mvc dropdownlist取值问题
- sqldatasouce参数源加静态变量类型
- “/wet”应用程序中的服务器错误。过程或函数 'up_GetBookByCategory_Pages' 需要参数 '@categoryId',但未提供该参数
- 求救!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 请高手解答DataGrid问题。
- 提问:关于BUTTON和回车键
- 初学asp.net遇到的ADO.net的一些问题
- 请高手回答!!使用表单票据验证,应该很安全的吧,能不能防止 COOKIE欺骗呢??
- 怎么在global.asax中的Session_Start中插入<script src="count.aspx"></script>?
- 如何将存储过程的结果集提到dataset里呀?请各位多多帮忙了,在此表示感谢了。
- DataTable分页
- 怎么给txt文件中写入xml
string strconn = ConfigurationSettings.AppSettings["dsn"];
OleDbConnection cn = new OleDbConnection(strconn);
cn.ConnectionString = "Provider=DMOLEDB.1; Data Source=LOCALHOST; Initial Catalog=S_CLASS; User ID=U1; Password=a123456; ";
cn.Open();
strsql = "insert into S_CLASS.CLASS.student_course(Student_id,Course_id) values(@Student_id,@Course_id)";
OleDbCommand cm = new OleDbCommand(strsql, cn);
cm.Parameters.Add(new OleDbParameter("@Student_id", OleDbType.VarChar, 200));
cm.Parameters.Add(new OleDbParameter("@Course_id", OleDbType.VarChar, 200));
cm.Parameters["@Student_id"].Value=Session["User_id"].ToString();
cm.Parameters["@Course_id"].Value=Tbx_courseid.Text;
try
{
cm.ExecuteNonQuery();
Lbl_note2.Text=" 选课成功!";
}
catch(SqlException)
{
Lbl_note.Text="添加失败!";
}
cn.Close();