Stored procedures...

L

lidds

Well-known member
Joined
Nov 9, 2004
Messages
210
Does anyone know of any good tutorials or books that deal with stored procedures using vb.net

Cheers

Simon
 
Would you be referring to RDBMS stored procs? Which database are we talking about? More info please.
 
Dont know good books, but I can send you a snippet that shows how to do a datareader or dataset using an SQL Server databases stored procedure that takes parameters.

Would that help?
 
Sorry, using sql server.


MarkD, if you could send me a / some examples that would be great.

Cheers

Simon
 
lidds said:
Sorry, using sql server.


MarkD, if you could send me a / some examples that would be great.

Cheers

Simon
Click to expand...

Simon, I have them in the form of two Word docs and am not sure how to send via the forum. Do you mind if I just e-mail them to you off-line? If not, your e-mail address?

Mark
 
MarkD said:
Simon, I have them in the form of two Word docs and am not sure how to send via the forum. Do you mind if I just e-mail them to you off-line? If not, your e-mail address?

Mark
Click to expand...

That would be fine Mark, my email address is s_liddicott@yahoo.co.uk.

Also as I have only just started to look at stored procedures I was wondering if it is possible to return a number of values from a table i.e. if I had a table called projectTbl and within that table I had a column called projName which contained values project1, project2 and project3 and I had a stored procedure that had a select query e.g.
Code: 
 SELECT * FROM projectTbl
how do I return those values, as the examples that I have found so far on the internet only return a single value.

Thanks for your help

Simon
 
The SQL string: "SELECT * FROM projectTbl" will return all fields and values from that table.

Depending on what you are using to view the records: datagrid, listview etc.. and how you want users to interact with the data (i.e. allow modification of data - updating changes back to the underlying source or just read-only) will determine what type of data access objects you will use and how the data will be displayed.

If you want to display multiple records in a table-like view that allows users to directly modify the data i would recommend using a dataset object, and in your case binding this to a datagrid.
 
Back
Top