求大神求大神急需

qq_34312453 2016-03-29 05:02:51

“/”应用程序中的服务器错误。

关键字 'Order' 附近有语法错误。
说明: 执行当前 Web 请求期间，出现未经处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 关键字 'Order' 附近有语法错误。

源错误:

行 171: SqlDataAdapter da = new SqlDataAdapter(cmd);
行 172: DataTable dt = new DataTable();
行 173: da.Fill(dt);
行 174: conn.Close();
行 175: return dt;

源文件: D:\SVN\TheStooges.dal\SqlHelper.cs 行: 173

堆栈跟踪:

[SqlException (0x80131904): 关键字 'Order' 附近有语法错误。]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2442030
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5736648
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +628
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +3731
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
System.Data.SqlClient.SqlDataReader.get_MetaData() +89
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +379
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2026
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +375
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +12
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +139
System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +160
System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +108
TheStooges.dal.SqlHelper.SelectForDT(String sql) in D:\SVN\TheStooges.dal\SqlHelper.cs:173
ASP.admin_billing_order_billing_aspx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) in d:\SVN\TheStooges\admin\Billing order\billing.aspx:59
System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) +268
System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +13
System.Web.UI.Page.Render(HtmlTextWriter writer) +29
System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +66
System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +100
System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +25
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5827

版本信息: Microsoft .NET Framework 版本:4.0.30319; ASP.NET 版本:4.6.1073.0

源码
<th>
id
</th>
<th>
财务账号
</th>
<th>
财务密码
</th>
<th>
介绍
</th>
<th style="width: 150px;">
</th>
</tr>
</thead>
<tbody>
<%
int page = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"]);
System.Data.DataTable uadmin = TheStooges.dal.SqlHelper.SelectForDT(String.Format("select * from Order"));

%>
<%
if (uadmin.Rows.Count > 0)
{
for (int i = 0; i < uadmin.Rows.Count; i++)
{
%>
<tr>
<td>
<%=i+1 %>
(<%=uadmin.Rows[i]["id"]%>)
</td>
<td>
<%=uadmin.Rows[i]["Order_time"].ToString()%>
</td>
<td>
<%=uadmin.Rows[i]["Order_cont"].ToString()%>
</td>
<td>
<%=uadmin.Rows[i]["Order_shou"].ToString()%>
</td>
<td>

namespace TheStooges.admin.Billing_order
{
public partial class billing : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["id2"] != null)
{
if (Request.QueryString["id2"].Equals("del"))
{
bool em = SqlHelper.update("delete from Order where id =" + int.Parse(Request.QueryString["ids"].ToString()));
if (em == true)
{
Response.Write("<script>alert('删除成功！');window.location.href='billing.aspx';</script>");
}
else
{
Response.Write("<script>alert('删除失败！');window.location.href='billing.aspx';</script>");
}
}
}
}
}
}
}

...全文