Click here to Skip to main content
15,174,232 members
Home / Discussions / C#
   

C#

 
AnswerRe: SqlDataReader is not returning all rows Pin
OriginalGriff2-Sep-13 4:46
mveOriginalGriff2-Sep-13 4:46 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 6:36
MemberNarVish2-Sep-13 6:36 
GeneralRe: SqlDataReader is not returning all rows Pin
OriginalGriff2-Sep-13 9:04
mveOriginalGriff2-Sep-13 9:04 
AnswerRe: SqlDataReader is not returning all rows Pin
Eddy Vluggen2-Sep-13 7:23
professionalEddy Vluggen2-Sep-13 7:23 
GeneralRe: SqlDataReader is not returning all rows Pin
Manfred Rudolf Bihy2-Sep-13 9:42
professionalManfred Rudolf Bihy2-Sep-13 9:42 
AnswerRe: SqlDataReader is not returning all rows Pin
Pete O'Hanlon2-Sep-13 9:45
mvaPete O'Hanlon2-Sep-13 9:45 
GeneralRe: SqlDataReader is not returning all rows Pin
NarVish2-Sep-13 20:40
MemberNarVish2-Sep-13 20:40 
GeneralRe: SqlDataReader is not returning all rows Pin
Pete O'Hanlon2-Sep-13 21:22
mvaPete O'Hanlon2-Sep-13 21:22 
At least the mystery has been solved. The effect you were after here could have been achieved by using the following instead:
C#
if (!reader.HasRows)
{
  throw new ApplicationException("MISSING Transaction Returned By Financial Institution. Transaction was not found in the database.");
}
while (reader.Read())
{
}
For future reference, the act of calling Read automatically moves the record to the next available record (if one's present) when it completes. It implements a firehose cursor, whereby data is effectively squirted at you.

QuestionQuestion about using an if in a string Pin
skeeterz711-Sep-13 18:35
Memberskeeterz711-Sep-13 18:35 
AnswerRe: Question about using an if in a string Pin
Dave Kreskowiak1-Sep-13 19:05
mveDave Kreskowiak1-Sep-13 19:05 
GeneralRe: Question about using an if in a string Pin
skeeterz711-Sep-13 19:31
Memberskeeterz711-Sep-13 19:31 
GeneralRe: Question about using an if in a string Pin
Dave Kreskowiak1-Sep-13 19:37
mveDave Kreskowiak1-Sep-13 19:37 
GeneralRe: Question about using an if in a string Pin
skeeterz711-Sep-13 19:46
Memberskeeterz711-Sep-13 19:46 
GeneralRe: Question about using an if in a string Pin
BillWoodruff1-Sep-13 20:42
mveBillWoodruff1-Sep-13 20:42 
GeneralRe: Question about using an if in a string Pin
OriginalGriff2-Sep-13 4:58
mveOriginalGriff2-Sep-13 4:58 
GeneralRe: Question about using an if in a string Pin
AmitGajjar2-Sep-13 21:10
professionalAmitGajjar2-Sep-13 21:10 
GeneralRe: Question about using an if in a string Pin
OriginalGriff2-Sep-13 22:24
mveOriginalGriff2-Sep-13 22:24 
GeneralRe: Question about using an if in a string Pin
Dave Kreskowiak2-Sep-13 6:58
mveDave Kreskowiak2-Sep-13 6:58 
GeneralRe: Question about using an if in a string Pin
blitzkrieged2-Sep-13 15:16
Memberblitzkrieged2-Sep-13 15:16 
AnswerRe: Question about using an if in a string Pin
liveoffedge2-Sep-13 1:15
professionalliveoffedge2-Sep-13 1:15 
GeneralRe: Question about using an if in a string Pin
OriginalGriff2-Sep-13 4:49
mveOriginalGriff2-Sep-13 4:49 
GeneralRe: Question about using an if in a string Pin
Keith Barrow2-Sep-13 7:21
professionalKeith Barrow2-Sep-13 7:21 
GeneralRe: Question about using an if in a string Pin
skeeterz713-Sep-13 7:30
Memberskeeterz713-Sep-13 7:30 
AnswerRe: Question about using an if in a string Pin
AmitGajjar2-Sep-13 21:02
professionalAmitGajjar2-Sep-13 21:02 
QuestionDistinct Row or Rows in a datatable Pin
smh139231-Aug-13 23:00
Membersmh139231-Aug-13 23:00 

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.