[FaultException: Incorrect syntax near '='.
Incorrect syntax near the keyword 'From'.
select * from ( Select ROW_NUMBER() over ( order by PersonId desc ) as Row, From Person_View Content_GeneralID=21 ) as a where Row between (0) and ( 10) for XML RAW]
System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) +14508071
System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) +403
TolueShop.DynamicServiceReference.IDynamicService.Show_List_ByMenuID(String username, String password, Int32 MenuID, Int32 pagelenth, Int32 order_column, String order_dir, Int32 startRecord, String condition) +0
TolueShop.DynamicServiceReference.DynamicServiceClient.Show_List_ByMenuID(String username, String password, Int32 MenuID, Int32 pagelenth, Int32 order_column, String order_dir, Int32 startRecord, String condition) in C:\Users\tolue\Source\Workspaces\TolueShop\Service References\DynamicServiceReference\Reference.cs:348
TolueShop.Page.Content.Page_Load(Object sender, EventArgs e) in C:\Users\tolue\Source\Workspaces\TolueShop\Page\Content.aspx.cs:111
System.Web.UI.Control.OnLoad(EventArgs e) +108
System.Web.UI.Control.LoadRecursive() +90
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1533
|