dbAdpter.Fill( dbDset, TableName );// '=' 附近有语法错误
第 1 行: '=' 附近有语法错误。
说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中导致错误的出处的详细信息。
异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: '=' 附近有语法错误。
源错误:
行 85:
行 86: dbAdpter = new SqlDataAdapter( SQL, dbConn );
行 87: dbAdpter.Fill( dbDset, TableName );//提示错误行
行 88: dbAdpter.Dispose();
行 89: return dbDset;
源文件: f:\wwwroot\websearch\dataaccess\database.cs 行: 87
堆栈跟踪:
[SqlException: 第 1 行: '=' 附近有语法错误。]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
WebSearch.Database._Database.ExecuteDataSet(String SQL, String TableName) in f:\wwwroot\websearch\dataaccess\database.cs:87
WebSearch._default.btnTopSearch_Click(Object sender, EventArgs e) in f:\wwwroot\websearch\default.aspx.cs:74
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +58
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1292
下面是我的原程序:
//用Adapter选取数据,返回DataSet
public static DataSet ExecuteDataSet( string SQL ,string TableName)
{
SqlDataAdapter dbAdpter;
DataSet dbDset = new DataSet();
dbAdpter = new SqlDataAdapter( SQL, dbConn );
dbAdpter.Fill( dbDset, TableName );
dbAdpter.Dispose();
return dbDset;
}
真晕了,大家帮忙呀,谢谢了