'13' 附近有语法错误。

[一剑]

运行如下代码出现：
'13' 附近有语法错误，不知道怎么解决，请教啊

try
{
string strIP = this.Request.ServerVariables.Get("HTTP_X_FORWARDED_FOR");
if( strIP == "" )
strIP = this.Request.ServerVariables.Get("REMOTE_ADDR");

SqlConnection objConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["RmmWeb"].ConnectionString);
StringBuilder strSQL = new StringBuilder("INSERT INTO msgboard(name,email,ttext,date,ip) values('");
strSQL.Append(this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox3.Text );
strSQL.Append("'," + DateTime.Now + ",'" + strIP + "')");

SqlCommand objCommand = new SqlCommand(strSQL.ToString(), objConnection);
objConnection.Open();
objCommand.ExecuteNonQuery();
objConnection.Close();
this.Response.Redirect("Message.aspx?page=" + this.Request["page"]);
}
catch(Exception ex)
{
this.Label1.Text = ex.Message;
}

[amandag]

StringBuilder strSQL = new StringBuilder("INSERT INTO msgboard(name,email,ttext,date,ip) values('");
strSQL.Append(this.TextBox1.Text + "','" + this.TextBox2.Text + "','" + this.TextBox3.Text );
strSQL.Append("','" + DateTime.Now.ToString() + "','" + strIP + "')");

[jinjazz]

strSQL.Append("','" + DateTime.Now + "','" + strIP + "')");

[lovefootball]

" + DateTime.Now + "
--》
'" + DateTime.Now + "'

你可以把SQL打印出来看看就知道了

[xray2005]

strSQL.Append("','" + DateTime.Now.ToString() + "','" + strIP + "')");

[spkl1]

jf

[hyde100]

strSQL.Append("'," + DateTime.Now + ",'" + strIP + "')");
======================
很奇怪了

[jiatong1981]

SqlCstrSQL.Append("'," + DateTime.Now + ",'" + strIP + "')");
============================================================================

strSQL.Append("','" + DateTime.Now + "','" + strIP + "')");

[一剑]

呵呵，多谢上面的朋友的回复！！
再问一个如何取得客户端IP地址呢？
我用下面几行代码取的是空字符串啊？为什么怎么解决呢？
string strIP = this.Request.ServerVariables.Get("HTTP_X_FORWARDED_FOR");
if( strIP == "" )
strIP = this.Request.ServerVariables.Get("REMOTE_ADDR");

[lovefootball]

REMOTE_HOST

[lovefootball]

http://www.cnblogs.com/winner/archive/2007/05/12/743614.html

[一剑]

解决了，我的方法如下：
string strIP = "";
if (HttpContext.Current.Request.ServerVariables["HTTP_VIA"] != null)
{
strIP = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString();
}
else
{
strIP = HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"].ToString();
}