StoredProcedure

[Tony Johansson]

Hello!

I just wonder when you use StoredProcedure will you then use DataSet ?
In the example that I have seen is the DataSet not used is this normal ?

//Tony

 

[Hans Kesting]

After serious thinking Tony Johansson wrote :

Hello!

I just wonder when you use StoredProcedure will you then use DataSet ?
In the example that I have seen is the DataSet not used is this normal ?

//Tony

In *what* example that *you* have seen? Without seeing what is in
there, we cannot comment on it.

However:
Some stored procedures return a recordset (the result of some "select"
statement). You can load this recordset into a DataSet *or* process it
in a Reader.
Other stored procedures return nothing (a "delete record" for example)
or just a single value. You would not use a dataset then.

Hans Kesting

 

[jp2msft]

Personally, I typically use a Stored Procedure to fill a DataTable because
that is the format that my Stored Procedures return information in.

There's nothing wrong (in my opinion) with using a DataSet, DataTable,
DataReader, or anything else that works. There are many ways to pull data.