SqlDataReader dr1.Read() coming false

Parul Vinod

I am using Visual Studio 2008; I am executing one query and its results are coming in the datareader dr1; I have checked this in debug window. Even though values are coming inside datareader it's read property dr1.read() is coming false. How is this happening. How do i remove this bug

Jan 27 '12 #1

Parul Vinod

The resulting values of query comes in dr1. in debugger under the haeding
Result View-> [0]-> Non-public members-> _values. And still dr1.read() is coming false.People plz reply. This is urgent.

Jan 27 '12 #2

PsychoCoder

Show the code you're using for this task and we will have a better idea on why this is happening.

Jan 27 '12 #3

Parul Vinod

I just changed the sequence of username, date into date,username and now the code is working. I still don't know the exact reason why this happened. Is it because in database i have difined date before username?

Jan 28 '12 #4

sarva

date is one kind of keyword in sql. change your field name!!!!

pls try it ....

best regards
Sarva

Jan 28 '12 #5

PsychoCoder

For future reference if you have a column name that's a reserved word when you query it put brackets around it, like this [date]

Jan 29 '12 #6

Parul Vinod

Thanks a lot Richard and SARVA.

Jan 30 '12 #7

PsychoCoder

No problem, glad I could be helpful :)

Jan 31 '12 #8