Argentini.Halide.H3Sql.GetSprocParams C# (CSharp) Method

        public static String[,] GetSprocParams(String procedureName, String connectionStringName)
        {
            String[,] retVal = null;

            try
            {
                SqlConnection con = new SqlConnection(ConnectionString(connectionStringName));
                SqlCommand cmd = new SqlCommand(procedureName, con);
                cmd.CommandType = CommandType.StoredProcedure;
                con.Open();
                SqlCommandBuilder.DeriveParameters(cmd);

                Int32 count = 0;

                foreach (SqlParameter parameter in cmd.Parameters)
                {
                    if (parameter.Direction == ParameterDirection.Input) count++;
                }

                retVal = new string[count, 2];

                count = 0;

                foreach (SqlParameter parameter in cmd.Parameters)
                {
                    if (parameter.Direction == ParameterDirection.Input)
                    {
                        retVal[count, 0] = parameter.ParameterName;
                        retVal[count++, 1] = parameter.SqlDbType.ToString();
                    }
                }

                cmd.Dispose();
                con.Close();
            }

            catch (Exception err)
            {
                throw new Exception("Halide.H3Sql Error: " + err.ToString());
            }

            return retVal;
        }