帮看一条SQL语句，错哪了

2012-09-13

帮看一条SQL语句，哪里错了string strupdate insert into table16 (title,username,time,content,class)

帮看一条SQL语句，哪里错了
string strupdate = "insert into table16 (title,username,time,content,class) values (" + TextBox1.Text.ToString() + " , " + "' 1 '" + " ,"+ DateTime.Now+ ", " + TextBox4.Text.ToString() + " , " + "'1'" + " )";
就是上面这句，求指教

[解决办法]

C# code

--字符串都要加单引号引起来的string strupdate = "insert into table16 (title,username,time,content,class) values ('" + TextBox1.Text.ToString() + "' , " + "' 1 '" + " ,'"+ DateTime.Now+ "', '" + TextBox4.Text.ToString() + "' , " + "'1'" + " )";
[解决办法]
试试把DateTime.Now改为DateTime.Now.ToString()
[解决办法]
拼出来的句子 字符串和日期要有单引号,你的没有

热点排行

Bad Request.

SQL Server

帮看一条SQL语句，错哪了