我的一段程序出错,请帮我看看.急!!!

[xingONE]

我有这样一段程序
string InsertNewsStr = "INSERT INTO message_board(title,text1,date1,name1,sex) VALUES ('"+Text_Title.Value.Trim()+"','"+TEXTAREA1.Value.Trim()+"','"+Text_name.Value.Trim()+"'," + add_date + ",'"+sex+"')";
System.Data.OleDb.OleDbCommand CountCommd = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbConnection ConnData = new System.Data.OleDb.OleDbConnection();
ConnData.ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["MIS"];
CountCommd.Connection = ConnData;//初始化连接
CountCommd.CommandText = InsertNewsStr;
try
{
ConnData.Open();
CountCommd.ExecuteNonQuery();
ConnData.Close();
ConnData.Dispose();
CountCommd.Dispose();
}
catch(Exception ErrText)
{
this.Session["ErrMess"] = ErrText.ToString();
this.Response.Redirect("WebForm_ErrMess.aspx");
}

出错为：
System.Data.OleDb.OleDbException: 语法错误 (操作符丢失) 在查询表达式 '2004-6-29 16:40:35' 中。 at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at MakeKing.Message_board1.Image1_ServerClick(Object sender, ImageClickEventArgs e) in e:\inetpub\wwwroot\makeking\message_board1.aspx.cs:line 163

[rickjelly2004]

INSERT INTO message_board(title,text1,date1,name1,sex) VALUES ('"+Text_Title.Value.Trim()+"','"+TEXTAREA1.Value.Trim()+"','"+Text_name.Value.Trim()+"'," + add_date + ",'"+sex+"')";



写清楚点

[xingONE]

我是需要往一张表中插入数据。请给个例子。

[coollzh]

把sql 用System.Diagnostics.Debug.WriteLine() print出来看看，在sql server里执行一吧