Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Loading a DataReader
Message
De
31/10/2002 09:28:50
 
 
À
31/10/2002 09:21:00
Rex Mahel
Realm Software, Llc
Ohio, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Divers
Thread ID:
00717293
Message ID:
00717301
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform