CSV parsing in SQL server
I’ve got this SQL Function to parse comma separated value into a table. We need this function when our application commit separated comma value in a text. We normally do this when we want to send…
-
-
Project item ‘4294967294’ does not represent a file
Project item ‘4294967294’ does not represent a file, this error comes out when I try to open a solution which results in some of the projects can not be loaded (the source file is on the…
-
Dynamic Order By in ROW_NUMBER()
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 (…
-
webform_dopostbackwithoptions is undefined
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…
-
Using Transaction Scope on .NET
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…
-
the server committed a protocol violation section= responsestatusline
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…
-
Paging through strored procedure in sql server
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…
-
Invalid postback or call argument
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…