建立資料表時出錯解决方案

建立資料表時出錯
建立資料表時出錯 ?????

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

查看更多 下一篇