private void btnUpdate_Click(object sender, EventArgs e) { DBEntities db = new DBEntities(); int i = int.Parse(textBox2.Text); Conservative con = db.Conservatives.Where(a => a.Id == i).First(); con.Position = textBox3.Text; con.Name = textBox4.Text; con.Usefulness = checkBox1.Checked; db.SaveChanges(); populateGrid(db.Conservatives.ToList()); }
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex == -1) { return; } int c = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value; DBEntities db = new DBEntities(); Conservative con = db.Conservatives.Where(i => i.Id == c).First(); textBox2.Text = con.Id.ToString(); textBox3.Text = con.Position.ToString(); textBox4.Text = con.Name.ToString(); checkBox1.Checked = con.Usefulness; }
private void addToDb(List <string> cList) { DBEntities db = new DBEntities(); foreach (var item in cList) { string[] wordArray = item.Split(','); Conservative c = new Conservative(); c.Position = wordArray[0].ToString(); c.Name = wordArray[1].ToString(); c.Usefulness = false; db.Conservatives.Add(c); } db.SaveChanges(); }