private void btnregister_Click(object sender, EventArgs e) { //form data //retrieve data from textbox string name = txtname.Text; //combobox string gender = cbgender.SelectedItem.ToString(); //radio button string membership = ""; if (rbfree.Checked) { membership = rbfree.Text; } if (rbpaid.Checked) { membership = rbpaid.Text; } //checklistbox string shopping = ""; foreach (var d in clbshop.CheckedItems) { shopping += d + ","; } //checkbox string cod = ""; if (cbcod.Checked) { cod = "yes"; } else { cod = "no"; } string pass = txtpassword.Text; MessageBox.Show(name + "\n" + gender + "\n" + membership + "\n" + shopping + "\n" + cod + "\n" + pass); //insert data to db through entity framework RegisterShopping rs = new RegisterShopping(); rs.Name = name; rs.Gender = gender; rs.Membership = membership; rs.ShoppingPreference = shopping; rs.COD = cod; rs.Password = pass; db.RegisterShoppings.Add(rs); var res = db.SaveChanges(); if (res > 0) { MessageBox.Show("Data inserted"); } this.registerShoppingTableAdapter.Fill(this.tRainingdbDataSet.RegisterShopping); }
private void btnregister_Click(object sender, EventArgs e) { //form data string name = txtname.Text; string gender = cbgender.SelectedItem.ToString(); string membership = ""; if (rbfree.Checked) { membership = rbfree.Text; } if (rbpaid.Checked) { membership = rbpaid.Text; } string preference = ""; foreach (var d in clbshop.CheckedItems) { preference += d + ","; } string cod = ""; if (cbcod.Checked) { cod = "Yes"; } else { cod = "No"; } string password = txtpassword.Text; MessageBox.Show(name + "\n" + gender + "\n" + membership + "\n" + preference + "\n" + cod + "\n" + password); //insert data to DB to entity frame work RegisterShopping rs = new RegisterShopping(); rs.Name = name; rs.Gender = gender; rs.Membership = membership; rs.Shopping_Preference = preference; rs.Cod = cod; rs.Password = password; db.RegisterShoppings.Add(rs); var result = db.SaveChanges(); if (result > 0) { MessageBox.Show("Data Inserted..."); } this.registerShoppingTableAdapter.Fill(this.trainingDBDataSet.RegisterShopping); }