SQL Reader problem

[Nikolay Petrov]

Hi,
I have the following code.

Dim RD As System.Data.SqlClient.SqlDataReader
Try 'Try2
OpenConnection()
RD = cmdSQL.ExecuteReader
While RD.Read = True
UserIDSQL = CInt(RD.Item("UserID"))
EncUserNameSQL = CStr(RD.Item("UserName"))
EncPasswordSQL = CStr(RD.Item("Password"))
PassExpirationDateSQL =
CDate(RD.Item("PasswordExpirationDate"))
IPAddressSQL = CStr(RD.Item("IPAddress"))
AllowOnlyThisIPAddress =
CBool(RD.Item("AllowOnlyThisIPAddress"))
AllowLoginFromWeb =
CBool(RD.Item("AllowLoginFromWeb"))
End While
Catch ex As Exception
msgbox(ex.Message)
Finally
CloseConnection()
End Try

I get some strange behavior.
When Run, it does not set values to variables in 'While' block.
When Debug it goes to line 'While RD.Read' and the next line executed is
'Finally'
Why?

TIA

[Herfried K. Wagner [MVP]]

"Nikolay Petrov" <jo**************@mail.bg> schrieb:

Dim RD As System.Data.SqlClient.SqlDataReader
Try 'Try2
OpenConnection()
RD = cmdSQL.ExecuteReader
While RD.Read = True
UserIDSQL = CInt(RD.Item("UserID"))
EncUserNameSQL = CStr(RD.Item("UserName"))
EncPasswordSQL = CStr(RD.Item("Password"))
PassExpirationDateSQL =
CDate(RD.Item("PasswordExpirationDate"))
IPAddressSQL = CStr(RD.Item("IPAddress"))
AllowOnlyThisIPAddress =
CBool(RD.Item("AllowOnlyThisIPAddress"))
AllowLoginFromWeb =
CBool(RD.Item("AllowLoginFromWeb"))
End While
Catch ex As Exception
msgbox(ex.Message)
Finally
CloseConnection()
End Try

I get some strange behavior.
When Run, it does not set values to variables in 'While' block.
When Debug it goes to line 'While RD.Read' and the next line executed is
'Finally'
Why?

Maybe the 'Read' method returns 'False', then the 'While' loop is skipped
and the 'Finally' part is executed. 'Finally' will be executed even if no
exception was thrown.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Nikolay Petrov]

Any idea why SQLDataReader returns false
I am using a stored procedure and I am sure it returns data.

[Cor Ligthert]

Nicolay,

Than why not in your finallyblock
Messagebox.show(EncUserNameSQL)

Or something like that.

It is a little thing to test, it will not be the first time that people are
"sure".

Cor
"Nikolay Petrov" <jo**************@mail.bg>

Any idea why SQLDataReader returns false
I am using a stored procedure and I am sure it returns data.

[Nikolay Petrov]

The
While RD.Read is FALSE at the first loop
it nevers assign anything to variables

when run in server explorer the stored procedure retruns data.

how can i see the returned data from SQL while debuging?


"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Nicolay,

Than why not in your finallyblock
Messagebox.show(EncUserNameSQL)

Or something like that.

It is a little thing to test, it will not be the first time that people
are "sure".

Cor
"Nikolay Petrov" <jo**************@mail.bg>

Any idea why SQLDataReader returns false
I am using a stored procedure and I am sure it returns data.

[Cor Ligthert]

As I wrote

Than why not in your finallyblock
Messagebox.show(EncUserNameSQL)

When it is a webpage you can create a label on that and set than this
varialble too that.

You can of course as well debug it, your stored procedure is only a
description what has to be readed.

Cor
While RD.Read is FALSE at the first loop
it nevers assign anything to variables

when run in server explorer the stored procedure retruns data.

how can i see the returned data from SQL while debuging?


"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Nicolay,

Than why not in your finallyblock
Messagebox.show(EncUserNameSQL)

Or something like that.

It is a little thing to test, it will not be the first time that people
are "sure".

Cor
"Nikolay Petrov" <jo**************@mail.bg>

Any idea why SQLDataReader returns false
I am using a stored procedure and I am sure it returns data.

[Chris Dunaway]

On Fri, 3 Dec 2004 15:35:14 +0200, Nikolay Petrov wrote:

how can i see the returned data from SQL while debuging?

If you run SQL Profiler, you can see what the query sent to SQL Server and
verify if it is correct.

--
Chris

dunawayc[AT]sbcglobal_lunchmeat_[DOT]net

To send me an E-mail, remove the "[", "]", underscores ,lunchmeat, and
replace certain words in my E-Mail address.