Hamekoz.Data.DB.SPToDataSet C# (CSharp) Method

        public DataSet SPToDataSet(DataSet dataset, string sp, params object[] parameters)
        {
            using (DbConnection conexion = factory.CreateConnection ()) {
                conexion.ConnectionString = ConnectionString;
                conexion.Open ();
                using (DbCommand comando = factory.CreateCommand ()) {
                    comando.Connection = conexion;
                    comando.CommandType = CommandType.StoredProcedure;
                    comando.CommandText = sp;
                    comando.CommandTimeout = CommandTimeOut;
                    cargarParametros (comando, parameters);
                    using (DbDataAdapter adaptador = factory.CreateDataAdapter ()) {
                        adaptador.SelectCommand = comando;
                        adaptador.Fill (dataset, sp);
                        return dataset;
                    }
                }
            }
        }