//čitanje korištenjem zajedničke klase PristupPodacima protected void UcitajAnkete2() { string cmdstr = "select * from studenti " + SqlWhere(); gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); }
//Tipka za filtriranje Spola pomoću odabira sa radio-buttona protected void Button3_Click(object sender, EventArgs e) { if (RadioButton1.Checked) { string cmdstr = ""; try { tbTrazi.Text = ""; lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where spol='m'"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema studenata!"; } } if (RadioButton2.Checked) { string cmdstr = ""; try { tbTrazi.Text = ""; lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where spol='z'"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema studentica!"; } } }
protected void Page_Load(object sender, EventArgs e) { Obrada(); gvImenik.DataSource = Imenik; gvImenik.DataBind(); if (!IsPostBack) { //prihvat parametara ako se radi o editiranju postojece forme string editId = Request.QueryString["editId"]; if (editId != null) { //dohvat i popunjavanje ankete object[] parametri = { editId }; string cmdstr = "select ime_i_prezime, email, oib, spol, adresa, hobiji, boje from studenti "; cmdstr += "where id = " + editId; DataTable dt = PristupPodacima.VratiDataTable(cmdstr, parametri); //popunjavanje forme tbId.Text = editId; tbImeIPrezime.Text = dt.Rows[0]["ime_i_prezime"].ToString(); tbEmail.Text = dt.Rows[0]["email"].ToString(); tbOIB.Text = dt.Rows[0]["oib"].ToString(); rbSpol.SelectedValue = dt.Rows[0]["spol"].ToString(); tbAdresa.Text = dt.Rows[0]["adresa"].ToString(); //dodati još petlje za hobije i boje } } }
//tipka za filtriranje Godine protected void Button4_Click(object sender, EventArgs e) { if (RadioButton3.Checked) { string cmdstr = ""; try { tbTrazi.Text = ""; lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where godina='1'"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema 1. godine!"; } } if (RadioButton4.Checked) { string cmdstr = ""; try { tbTrazi.Text = ""; lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where godina='2'"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema 2. godine!"; } } if (RadioButton5.Checked) { string cmdstr = ""; try { tbTrazi.Text = ""; lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where godina='3'"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema 3. godine!"; } } }
//tipka za kombinaciju uvjeta filtriranja omogućava //filtriranje prema unesenoj riječi i prema godini studija protected void Button7_Click(object sender, EventArgs e) { using (MySqlConnection sqlConn = new MySqlConnection( ConfigurationManager.ConnectionStrings["defaultConnectionString"].ConnectionString)) { string cmdstr = ""; try { lbBrojZapisa.Text = ""; cmdstr = "select * from user.studenti where studenti.godina='" + tbTrazi.Text + "';"; gvStudenti.DataSource = PristupPodacima.VratiDataTable(cmdstr, paramTrazi); gvStudenti.DataBind(); } catch { tbTrazi.Text = "Nema rezultata!"; } } }