protected void gridKlanten_RowUpdating(object sender, GridViewUpdateEventArgs e) { classes.databasemanager dm = new classes.databasemanager(); string naam = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditNaam")).Text; string adres = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditAdres")).Text; string telefon = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditTelefoon")).Text; string email = ((TextBox)gridKlanten.Rows[e.RowIndex].FindControl("txtEditEmail")).Text; dm.updatecustomer(naam, adres, telefon, email); gridKlanten.EditIndex = -1; databind(); // lblMessage.Text = lblid.ToString() + " : Row updated"; // email moet altijd the same blijven }
///<summary> ///<para>Creates customer if email unused</para> ///<para>Updates customer info in email known</para> ///</summary> public bool customerupdate(string name, string adres, string telefon, string email) { classes.databasemanager dm = new classes.databasemanager(); bool update = false; DataTable user = dm.getdatatablebyquery("select * from klant where email='" + email + "'"); foreach (DataRow row in user.Rows) { update = true; dm.updatecustomer(name, adres, telefon, email); } if (update == false) { dm.insertcustomer(name, adres, telefon, email); } return(true); }