private void displayButton_Click(object sender, EventArgs e) { using (var db = new StudentFormDBEntities()) { var query = from b in db.StudentFormTables select b; DataTable dt = new DataTable(); dt.Columns.Add("Roll_No", typeof(int)); dt.Columns.Add("Name", typeof(string)); dt.Columns.Add("Marks", typeof(int)); foreach (StudentFormTable item in query) { dt.Rows.Add(item.StudentID, item.Name, item.Marks); } dataGridView1.DataSource = dt; } }
private void addButton_Click(object sender, EventArgs e) { int rollNo = int.Parse(rollNoTextbox.Text); string name = nameTextbox.Text; int marks = int.Parse(marksTextbox.Text); using (var db = new StudentFormDBEntities()) { var studentdb = new StudentFormTable() { StudentID = rollNo, Name = name, Marks = marks, }; db.StudentFormTables.Add(studentdb); db.SaveChanges(); rollNoTextbox.Clear(); nameTextbox.Clear(); marksTextbox.Clear(); } }