public static Object ExecuteScalarSP(string spName, Hashtable spParams)
{
Object retVal;
try
{
// Open the connection
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
// 1. create a command object identifying
// the stored procedure
SqlCommand cmd = new SqlCommand(spName, conn);
// 2. set the command object so it knows
// to execute a stored procedure
cmd.CommandType = CommandType.StoredProcedure;
// 3. add parameter to command, which
// will be passed to the stored procedure
foreach (DictionaryEntry spParam in spParams)
{
cmd.Parameters.Add(new SqlParameter(spParam.Key.ToString(), spParam.Value));
}
retVal = cmd.ExecuteScalar();
return retVal;
}
}
catch (Exception ex)
{
throw (ex);
}
}