Click here to Skip to main content
       

ASP.NET

 
AnswerRe: CapsLock detection PinmemberAnalogNerd27-Dec-12 4:56 
AnswerRe: CapsLock detection [modified] PinmemberCommDev28-Dec-12 22:50 
QuestionApplication Layering PinmemberOmersayeed26-Dec-12 3:31 
QuestionSyntax error in store procedure Pinmemberanubhaw.gupta25-Dec-12 23:06 
AnswerRe: Syntax error in store procedure PinmemberSravanthid2825-Dec-12 23:21 
GeneralRe: Syntax error in store procedure Pinmemberanubhaw.gupta25-Dec-12 23:40 
AnswerRe: Syntax error in store procedure Pinmemberanubhaw.gupta25-Dec-12 23:45 
GeneralRe: Syntax error in store procedure Pinmembersathish s26-Dec-12 2:39 
GeneralRe: Syntax error in store procedure PinmemberZafar Sultan26-Dec-12 4:31 
Questionid or guid.. which one? PinmemberJassim Rahma25-Dec-12 8:22 
AnswerRe: id or guid.. which one? PinmvpSandeep Mewara25-Dec-12 20:14 
AnswerRe: id or guid.. which one? [modified] PinmemberCommDev25-Dec-12 20:25 
Questionwhy should I care about ExecuteScalar PinmemberJassim Rahma25-Dec-12 6:57 
AnswerRe: why should I care about ExecuteScalar PinmvpSandeep Mewara25-Dec-12 20:30 
Jassim Rahma wrote:
ExecuteNonReader

I don't find a knowledge base article for the same in MSDN. Based on what I know and can infer, using it to get just a 'single' value will be an overhead. It should be used when database query is going to provide a set of records.
 
My guess, term in discussion is ExecuteNonQuery and should not be ExecuteNonReader.
 

Jassim Rahma wrote:
ExecuteScalar

Executes the query, and returns the first column of the first row in the result set returned by the query.
Refer: Refer: SqlCommand.ExecuteScalar Method [^]
 

Now, based on the details and documentation, for getting a count, ExecuteScalar fits in the best that will get me the result directly as needed.
Sandeep Mewara
Microsoft ASP.NET MVP 2012
 

[My Latest Article(s)]:
How to extend a WPF Textbox to Custom Picker
Server side Delimiters in ASP.NET

AnswerRe: why should I care about ExecuteScalar PinmemberCommDev25-Dec-12 20:33 
AnswerRe: why should I care about ExecuteScalar PinmemberCommDev25-Dec-12 20:40 
GeneralRe: why should I care about ExecuteScalar PinmemberJassim Rahma28-Dec-12 10:40 
GeneralRe: why should I care about ExecuteScalar PinmemberNaveen Katta26-Dec-12 1:10 
Questiona control that should contain html elements [modified] PinmemberAli Al Omairi(Abu AlHassan)24-Dec-12 0:01 
QuestionRe: a control that should contain html elements Pinmemberjkirkerx24-Dec-12 14:09 
AnswerRe: a control that should contain html elements PinmemberAli Al Omairi(Abu AlHassan)25-Dec-12 20:51 
Questioncheckedchange event of gridview in javascript PinmemberRavi_kant23-Dec-12 20:29 
AnswerRe: checkedchange event of gridview in javascript PinmemberSampath Kumar Sathiya24-Dec-12 1:20 
GeneralRe: checkedchange event of gridview in javascript PinmemberRavi_kant24-Dec-12 8:40 
Questionupdated data from gridview PinmemberMember 970720723-Dec-12 1:30 
AnswerRe: updated data from gridview PinmemberAli Al Omairi(Abu AlHassan)24-Dec-12 5:31 
AnswerRe: updated data from gridview PinmvpSandeep Mewara25-Dec-12 20:35 
Question.net question PinmemberTarani Dutt Joshi22-Dec-12 0:53 
AnswerRe: .net question PinmvpRichard MacCutchan22-Dec-12 1:18 
AnswerRe: .net question PinmemberMaulikDusara24-Dec-12 22:38 
AnswerRe: .net question PinmvpSandeep Mewara25-Dec-12 20:33 
QuestionWebRequest Pinmembercdpsource21-Dec-12 15:16 
Questionwebpage has resulted in too many redirects PinmemberJassim Rahma21-Dec-12 10:46 
AnswerRe: webpage has resulted in too many redirects Pinmemberjkirkerx22-Dec-12 19:50 
GeneralRe: webpage has resulted in too many redirects PinmemberJassim Rahma23-Dec-12 9:36 
GeneralRe: webpage has resulted in too many redirects Pinmemberjkirkerx23-Dec-12 9:47 
GeneralRe: webpage has resulted in too many redirects PinmemberJassim Rahma24-Dec-12 10:10 
GeneralRe: webpage has resulted in too many redirects Pinmemberjkirkerx24-Dec-12 14:05 
Questionpop up on mouse over on a image button PinmemberYasir88721-Dec-12 7:42 
AnswerRe: pop up on mouse over on a image button PinmemberAnalogNerd21-Dec-12 10:26 
GeneralRe: pop up on mouse over on a image button PinmemberYasir88721-Dec-12 18:09 
AnswerRe: pop up on mouse over on a image button Pinmembern.podbielski22-Dec-12 22:50 
AnswerRe: pop up on mouse over on a image button [modified] PinmemberCommDev23-Dec-12 15:35 
Questionasp.net PinmemberNitin Pant20-Dec-12 22:43 
AnswerRe: asp.net PinmvpRichard MacCutchan20-Dec-12 23:57 
RantRe: asp.net PinmemberRichard Deeming21-Dec-12 2:31 
GeneralRe: asp.net PinmvpRichard MacCutchan21-Dec-12 3:04 
JokeRe: asp.net Pinmembern.podbielski22-Dec-12 22:54 
AnswerRe: asp.net PinmemberJ4amieC21-Dec-12 0:26 
AnswerRe: asp.net PinmemberProgramFOX21-Dec-12 0:52 

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.1411023.1 | Last Updated 28 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid