public DataSet ListarOp()
{
string strQuery;
strQuery = "select * from contato order by cod_contato";
//strQuery+= "";
CldBancoUrna ObjBancoDados = new CldBancoUrna();
return(ObjBancoDados.RetornaDataSet(strQuery));
}
public DataSet ListarMesarios()
{
string strQuery;
strQuery = "Select cod_mesario, Nome, id_mesario from MESARIO Where Ativo='1' order by cod_mesario";
//strQuery = "Select * from Mesario";
CldBancoUrna ObjBancoDados = new CldBancoUrna();
return(ObjBancoDados.RetornaDataSet(strQuery));
}
public DataSet ListarChapas(string strListaChapas)
{
String strQuery;
//strQuery = "Select * from Chapa";
strQuery = "select nome_chapa, numero, presidente, vice_presidente, descricao, caminho_foto from chapa where ativo='1'";
CldBancoUrna ObjBancoDados = new CldBancoUrna();
return(ObjBancoDados.RetornaDataSet(strQuery));
}
public DataSet ListarAlunos()
{
string strQuery;
strQuery = "Select cod_alunos, Nome, rm FROM ALUNOS Where Ativo='1' order by cod_alunos";
//Select cod_alunos nome, rm, senha FROM ALUNOS Where Ativo='1' order by cod_alunos"
//strQuery = "Select * from Alunos";
CldBancoUrna ObjBancoDados = new CldBancoUrna();
return(ObjBancoDados.RetornaDataSet(strQuery));
}