INSERT INTO 语句的语法错误?

xiamin 2003-08-24 06:53:37

ACCESS2000库test.mdb的student表（name,number），C#往库中插入一条记录string strSQL="insert into student(name,number) values
('"+TextBox1.Text+"','"+TextBox2.Text+"')";
INSERT INTO 语句的语法错误?
改为
string strSQL="insert into student(name,[number]) values
('"+TextBox1.Text+"','"+TextBox2.Text+"')";
就对了，原因呢？
number是关键字，字段名加[]
我试过number不是关键字，也必须加[]才能通过，为什么？

...全文

22 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

eeeren 2003-08-24

打赏
举报

晓得了

xiamin 2003-08-24

打赏
举报

再问一个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)

aquariusBoy 2003-08-24