再问一个INSERT INTO 语句的语法错误?

xiamin 2003-08-24 07:23:44

再问一个INSERT INTO 语句的语法错误?
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
private void btnOK_Click(object sender, System.EventArgs e)
{
OleDbConnection cn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("test.mdb"));
string cmdTxt="insert student(name,xuehao) values(@xm,@xh)";
OleDbCommand cm=new OleDbCommand(cmdTxt,cn);
cm.Parameters.Add("@xm","小杨"); //可用变量
cm.Parameters.Add("@xh","01");
cn.Open();
try
{
cm.ExecuteNonQuery();
Label1.Text="添加成功！";
}
catch(Exception ee)
{
Label1.Text="添加失败！错误信息:"+ee.ToString();
}

cn.Close();
}
</script>
<html>
<body>
<form runat="server" >
姓名:<asp:textbox id="TextBox1" runat="server" />
<BR>
学号:<asp:textbox id="TextBox2" runat="server" />
<asp:label id="Label1" runat="server" />
<BR>
<asp:button text="确定" onclick="btnOK_Click" runat="server" />
</form>
</body>
</html>

出现
添加失败！错误信息:System.Data.OleDb.OleDbException: INSERT INTO 语句的语法错误。 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at ASP.insert1_ASPX.btnOK_Click(Object sender, EventArgs e)

...全文

119 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

spiketang 2003-08-24

打赏
举报

很明显的问题你的into没有啦!
应该是insert into table() values()

panyee 2003-08-24

打赏
举报

string cmdTxt="insert student(name,xuehao) values(?,?)";
OleDbCommand cm=new OleDbCommand(cmdTxt,cn);
cm.Parameters.Add("@xm",OleDbType.VarChar, 255, "xm").Value = "小杨"; cm.Parameters.Add("@xh",OleDbType.VarChar, 255, "xh").Value = "01";

BrownTerran 2003-08-24