Articles
1

This article explain how to pass parameter in SQL server Stored Procedure and get value from stored procedure.

  

Steps:-
Note:- Skip Step 1 to 2 if you already have an application
1.first include this namespaces

using System;
using System.EnterpriseServices;
using System.Data;
using System.Data.SqlClient;


2. include this Main Code

 
 
 
 
 
 
 
 
 

public class ExecuteSQLCommand
{
string strCommandName;
SqlCommand objCommand;
SqlParameter objParam;
//Set the Connection String to the Database
SqlConnection objConnection = new SqlConnection("server=localhost;uid=sa;pwd=;Initial Catalog=Home");
try
{
//Name of the Stored Procedure to be executed
strCommandName = "spStoredProcedureName";
objCommand = new SqlCommand(strCommandName, objConnection);
objCommand.CommandType = CommandType.StoredProcedure;
//Set the Parameters
objParam = objCommand.Parameters.Add(new SqlParameter("@VariableOne", SqlDbType.VarChar, 50));
objParam.Direction = ParameterDirection.Input;
objParam.Value = strVariableOne;
objParam = objCommand.Parameters.Add(new SqlParameter("@VariableTwo", SqlDbType.Int));
objParam.Direction = ParameterDirection.Output;
objCommand.Connection.Open();
objCommand.ExecuteNonQuery();
//'Get the Out parameter from the Stored Procedure
intValueReturn = Convert.ToInt32((objCommand.Parameters["@getValueVariableName"].Value.ToString()));

}

catch(Exception ex)
{
throw ex;
}

finally
{
if ( objConnection.State == ConnectionState.Open) objConnection.Close(); objReader.Close();
}


}