free tutorials

18 May 2006 4:12 PM

Brian

Hello all, I have found several tutorials out there for vb.net 2003
however I would like to find one that really emphasis Stored procedures
on a sql server to call and fill datasets to call and insert update
delete etc etc.. the advice of most talk out there is to use stored
procedures however when you see most of the sample code they are using
select statements right in the compiled code. am I the only one who has
found this to be true?

anyways looking for a good site that practices what they all seem to be
preaching

18 May 2006 4:26 PM

Cor Ligthert [MVP]

Brian,

Some persons do if a Stored Procedure is something magical. It is not, it is
just a procedure that it stored on the Server instead inside your program.
Therefore it can be *slightly* faster because it is already there.

A Stored Procedure cannot call and/or cannot fill a dataset. You can use a
stored procedure as the given commandstring inside a dataadapter to get that
instead that you sent that first to the server. As well can you use a Stored
Procedure to read information reading a datareader or an
command.executescalar.

I hope this helps,

Cor

Show quoteHide quote

"Brian" <Bri***@mtewood.com> schreef in bericht
news:eqMZRXpeGHA.1324@TK2MSFTNGP04.phx.gbl...
> Hello all, I have found several tutorials out there for vb.net 2003
> however I would like to find one that really emphasis Stored procedures on
> a sql server to call and fill datasets to call and insert update delete
> etc etc.. the advice of most talk out there is to use stored procedures
> however when you see most of the sample code they are using select
> statements right in the compiled code. am I the only one who has found
> this to be true?
>
> anyways looking for a good site that practices what they all seem to be
> preaching