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;
}