public string runSP_TEST(ADO_class.ParamsSQLCommand[] paramLst, string sNameSP, bool flagReturn, int iCount, out string sErr)
        {
            ErrorText = "";//Чистим текст ошибки
            string sVal = "";
            int i = 0;

            sErr = "";

            if (iCount <= 0) return "10";//0;
            SqlConnection myConnTMP =  new SqlConnection(ConfigurationManager.ConnectionStrings["db"].ConnectionString);

            SqlCommand myCmd = new SqlCommand(sNameSP, myConnTMP);
            myCmd.CommandType = CommandType.StoredProcedure;

...дальше в myCmd вставляем параметры и вызываем 
try{
     myCmd.ExecuteNonQuery();
}
            catch (SqlException exp)
            {
                sErr = exp.Message;
                return "_Direction=" + paramLst[0]._Direction.ToString() + " _Name=" + paramLst[0]._Name.ToString() + " _Size=" + paramLst[0]._Size.ToString() + " _Type=" + paramLst[0]._Type.ToString() + " _Val=" + paramLst[0]._Val.ToString();
                //return -1;
            }

            finally
            {
               myConnTMP.Close();
            }

myConnTMP.Open();