Click here to Skip to main content
15,899,679 members
Home / Discussions / C#
   

C#

 
AnswerRe: Refreshing DataGridView Pin
zaboboa1-Aug-06 6:02
zaboboa1-Aug-06 6:02 
GeneralRe: Refreshing DataGridView Pin
Iceman5711-Aug-06 21:33
Iceman5711-Aug-06 21:33 
GeneralRe: Refreshing DataGridView Pin
Iceman5711-Aug-06 22:06
Iceman5711-Aug-06 22:06 
QuestionDeploying Application [modified] Pin
zaboboa1-Aug-06 5:00
zaboboa1-Aug-06 5:00 
AnswerRe: Deploying Application Pin
Judah Gabriel Himango1-Aug-06 5:02
sponsorJudah Gabriel Himango1-Aug-06 5:02 
GeneralRe: Deploying Application Pin
zaboboa1-Aug-06 5:05
zaboboa1-Aug-06 5:05 
QuestionWinform Control as ActiveX Pin
adityap1-Aug-06 4:58
adityap1-Aug-06 4:58 
Questionusing (DataReader) inside loop Pin
cnich231-Aug-06 4:55
cnich231-Aug-06 4:55 
As far as performance issues are concerned I have a question ....

I have to make multiple selects based on date inside of a loop.
Is it wise to use the USING statement for the datareader inside of the loop or does something need to be done outside the loop.


Here is my current code.

<br />
using (SQLCommand selectAnnv = new SQLCommand(_database)) {<br />
                    //create paramater date for variable select<br />
                    SQLParameter paramDate = new SQLParameter("@DATE");<br />
<br />
                    // create parement query @DATE is variable<br />
                    selectAnnv.CommandText = "SELECT id FROM " + TMEMBERS + " WHERE registered = '(@DATE)'";<br />
                    selectAnnv.Parameters.Add(paramDate);<br />
<br />
<br />
<br />
                    // loop through each day missed to current day<br />
                    for (DateTime anniversary = lastHandled.AddDays(1); anniversary <= now; anniversary = anniversary.AddDays(1)) {<br />
                        paramDate.Value = GStatic.GetISO8601(anniversary);<br />
<br />
                        //add ids to list<br />
                        // Data reader intialized outside loop<br />
                        using (SQLDataReader readerAnnv = selectAnnv.ExecuteReader()) {<br />
                            while (readerAnnv.Read())<br />
                                ids.Add(readerAnnv.GetInt32(0));<br />
                        }<br />
<br />
                    }<br />
<br />
                }<br />





Should the bolded/italic part be decalered outside of the loop?
AnswerRe: using (DataReader) inside loop Pin
cnich231-Aug-06 5:02
cnich231-Aug-06 5:02 
AnswerRe: using (DataReader) inside loop Pin
Dustin Metzgar1-Aug-06 6:10
Dustin Metzgar1-Aug-06 6:10 
GeneralRe: using (DataReader) inside loop Pin
cnich232-Aug-06 4:19
cnich232-Aug-06 4:19 
GeneralRe: using (DataReader) inside loop Pin
Dustin Metzgar2-Aug-06 4:41
Dustin Metzgar2-Aug-06 4:41 
GeneralRe: using (DataReader) inside loop Pin
cnich233-Aug-06 11:23
cnich233-Aug-06 11:23 
Questiondocuments saving Pin
_tasleem1-Aug-06 4:38
_tasleem1-Aug-06 4:38 
AnswerRe: documents saving Pin
Colin Angus Mackay1-Aug-06 4:52
Colin Angus Mackay1-Aug-06 4:52 
AnswerRe: documents saving Pin
A.A.1-Aug-06 5:06
A.A.1-Aug-06 5:06 
GeneralRe: documents saving Pin
_tasleem1-Aug-06 8:03
_tasleem1-Aug-06 8:03 
QuestionDefine interface / abstract class with constructor Pin
Florian Storck1-Aug-06 4:12
Florian Storck1-Aug-06 4:12 
AnswerRe: Define interface / abstract class with constructor Pin
NrmMyth1-Aug-06 4:45
NrmMyth1-Aug-06 4:45 
AnswerRe: Define interface / abstract class with constructor Pin
Colin Angus Mackay1-Aug-06 5:02
Colin Angus Mackay1-Aug-06 5:02 
GeneralRe: Define interface / abstract class with constructor Pin
Florian Storck2-Aug-06 4:28
Florian Storck2-Aug-06 4:28 
GeneralRe: Define interface / abstract class with constructor Pin
Colin Angus Mackay2-Aug-06 7:56
Colin Angus Mackay2-Aug-06 7:56 
Questionloading bitmap file Pin
diddy341-Aug-06 3:58
diddy341-Aug-06 3:58 
AnswerRe: loading bitmap file Pin
J4amieC1-Aug-06 4:01
J4amieC1-Aug-06 4:01 
QuestionDisposing a Dataset Pin
fearless stallion1-Aug-06 2:36
fearless stallion1-Aug-06 2:36 

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

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