Click here to Skip to main content
15,901,426 members
Home / Discussions / C#
   

C#

 
QuestionSqlDataReader reading beyond end of data Pin
TheJudeDude8-Jan-10 11:58
TheJudeDude8-Jan-10 11:58 
AnswerRe: SqlDataReader reading beyond end of data Pin
Bassam Saoud8-Jan-10 12:31
Bassam Saoud8-Jan-10 12:31 
AnswerRe: SqlDataReader reading beyond end of data Pin
Jimmanuel8-Jan-10 12:33
Jimmanuel8-Jan-10 12:33 
GeneralRe: SqlDataReader reading beyond end of data Pin
TheJudeDude11-Jan-10 5:16
TheJudeDude11-Jan-10 5:16 
GeneralRe: SqlDataReader reading beyond end of data Pin
Jimmanuel11-Jan-10 6:39
Jimmanuel11-Jan-10 6:39 
GeneralRe: SqlDataReader reading beyond end of data Pin
TheJudeDude11-Jan-10 9:04
TheJudeDude11-Jan-10 9:04 
GeneralRe: SqlDataReader reading beyond end of data Pin
Jimmanuel11-Jan-10 9:49
Jimmanuel11-Jan-10 9:49 
AnswerRe: SqlDataReader reading beyond end of data Pin
Migounette8-Jan-10 12:34
Migounette8-Jan-10 12:34 
In fact you should use it in the other way:

DataTableReader dataTableReader = myDatabase.CreateDataReader();
if (dataTableReader.HasRows)
{
while (dataTableReader.Read())
{
Console.Out.Write(...);
}
}

Read will returns a boolean and does not through an exception.

Moreover it also should depend on your provider (MySQL, SQL Server...), the cursor method used behind may conduct to the problem.
You should read that you can use Read before HasRows but in the past I got some problems with some providers.

Hope it helps
AnswerRe: SqlDataReader reading beyond end of data Pin
ajith-k-rajagopalan8-Jan-10 21:56
ajith-k-rajagopalan8-Jan-10 21:56 
GeneralRe: SqlDataReader reading beyond end of data Pin
TheJudeDude11-Jan-10 5:27
TheJudeDude11-Jan-10 5:27 
QuestionHelp on converting to XML Pin
amadaeliseo8-Jan-10 8:59
amadaeliseo8-Jan-10 8:59 
AnswerRe: Help on converting to XML Pin
Dimitri Witkowski8-Jan-10 22:08
Dimitri Witkowski8-Jan-10 22:08 
QuestionFeature from Java... is in C#? [modified] Pin
ika28-Jan-10 8:34
ika28-Jan-10 8:34 
AnswerRe: Feature from Java... is in C#? Pin
harold aptroot8-Jan-10 9:09
harold aptroot8-Jan-10 9:09 
AnswerRe: Feature from Java... is in C#? Pin
Nicholas Butler8-Jan-10 9:12
sitebuilderNicholas Butler8-Jan-10 9:12 
GeneralRe: Feature from Java... is in C#? Pin
ika28-Jan-10 11:16
ika28-Jan-10 11:16 
AnswerRe: Feature from Java... is in C#? Pin
Pete O'Hanlon8-Jan-10 11:20
mvePete O'Hanlon8-Jan-10 11:20 
AnswerRe: Feature from Java... is in C#? Pin
N a v a n e e t h8-Jan-10 19:17
N a v a n e e t h8-Jan-10 19:17 
Questiongeneral help Pin
hotthoughtguy8-Jan-10 8:15
hotthoughtguy8-Jan-10 8:15 
AnswerRe: general help Pin
#realJSOP8-Jan-10 8:25
professional#realJSOP8-Jan-10 8:25 
GeneralRe: general help Pin
hotthoughtguy8-Jan-10 8:31
hotthoughtguy8-Jan-10 8:31 
AnswerRe: general help Pin
Bassam Saoud8-Jan-10 12:37
Bassam Saoud8-Jan-10 12:37 
QuestionMessage Removed Pin
8-Jan-10 6:50
Omoniyi Ogunderu8-Jan-10 6:50 
AnswerRe: DATABASE PATH DECOMPRESSION AND COMPRESSION. Pin
Saksida Bojan8-Jan-10 7:07
Saksida Bojan8-Jan-10 7:07 
QuestionRegarding C# Application Pin
xfailzx8-Jan-10 5:59
xfailzx8-Jan-10 5:59 

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.