读书人

建立料表出解决方案

发布时间: 2012-02-21 16:26:23 作者: rapoo

建立料表出
建立料表出 ?????

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))");

读书人网 >asp.net

热点推荐