private void initial(Models.students entity) { itnumericupdownid1.Text = entity.id; ittextboxname2.Text = entity.name; ittextboxschool3.Text = entity.school; database = new MSSQLDatabase(new System.Data.SqlClient.SqlConnection(connstring)); }
public students(Models.students entity) { InitializeComponent(); regisEvents(); initial(entity); isUpdate = true; this.Text = "UpdateForm"; }
private void btnUpdate_Click(object sender, EventArgs e) { if (grvData.CurrentRow == null) { return; } Models.students selectedRow = (Models.students)grvData.CurrentRow.DataBoundItem; Views.students updateForm = new Views.students(selectedRow); updateForm.Show(); }
private void btnDelete_Click(object sender, EventArgs e) { try { Models.students selectedRow = (Models.students)grvData.CurrentRow.DataBoundItem; database.Table(typeof(Models.students)).Delete(selectedRow); MessageBox.Show("Delete successfully. Refresh..."); loadData(); } catch (SqlException ex) { MessageBox.Show(ex.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { string id = itnumericupdownid1.Text; string name = ittextboxname2.Text; string school = ittextboxschool3.Text; // add if (!isUpdate) { Models.students tmp = new Models.students(); tmp.id = id; tmp.name = name; tmp.school = school; database.Table(typeof(Models.students)).Insert(tmp); } // update else { Models.students tmp = new Models.students(); tmp.id = id; tmp.name = name; tmp.school = school; database.Table(typeof(Models.students)).Update(tmp); } } catch (InvalidCastException ex) { Debug.WriteLine(ex.Message); MessageBox.Show("Invalid value for type Number! Please try again."); this.Close(); } }