private DataTable exeSP(string sp,string pars) {
    using (SqlConnection conn = new SqlConnection(_connectionString))
    {
        try
        {
            conn.Open();
            SqlCommand cmd = iniSqlCommand(sp);
            cmd.Connection = conn;
            prepareInPars(cmd, pars);
            prepareOutpars(cmd);
            var outpars = GetOutputParameters(cmd.CommandText);
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sdr.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            conn.Close();
        }
    }
}