Click here to Skip to main content


GeneralRe: Postback issue Pinmember@AmitGajjar4-Dec-12 15:20 
GeneralRe: Postback issue Pinmembern.podbielski4-Dec-12 20:29 
GeneralRe: Postback issue Pinmember@AmitGajjar4-Dec-12 20:46 
GeneralRe: Postback issue Pinmembern.podbielski4-Dec-12 20:59 
GeneralRe: Postback issue Pinmember@AmitGajjar4-Dec-12 21:19 
GeneralRe: Postback issue Pinmembern.podbielski4-Dec-12 23:45 
AnswerRe: Postback issue [modified] PinmemberCommDev8-Dec-12 23:15 
QuestionSQL query in c# PinmemberAnirbanM 23-Dec-12 2:31 
I'm having one web application where within loop I'm running one simple sql query (SQL Server 2008).
Select SNo, NoOfDays, [Month], [Year], [Days], [Holiday] From DaysMonth Where rtrim(Period)='Input' order by ToDate
Based on this query, populating one gridview and then creating records in a new table with other user input.
Now, out of 100 times it's running, 95-98 times it's giving accurate results, however, to my astonishment, sometimes sorting 'Order by' not working and producing abnormal sorting behavior. Like instead of 1st January to 31 January, it's returning 10th Jan-31st Jan then 1st Jan to 9th Jan (just for example). I got puzzled, because I can't do anything to change code, as it's working fine most of the time. Can you suggest some reason behind it which is beyond the code. As the data entry is huge, and it's multi-user environment, getting very difficult to monitor which one query going wrong. In that case, if I delete entries from new table, second time, it's giving perfect result. Please help me and thanks in advance to all.
AnswerRe: SQL query in c# PinmvpRichard MacCutchan3-Dec-12 2:36 
GeneralRe: SQL query in c# PinmemberAnirbanM 23-Dec-12 2:47 
GeneralRe: SQL query in c# PinmvpRichard MacCutchan3-Dec-12 2:50 
GeneralRe: SQL query in c# PinmemberAnirbanM 23-Dec-12 2:56 
Questionstate management PinmemberMember 80319152-Dec-12 23:12 
AnswerRe: state management PinmemberThetaClear2-Dec-12 23:19 
GeneralRe: state management PinmemberMember 80319152-Dec-12 23:26 
GeneralRe: state management PinmemberThetaClear2-Dec-12 23:37 
GeneralRe: state management PinmemberMember 80319152-Dec-12 23:48 
GeneralRe: state management PinmemberThetaClear3-Dec-12 0:02 
AnswerRe: state management Pinmember@AmitGajjar3-Dec-12 18:15 
QuestionGeneral understanding how facebook knows who is the user who is making a request for the 'code' parameter PinmemberThetaClear2-Dec-12 22:03 
Question3 tier applications in ASP.NET PinmemberDeepanjanNag2-Dec-12 10:54 
AnswerRe: 3 tier applications in ASP.NET Pinmemberdeflinek3-Dec-12 2:26 
AnswerRe: 3 tier applications in ASP.NET Pinmember@AmitGajjar3-Dec-12 18:16 
Questionselect an item in gridview Pinmemberptvce2-Dec-12 1:56 
AnswerRe: select an item in gridview PinmemberCommDev3-Dec-12 4:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Advertise | Privacy | Mobile
Web02 | 2.8.140814.1 | Last Updated 20 Aug 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid