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);