how to use stored procedures in C#.net

n.thillaiarasu

__________________
N.ThillaiArasu

Can you elaborate on your question, do you mean how to execute a stored procedure and get the results into a dataset?

To call a stored procedure, you can use the a variety of methods using both connected (retaining a semi-permenant connection) or disconnected (grabbing the data and then disconnecting automatically).

To create a stored procedure, these are done in either your database provider, or you will have to write a stored procedure in C# string's and execute it. The former is preferred!

Hope this helps.

Regards,

Dominic