Question

c#提示“insert into”语法错误

帮我查一下以下的错误语句,数据库：mssql2000

CREATE TABLE mobile (
id int(8) NOT NULL unique,
mobile varchar(7) NOT NULL,
province varchar(50) NOT NULL,
city varchar(50) NOT NULL,
type varchar(50) NOT NULL,
PRIMARY KEY (id)
)

INSERT INTO mobile ([id], [mobile],[ province], [city], [type]) VALUES
(1,'1300000', '北京','北京','联通130卡')

Answer 1

//插入语句
sql = "INSERT INTO mobile ([id], [mobile],[ province], [city], [type]) VALUES ( 1,'" + modsql("1300000") + "','" + modsql("北京") + "','" + modsql("北京") + "','" + modsql("联通130卡")+ "')";
//执行插入方法
db.ExeSql(conn, sql);
//处理插入语句
public string modsql(string sql)
{
return sql.Replace("'", "''");
}
//插入方法
public int ExeSql(string conn,string Sql)
{
OleDbConnection myConnection = new OleDbConnection(conn);
OleDbCommand myCommand = new OleDbCommand(Sql, myConnection);
myCommand.CommandTimeout = 10000;
try
{
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Dispose();
myConnection.Close();
return 1;
}
catch (Exception ex)
{
myConnection.Close();
//MessageBox.Show(ex.Message + "\r\n" + Sql);
return 0;
}
}

Answer 2

有两个错误。
1.建表时.int类型是不用指定长度的.id int(8) 肯定出错.改id int 就行了.
2.插入数据时[ province]里存在有空格.删除了那空格就可以插入了.

Answer 3

CREATE TABLE mobile (
id int NOT NULL unique,
mobile varchar(7) NOT NULL,
province varchar(50) NOT NULL,
city varchar(50) NOT NULL,
type varchar(50) NOT NULL,
PRIMARY KEY (id)
)

INSERT INTO mobile ([id], [mobile],[province], [city], [type]) VALUES
(1,'1300000', '北京','北京','联通130卡')

对比一下吧!!

Answer 4

[ province]多了一个空格

[province]