Click here to Skip to main content
15,913,171 members
Home / Discussions / C#
   

C#

 
GeneralLimit the transfer speed of file copyies Pin
Andemann13-Apr-05 3:00
Andemann13-Apr-05 3:00 
GeneralRe: Limit the transfer speed of file copyies Pin
Dave Kreskowiak13-Apr-05 4:14
mveDave Kreskowiak13-Apr-05 4:14 
GeneralInheriting ProxyAttribute Pin
Zgaddo13-Apr-05 2:56
Zgaddo13-Apr-05 2:56 
GeneralRe: Inheriting ProxyAttribute Pin
leppie13-Apr-05 3:02
leppie13-Apr-05 3:02 
GeneralODBC Pin
jobrown5vt13-Apr-05 2:36
jobrown5vt13-Apr-05 2:36 
GeneralRe: ODBC Pin
turbochimp13-Apr-05 3:19
turbochimp13-Apr-05 3:19 
GeneralRe: ODBC Pin
jobrown5vt13-Apr-05 4:34
jobrown5vt13-Apr-05 4:34 
GeneralRe: ODBC Pin
turbochimp13-Apr-05 5:13
turbochimp13-Apr-05 5:13 
It doesn't work that way. If your server side SQL generates a result set (row[s] of data), instead of filling a series of output parameters, you need to provide a way to deal with the results.

A DataReader is a forward only, connected mechanism for dealing with a server side cursor. It can deal with single or multiple result sets, and you read a row at a time.

DataTables and DataSets are disconnected representations of resultsets - a DataSet is sort of an in-memory database which may represent one or many result sets in DataTables, and a DataTable (which exists in a DataSet) is an in-memory representation of a single result set.

If you're going to use a DataReader (the fastest of the bunch if forward only will do it for you), you should be able to use the ExecuteReader method to get the reader and begin dealing with the result set(s).

If you need to be able to randomly access rows from the result set(s), you may need to use a DataAdapter with your command to fill a DataSet or DataTable. This process is slower than using a DataReader (in fact it uses a DataReader behind the scenes to fill the data structures).

You can't, however, execute some SQL on the server that returns a result set, then stick the result set in an OUT parameter and assign it using ExecuteNonQuery or ExecuteScalar. There is no compatible managed type for doing something like that.

The most exciting phrase to hear in science, the one that heralds the most discoveries, is not 'Eureka!' ('I found it!') but 'That's funny...’

GeneralStretching/Shrinking Images Pin
MarkMokris13-Apr-05 1:41
MarkMokris13-Apr-05 1:41 
GeneralRe: Stretching/Shrinking Images Pin
Mathew Hall13-Apr-05 2:21
Mathew Hall13-Apr-05 2:21 
GeneralData reading from ASP.NET to C# Pin
tgprakash13-Apr-05 1:25
tgprakash13-Apr-05 1:25 
GeneralRe: Data reading from ASP.NET to C# Pin
Esmo200013-Apr-05 4:27
Esmo200013-Apr-05 4:27 
GeneralRe: Data reading from ASP.NET to C# Pin
tgprakash13-Apr-05 20:17
tgprakash13-Apr-05 20:17 
GeneralMultiline Text input in PropertyGrid Pin
M. Noordam13-Apr-05 1:16
M. Noordam13-Apr-05 1:16 
GeneralRe: Multiline Text input in PropertyGrid Pin
MoustafaS13-Apr-05 4:48
MoustafaS13-Apr-05 4:48 
GeneralRe: Multiline Text input in PropertyGrid Pin
M. Noordam13-Apr-05 18:44
M. Noordam13-Apr-05 18:44 
GeneralDataView / DataBindings Pin
UschkinRedSunshine13-Apr-05 1:08
UschkinRedSunshine13-Apr-05 1:08 
GeneralI don't know how to use RandomNumberGenerator class. Pin
Mohammed Aijaz Mohiuddin13-Apr-05 0:47
Mohammed Aijaz Mohiuddin13-Apr-05 0:47 
GeneralRe: I don't know how to use RandomNumberGenerator class. Pin
hooray13-Apr-05 1:07
hooray13-Apr-05 1:07 
GeneralRe: I don't know how to use RandomNumberGenerator class. Pin
Sebastian Schneider13-Apr-05 1:32
Sebastian Schneider13-Apr-05 1:32 
GeneralData Grid: Row Based Control Pin
innocent7313-Apr-05 0:37
innocent7313-Apr-05 0:37 
General.NET 2.0 WebBrowser is flickering Pin
Anonymous13-Apr-05 0:07
Anonymous13-Apr-05 0:07 
GeneralRe: .NET 2.0 WebBrowser is flickering Pin
leppie13-Apr-05 5:09
leppie13-Apr-05 5:09 
GeneralRe: .NET 2.0 WebBrowser is flickering Pin
Anonymous13-Apr-05 6:03
Anonymous13-Apr-05 6:03 
GeneralRe: .NET 2.0 WebBrowser is flickering Pin
Dave Kreskowiak13-Apr-05 6:12
mveDave Kreskowiak13-Apr-05 6:12 

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.