protected void DataBind(int pagina) { CDataService dados = new CDataService("controleAtas"); string sql = ""; if (nome == "") { sql = "SELECT id, nome, email, admin FROM Usuarios Order by 2"; } else { sql = "SELECT id, nome, email, admin FROM Usuarios WHERE nome like'" + nome + "%' Order by 2"; } GridView1.DataSource = dados.SelectSqlData(sql); GridView1.PageIndex = pagina; GridView1.DataBind(); dados.CloseDataSource(); }
protected void DataBind(int pagina) { CDataService dados = new CDataService("controleAtas"); string sql = ""; if (dtFim.Text == "" || dtInicio.Text == "") { sql = " SELECT DISTINCT r.id, convert(varchar(10),datahora,103) as data, assunto, local " + " FROM Reunioes r, Participantes p " + " WHERE r.id = p.idReuniao " + " AND r.dataHora BETWEEN (GETDATE() - 30) AND GETDATE() " + " AND r.excluida = 0 "; if (Session["admin"].ToString().Equals("False")) { sql += "AND p.idUsuario = " + Session["id"].ToString(); } sql += " Order by 2"; } else { sql = " SELECT DISTINCT r.id, convert(varchar(10),datahora,103) as data, assunto, local " + " FROM Reunioes r, Participantes p " + " WHERE r.id = p.idReuniao " + " AND r.dataHora BETWEEN " + Util.SQLString(dtInicio.SqlData) + " AND " + Util.SQLString(dtFim.SqlData) + " AND r.excluida = 0 "; if (Session["admin"].ToString().Equals("False")) { sql += "AND p.idUsuario = " + Session["id"].ToString(); } sql += " Order by 2"; } GridView1.DataSource = dados.SelectSqlData(sql); GridView1.PageIndex = pagina; GridView1.DataBind(); dados.CloseDataSource(); }