asp中插入数据到数据库的问题

来源:百度知道 编辑:UC知道 时间:2024/06/21 18:42:39
我快疯了.

string strSQLPost = "INSERT INTO [goodluck].[dbo].[commentInfo] ([articleid] ,[cmtid] ,[flag] ,[cmtcontent] ,[cmtuserid],[cmtnickname],[cmtdate],[updatedate],[updateuserid],[updatetimes]) VALUES ('" + aid + "','" + strCmtid + "','0' ,'" + strCmtcontent + "','" + strUserid + "' ,'" + strNickname + "' ,'" + strTime + "','" + strTime + "','" + strUserid + "','0')";

string m_strDBSetting = ConfigurationManager.ConnectionStrings["goodluckConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(m_strDBSetting);
SqlCommand comm = new SqlCommand(strSQLPost , conn);
conn.Open();
comm.ExecuteNonQuery();
conn.Close();

其中的strCmtid 无论如何插入都是0.别的都是好的.
就他怎么都是零.为什么?
我即使在它的上面写strCmtid = &

把+号改成&号。
string strSQLPost = "INSERT INTO [goodluck].[dbo].[commentInfo] ([articleid] ,[cmtid] ,[flag] ,[cmtcontent] ,[cmtuserid],[cmtnickname],[cmtdate],[updatedate],[updateuserid],[updatetimes]) VALUES ('" & aid & "','" & strCmtid & "',0 ,'" + strCmtcontent &"','" & strUserid & "' ,'" & strNickname+ "' ,'" & strTime & "','" &strTime & "','" &strUserid & "',0)";

strCmtid 是在什么时候定度的变量?

加断点,很快就能看出来的