Server Error in '/' Application.

Incorrect syntax near the keyword 'Order'. (Select Top 1 ID From KoseYazilari Where YazarID= Order BY ID Desc)

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.Exception: Incorrect syntax near the keyword 'Order'. (Select Top 1 ID From KoseYazilari Where YazarID= Order BY ID Desc)

Source Error:


Line 173:            catch (SqlException ex)
Line 174:            {
Line 175:                throw new Exception(ex.Message + " (" + sql + ")");
Line 176:            }
Line 177:            adapter.Dispose();

Source File: c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\App_Code\MyFunction.cs    Line: 175

Stack Trace:


[Exception: Incorrect syntax near the keyword 'Order'. (Select Top 1 ID From KoseYazilari Where YazarID= Order BY ID Desc)]
   MyFunction.GetDataTable(String sql) in c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\App_Code\MyFunction.cs:175
   MyFunction.GetDataCell(String sql) in c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\App_Code\MyFunction.cs:251
   Ayarlar.SonKoseYazisininIDsiniGetir(String YazarID) in c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\App_Code\Settings.cs:692
   ASP.yazarlar_aspx.__DataBind__control59(Object sender, EventArgs e) in c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\yazarlar.aspx:166
   System.Web.UI.Control.OnDataBinding(EventArgs e) +84
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +150
   System.Web.UI.Control.DataBind() +17
   System.Web.UI.Control.DataBindChildren() +185
   System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +160
   System.Web.UI.Control.DataBind() +17
   System.Web.UI.WebControls.Repeater.CreateItem(Int32 itemIndex, ListItemType itemType, Boolean dataBind, Object dataItem) +126
   System.Web.UI.WebControls.Repeater.AddDataItemsIntoItemsArray(IEnumerable dataSource, Boolean useDataSource) +217
   System.Web.UI.WebControls.Repeater.PostGetDataAction(IEnumerable dataSource) +71
   System.Web.UI.WebControls.Repeater.CreateControlHierarchy(Boolean useDataSource) +220
   System.Web.UI.WebControls.Repeater.OnDataBinding(EventArgs e) +62
   System.Web.UI.WebControls.Repeater.DataBind() +77
   yazarlar.Page_Load(Object sender, EventArgs e) in c:\inetpub\vhosts\ar.milligazete.com.tr\httpdocs\yazarlar.aspx.cs:72
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
   System.Web.UI.Control.OnLoad(EventArgs e) +95
   System.Web.UI.Control.LoadRecursive() +59
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +780


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.2106.0