How can I know the location of error by Stack Trace given?

miss nadia

I've checked many times for the incorrect syntax. But couldn't find any. There's no given location for the specific error. Here is the error and Stack Trace given when I run the appliication.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'Order'.

Stack Trace:

[SqlException (0x80131904): Incorrect syntax near the keyword 'Order'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +925466
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800118
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1932
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31
System.Data.SqlClient.SqlDataReader.get_MetaData() +62
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1005
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +7
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +83
Syst

N a v a n e e t h

miss nadia wrote:

There's no given location for the specific error

It would be in the query you given in SQLDataSource.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

Vasudevan Deepak Kumar

miss nadia wrote:

How can I know the location

Walking through the StackTrace, doesn't it indicate the affected classes from your application?

Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

N a v a n e e t h

Vasudevan Deepak Kumar wrote:

Walking through the StackTrace, doesn't it indicate the affected classes from your application?

I doubt, since OP uses nasty SQLDataSource for binding.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

Vasudevan Deepak Kumar

True. And for a beginner, it would be a significantly scary.

Vasudevan Deepak Kumar Personal Homepage
Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Christian Graus

The error is obvious. How many places do you use the keyword 'order' in your code ? Perhaps if you post your SQL we can help ?

Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Herman T Instance

I guess I would add a space after the word Order. I guess that you concatenate strings like String query = String.Empty; query += "Select * FROM Order"; query += "Where Value = 1"; if you would check the content of the string query it would read: Select * FROM OrderWhere Value = 1 Maybe this makes your problem clear.

miss nadia

What does it means by OP? does this error looks complex? i hope it is not since i'm a beginner. i will post the codes and hope all of you will help.

miss nadia

I'm using Web User Control for Order.aspx file. This is SQL code for Order.ascx.

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ProjectConnectionString %>"
SelectCommand="SELECT Order.OrderNum, Order.OrderDate, Order.CustEmail, Order.Subtotal, Order.Shipping, Order.Total,
Customers.LastName, Customers.FirstName, Customers.Address, Customers.City, Customers.State, Customers.PostCode, Customers.Phone, Customers.Country
FROM Order
INNER JOIN Customers
ON Order.CustEmail=Customers.Email
WHERE Order.OrderNum=@OrderNum
ORDER BY Order.OrderNum">
<SelectParameters>
<asp:SessionParameter Name="OrderNum" SessionField="OrderNum" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:ProjectConnectionString %>"
SelectCommand="SELECT [ProductId], [Name], [Price], [Quantity], [Total], [OrderNum]
FROM [OrderItems]
WHERE ([OrderNum]=@OrderNum)
ORDER BY [ProductId]">
<SelectParameters>
<asp:ControlParameter Name="OrderNum" ControlID="FormView1"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>

miss nadia

And this is code for Order.aspx. Incorrect syntax that I can't find. That makes me really worried!

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" AutoEventWireup="False" %>
<%@ Register Src="~/Manage/Order.ascx" TagName="Order" TagPrefix="uc1" %>

Protected Sub Page\_Load(ByVal sender As Object, ByVal e As System.EventArgs)
    If Not IsPostBack Then
        ddlOrder.DataBind()
    End If
    Session("OrderNum") = ddlOrder.SelectedValue
End Sub

</script>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
Choose an order to display:
<asp:DropDownList ID="ddlOrder" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="OrderNum"
DataValueField="OrderNum">
</asp:DropDownList>
<asp:LinkButton ID="LinkButton1" runat="server"
PostBackUrl="~/Manage/PrintOrder.aspx">Print this page</asp:LinkButton>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ProjectConnectionString %>"
SelectCommand="SELECT OrderNum FROM Order ORDER BY OrderNum">
</asp:SqlDataSource><br /><br />
<uc1:Order ID="Order1" runat="server" />
</asp:Content>