private void button1_Click(object sender, EventArgs e) { int id = int.Parse(textBox1.Text); String name = textBox2.Text; int Sal = int.Parse(textBox3.Text); using (var db = new EmpEntities()) { var emp = new EmpTable() { Empid = id, EmpName = name, Salary = Sal }; db.EmpTables.Add(emp); db.SaveChanges(); textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); MessageBox.Show("Record Added Successfully"); } }
private void button2_Click(object sender, EventArgs e) { using (var db = new EmpEntities()) { var query = from b in db.EmpTables select b; DataTable d = new DataTable(); d.Columns.Add("EmpID", typeof(int)); d.Columns.Add("EmpName", typeof(string)); d.Columns.Add("Salary", typeof(int)); foreach (EmpTable item in query) { d.Rows.Add(item.Empid, item.EmpName, item.Salary); } dataGridView1.DataSource = d; } }