Persistencia.pCadNoticia.consultarNoticiasCinema C# (CSharp) Method

consultarNoticiasCinema() public method

public consultarNoticiasCinema ( ) : DataSet
return System.Data.DataSet
        public DataSet consultarNoticiasCinema()
        {
            String SQL = "SELECT * FROM dbo.noticia WHERE TipoNoticia = 'cinema' ";

            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 consultarNoticiasCinema()
 {
     pCadNoticia objnoticiacinema = new pCadNoticia();
     return objnoticiacinema.consultarNoticiasCinema();
 }