How do I use store procedures?

[Guest]

How do I create and use "store procedures" with an SqlConnection object? I need to create a procedure that will add a record and return the new ID of said record. I know that I can accomplish this with "store procedures." If you can direct me to a simple sample, I would really appreciate it.

- Rashad Rivera

 

[William Ryan eMVP]

Check out Bill Vaughn's article on Retrieving the Gozoutas at
www.betav.com -> Articles -> MSDN

How do I create and use "store procedures" with an SqlConnection object?

I need to create a procedure that will add a record and return the new ID of
said record. I know that I can accomplish this with "store procedures." If
you can direct me to a simple sample, I would really appreciate it.

 

[William Ryan eMVP]

This might help too
http://www.dotnetjunkies.com/HowTo/E03F192F-E8DD-4CD8-82AD-7B2D2E537421.dcik

How do I create and use "store procedures" with an SqlConnection object?

I need to create a procedure that will add a record and return the new ID of
said record. I know that I can accomplish this with "store procedures." If
you can direct me to a simple sample, I would really appreciate it.