Persistencia.pCadNoticia.consultarTodos C# (CSharp) Method

consultarTodos() public method

public consultarTodos ( ) : DataSet
return System.Data.DataSet
        public DataSet consultarTodos()
        {
            String SQL = "SELECT idNoticia as ID, noticia as Noticia, data as Data, TipoNoticia as Tipo FROM dbo.noticia";

            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

示例#1
0
 public DataSet consultarTodos()
 {
     pCadNoticia objnoticia = new pCadNoticia();
     return objnoticia.consultarTodos();
 }