How to do order by in your paging using ROW_NUMBER() feature on SQL Server 2005 SELECT a.CurrentPrice, a.LotQuantity, a.IsAuction, a.AuctionID, a.AuctionName, a.DateStart, a.DateFinish, a.StartingPrice, a.ReservePrice, a.FixedPrice, a.BidIncrement, p.ProductID, p.CategoryID, p.BrandID, p.ProductName, p.ContentID, p.ThumbImageID, Row_Number() OVER (…
A few days back I’ve got the error message “webform_dopostbackwithoptions is undefined” on the project that i’m working on. The strange thing it happened only when I activated the securepagemodule, when i deactivated the module it…
Basic Requirements: 1. Have the MSDTC(Distributed Transaction Coordinator) windows service running on your machine 2. Be talking to a SQL 2000 or 2005 Database configured likewise 3. Run this registry script to fix the windows XP…
I’ve got this error and try to spend almost an hour to resolve this: “the server committed a protocol violation section= responsestatusline” when I tried to get the response back from the payment gateway. It happens…
This is very important for the most web developers. This stored procedure accept parameter of page index and page size. By using this paging, you don’t need to store everything in your viewstate which in the…
It’s quite often I have this error because of the content has been changed during postback or because of the control id. I’ve read most of the article suggested to disable the event validation by putting…
I’ve got a question this morning about how to find a particular query in a huge list of stored procedure. It’s not that hard, what you need to do is to use SYS object and sys.procedures…
I tried to create an average in sql server by dividing two figures. Once I got the error of “Divide by zero error occured”, this is caused by dividing the figure by null value, to handle…