private void buttonSave_Click(object sender, EventArgs e)
{
TestDBDataContext dc = new TestDBDataContext();
if (textBoxNo.ReadOnly == false)//Insert
{
Employee obj = new Employee();
obj.ID = int.Parse(textBoxNo.Text);
obj.Name = textBoxName.Text;
obj.City = textBoxCity.Text;
obj.Address = textBoxAddress.Text;
dc.Employees.InsertOnSubmit(obj);
dc.SubmitChanges();
MessageBox.Show("Records inserted into the table");
}
else//Update
{
Employee obj = dc.Employees.SingleOrDefault(E => E.ID == int.Parse(textBoxNo.Text));
obj.Name = textBoxName.Text;
obj.City = textBoxCity.Text;
obj.Address = textBoxAddress.Text;
dc.SubmitChanges();
MessageBox.Show("Record updated in table");
}
}
private void buttonDelete_Click(object sender, EventArgs e)
{
if (dgView.SelectedRows.Count > 0)
{
if (MessageBox.Show("Are you sure of deleting the selected row?", "Conformation", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
int ENo = Convert.ToInt32(dgView.SelectedRows[0].Cells[0].Value);
Employee obj = dc.Employees.SingleOrDefault(E => E.ID == ENo);
dc.Employees.DeleteOnSubmit(obj);
dc.SubmitChanges();
LoadData();
}
}
else
{
MessageBox.Show("Please select record for deletion.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}