The below code snippet contains a simple stored procedure that can be used to search throught database.

sp-creation.gif

Since the stored-procedure was created, you can create a SQLCommand (or DbCommand implementation provided by .Net Provider) and add the parameters.

sp-calling.gif

If the execution contains only one instance (or record) you can replace "ExecuteCommandList" command to "ExecuteCommand" with same parameters.

Last edited Nov 7, 2007 at 1:42 AM by fpeinado, version 4

Comments

No comments yet.