By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,333 Members | 1,850 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,333 IT Pros & Developers. It's quick & easy.

stored proc probs..

P: n/a
hi all,
how does one go about changing the details in the aspnetdb dbase using
the supplied stored procs?

i am using vb as my language but i have no idea how to use them, how to call
them or whatever.. i got the book sql in 24 hours and that made things worse
as i really dont understand where the calls go?

ANY help or code snippets would be a REAL big help..
thanks in advance...

Big thanks...
Jun 27 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
http://searchwindevelopment.techtarg...270321,00.html

Hope that helps.
Fernando L Rodriguez, MCP

"Rob Eventine" <bt****@ntlworld.comwrote in message
news:r2*******************@newsfe6-win.ntli.net...
hi all,
how does one go about changing the details in the aspnetdb dbase using
the supplied stored procs?

i am using vb as my language but i have no idea how to use them, how to
call them or whatever.. i got the book sql in 24 hours and that made
things worse as i really dont understand where the calls go?

ANY help or code snippets would be a REAL big help..
thanks in advance...

Big thanks...

Jun 27 '08 #2

P: n/a
You can think of a stored proc as a prefefined set of instructions. These
can be called by setting up a command object with the parameters required
by the stored proc. If you use the wizards for generating a datasource on
your page, this will give you the option to add a stored proc and set up
your parameters. For example, you may have a stored proc called highest
score which looks at all the players who play and how many goals they score.
The parameters you pass could be something like. @FixtureDate , @TeamName
etc and it could return a table of top scoring players for a team or all
teams.

You can optionally use SQL Server Management Studio to manage your database,
with some simplier operations available from within visual studio itself.

HTH

"Rob Eventine" <bt****@ntlworld.comwrote in message
news:r2*******************@newsfe6-win.ntli.net...
hi all,
how does one go about changing the details in the aspnetdb dbase using
the supplied stored procs?

i am using vb as my language but i have no idea how to use them, how to
call them or whatever.. i got the book sql in 24 hours and that made
things worse as i really dont understand where the calls go?

ANY help or code snippets would be a REAL big help..
thanks in advance...

Big thanks...

Jun 27 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.