想把这段文体写入数据库中:/*
On Error Resume Next
Dim strTempIf LCase(Request.ServerVariables("HTTPS")) = "off" Then
strTemp = "http://"
Else
strTemp = "https://"
End IfstrTemp = strTemp & Request.ServerVariables("SERVER_NAME")
If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & Request.ServerVariables("SERVER_PORT")strTemp = strTemp & Request.ServerVariables("URL")If Trim(Request.QueryString) <> "" Then strTemp = strTemp & "?" & Trim(Request.QueryString)strTemp = LCase(strTemp)If Instr(strTemp,"select%20") or Instr(strTemp,"insert%20") or Instr(strTemp,"delete%20from") or Instr(strTemp,"count(") or Instr(strTemp,"drop%20table") or Instr(strTemp,"update%20") or Instr(strTemp,"truncate%20") or Instr(strTemp,"asc(") or Instr(strTemp,"mid(") or Instr(strTemp,"char(") or Instr(strTemp,"xp_cmdshell") or Instr(strTemp,"exec%20master") or Instr(strTemp,"net%20localgroup%20administrators") or Instr(strTemp,":") or Instr(strTemp,"net%20user") or Instr(strTemp,"'") or Instr(strTemp,"%20or%20") then
Response.Write "<script language='javascript'>"
Response.Write "alert('非法地址!!');"
Response.Write "location.href='error.asp';"
Response.Write "<script>"
End If
*/
string SqlInsert = "Insert into Program (Content) Values('"+strContent+"')";
SqlCommand myCommandInsert = new SqlCommand(SqlInsert,Conn);
myCommandInsert.ExecuteNonQuery ();
用这种方法,总是出错,,说是SQl语句有误
用什么方法,写入,能不错,,,,
On Error Resume Next
Dim strTempIf LCase(Request.ServerVariables("HTTPS")) = "off" Then
strTemp = "http://"
Else
strTemp = "https://"
End IfstrTemp = strTemp & Request.ServerVariables("SERVER_NAME")
If Request.ServerVariables("SERVER_PORT") <> 80 Then strTemp = strTemp & ":" & Request.ServerVariables("SERVER_PORT")strTemp = strTemp & Request.ServerVariables("URL")If Trim(Request.QueryString) <> "" Then strTemp = strTemp & "?" & Trim(Request.QueryString)strTemp = LCase(strTemp)If Instr(strTemp,"select%20") or Instr(strTemp,"insert%20") or Instr(strTemp,"delete%20from") or Instr(strTemp,"count(") or Instr(strTemp,"drop%20table") or Instr(strTemp,"update%20") or Instr(strTemp,"truncate%20") or Instr(strTemp,"asc(") or Instr(strTemp,"mid(") or Instr(strTemp,"char(") or Instr(strTemp,"xp_cmdshell") or Instr(strTemp,"exec%20master") or Instr(strTemp,"net%20localgroup%20administrators") or Instr(strTemp,":") or Instr(strTemp,"net%20user") or Instr(strTemp,"'") or Instr(strTemp,"%20or%20") then
Response.Write "<script language='javascript'>"
Response.Write "alert('非法地址!!');"
Response.Write "location.href='error.asp';"
Response.Write "<script>"
End If
*/
string SqlInsert = "Insert into Program (Content) Values('"+strContent+"')";
SqlCommand myCommandInsert = new SqlCommand(SqlInsert,Conn);
myCommandInsert.ExecuteNonQuery ();
用这种方法,总是出错,,说是SQl语句有误
用什么方法,写入,能不错,,,,
有可能你的表名或字段名是关键字
string SqlInsert = "Insert into Program (Content) Values('"+Replace(trim(strContent),"'","''")+"')";
SqlCommand myCommandInsert = new SqlCommand(SqlInsert,Conn);
myCommandInsert.ExecuteNonQuery ();
string SqlInsert = "Insert into Program (Content) Values('"+strContent+"')";
SqlCommand myCommandInsert = new SqlCommand(SqlInsert,Conn);
myCommandInsert.ExecuteNonQuery ();
用命令参数吧,就是SqlCommand.Parameters