update del

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;


namespace Database_Lecture
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}


Form1 _owner;
string f2Snumber;
public Form2(string snumber,Form1 owner)
{
InitializeComponent();
f2Snumber = snumber;
lblStudentNumber.Text = f2Snumber;
_owner = owner;
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.Form2_FormClosing);
}


private void btnSave_Click(object sender, EventArgs e)
{
clsDatabaseManager obj = new clsDatabaseManager();
string queryUpdateRecord = "Update tbl_student_record " +
@" Set [First Name] = '" + txtFirstName.Text + "', [Last Name] = '" + txtLastName.Text + "', " +
@" [Middle Name] = '" + txtMiddleName.Text + "', Age = '" + txtAge.Text + "', Course = '" + cboCourse.Text + "', " +
@" Address = '" + txtAddress.Text + "'" +
@" Where [Student Number] like '" + lblStudentNumber.Text + "'";


obj.execute(queryUpdateRecord);
this.DialogResult = DialogResult.OK;
}














private void btnDelete_Click(object sender, EventArgs e)
{
clsDatabaseManager obj = new clsDatabaseManager();
string queryDeleteRecord = "Delete from tbl_student_record where [Student Number] like '" + lblStudentNumber.Text + "'";
obj.execute(queryDeleteRecord);
this.DialogResult = DialogResult.OK;
}


private void Form2_Load(object sender, EventArgs e)
{
clsDatabaseManager obj = new clsDatabaseManager();
string queryCourse = "Select * from tbl_course";
string queryGetRecordOfSelectedStudentNumber = "Select * from tbl_student_record where [Student Number] like '" + lblStudentNumber.Text + "'";
obj.fillComboBox(cboCourse, queryCourse, ComboBoxStyle.DropDownList);
obj.retrieveData(queryGetRecordOfSelectedStudentNumber,txtFirstName,txtMiddleName ,txtLastName ,txtAge,txtAddress ,cboCourse );


}






private void Form2_FormClosing(object sender, FormClosingEventArgs e)
{
_owner.PerformRefresh();
}


}
}