first create a new connection object and open the connection

second create a command object identifying the stored procedure

third set the command object so it knows to execute a stored procedure

fourth add a parameters to the command which will passed to the stored procedure

please find the code for the same

//code for connection to db

SqlConnection conn new SqlConnection( Data Source servername;Initial Catalog northwind(dbname);uid sa;pwd sa );