建立料表出
建立料表出 ?????
- C# code
string connString = WebConfigurationManager.ConnectionStrings["CnString"].ConnectionString; SqlConnection conn = new SqlConnection(connString); conn.Open(); string SQL =("CREATE TABLE a (Id int NOT NULL ," + "Name varchar (30)," + "Subbranch varchar(30)," + "ErrorCode varchar(5)"); SqlCommand objCommand = new SqlCommand(SQL, conn); objCommand.ExecuteNonQuery(); conn.Close(); conn.Dispose();果 :
接近 ')' 之的法不正
objCommand.ExecuteNonQuery();
[解决办法]
不懂了?你这句话:string SQL =("CREATE TABLE a (Id int NOT NULL ," + "Name varchar (30)," + "Subbranch varchar(30)," + "ErrorCode varchar(5)");一前一后干嘛要用一个括号啊?把括号去掉......
[解决办法]
创建语句少了一个右括号
[解决办法]
string SQL =("CREATE TABLE a (Id int NOT NULL ," + "Name varchar (30)," + "Subbranch varchar(30)," + "ErrorCode varchar(5)");
==》
string SQL =("CREATE TABLE a (Id int NOT NULL ," + "Name varchar (30)," + "Subbranch varchar(30)," + "ErrorCode varchar(5))");