Persistencia.pGenero.consultarTodos C# (CSharp) Method

consultarTodos() public method

public consultarTodos ( ) : DataSet
return System.Data.DataSet
        public DataSet consultarTodos()
        {
            String SQL = "SELECT idGeneros as ID, generos as Genero FROM dbo.Generos";

            Conexao oConexao = new Conexao("SQLServer");

            SqlDataAdapter adapter = new SqlDataAdapter(SQL, oConexao.cn);
            DataSet ds = new DataSet("Tabela");
            adapter.Fill(ds, "Tabela");

            oConexao.fechaConexao();

            return ds;
        }

Usage Example

Example #1
0
 public DataSet consultarTodos()
 {
     pGenero objGenero = new pGenero();
     return objGenero.consultarTodos();
 }