Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Loading a DataReader
Message
From
31/10/2002 09:28:50
 
 
To
31/10/2002 09:21:00
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00717293
Message ID:
00717301
Views:
16
No answer, Rex, but just to let you know. . .

You can edit a sent message (provided no one has replied or is in the process of replying).
At the bottom of your messages you will see an icon towards the right side that, when hovered over, will say something like 'edit the message'.
Clicking it gives an editable screen with a send (or save?) button at the extreme bottom left.

cheers


>All,
>
>Sorry for my previous post, here is the corrected version:
>
>I am trying to load a DataReader from a SQLServer stored procedure. I have to following code:
>
>
>Dim objConnection As SqlConnection
>Dim objCommand As SqlCommand
>Dim objParameter As SqlParameter
>Dim objDR As SqlDataReader
>Try
>	objConnection = New SqlConnection(DBConnectionName)
>	objConnection.Open()
>
>	objCommand = New SqlCommand(LoadPagedStoredProcedure, objConnection)
>	objCommand.CommandType = CommandType.StoredProcedure
>
>		... Set Parameters Here ...
>
>	objDR = objCommand.ExecuteReader(CommandBehavior.CloseConnection)
>
>Catch objException As Exception
>	mObjException = objException
>Catch objSQLException As SqlException
>	mObjException = objSQLException
>End Try
>Return objDR
>
>
>There are no errors, but the DataReader is empty. When I change the DataReader to a DataSet and change the ExecuteReader to a Fill, all works perfectly.
>
>What am I doing wrong?
>
>TIA
>
>Rex
Previous
Reply
Map
View

Click here to load this message in the networking platform