private void btnInsert_Click(object sender, EventArgs e)
{
var dbCtx = new ValtechDBDataContext();//creating object for connection
tbl_employee record = new tbl_employee
{
Ecode = int.Parse(txtEcode.Text),
Ename = txtEname.Text,
salary = int.Parse(txtSalary.Text),
deptid = int.Parse(txtDeptid.Text)
};
//insert using linq to sql
dbCtx.tbl_employees.InsertOnSubmit(record);
//save changes to database
dbCtx.SubmitChanges();
MessageBox.Show("Record inserted");
//refresh datagrid
RefreshData();
}
partial void Deletetbl_employee(tbl_employee instance);
partial void Updatetbl_employee(tbl_employee instance);
partial void Inserttbl_employee(tbl_employee instance);
