我是初学者,请各位高手帮忙,,,,在线等,急..........
if (Request.QueryString["ID"] == null)
{
string intoSQL = "";
intoSQL = "insert into webabout(nFile,nTitle,nHtmlText) values (";
intoSQL += "" + txtid.Text + ",";
intoSQL += "'" + txtitle.Text + "',";
intoSQL += "'" + txtContent.Text + "')";
dbobj.getcom("insert into " + intoSQL);
public SqlConnection getcon()
{
string myStr = ConfigurationManager.AppSettings["ConnectionString"].ToString();
// string myStr = "server=ADMIN;database=test;User id=sa;password=123";
SqlConnection Sqlcon = new SqlConnection(myStr);
return Sqlcon;
}
#endregion
#region
public void getcom(string M_str_Sqlstr)
{
using (SqlConnection Sqlcon = this.getcon())
{
Sqlcon.Open();
SqlCommand Sqlcom = new SqlCommand(M_str_Sqlstr, Sqlcon);
Sqlcom.ExecuteNonQuery();
}
}
#endregion
异常详细信息: System.Data.SqlClient.SqlException: 关键字 'insert' 附近有语法错误。
源错误:
行 39: Sqlcon.Open();
行 40: SqlCommand Sqlcom = new SqlCommand(M_str_Sqlstr, Sqlcon);
行 41: Sqlcom.ExecuteNonQuery();
行 42: }
行 43: }
源文件: f:\wangzhang\scnet\App_Code\Class1.cs 行: 41
堆栈跟踪:
[SqlException (0x80131904): 关键字 'insert' 附近有语法错误。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +109
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +57
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2421
System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) +192
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +256
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +117
Class1.getcom(String M_str_Sqlstr) in f:\wangzhang\scnet\App_Code\Class1.cs:41
manage_netset_Aboutedit.btnsave_Click(Object sender, EventArgs e) in f:\wangzhang\scnet\manage\netset\Aboutedit.aspx.cs:65
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +78
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +100
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2867
这是什么原因,,,表为webabout,,,字段为wenFile int nTitle nvarchar(max) nHtmlText next