private void button2_Click(object sender, RoutedEventArgs e) { string gender = null; try { SqlConnection _Conn = new SqlConnection(connectionString); _Conn.Open(); string authen = null; for (int i = 0; i < listBox1.Items.Count; i++) { authen += listBox1.Items.GetItemAt(i).ToString() + "|/|"; } if (radioButton1.IsChecked == true) { gender = "M"; } else if (radioButton2.IsChecked == true) { gender = "F"; } // Command String string _Insert = @"insert into Customer_Profile (Cust_Name,Cust_ID,Cust_address,Cust_landline,Cust_mobile, Cust_email,Cust_auth,Cust_profile_create,gender,cust_refer) Values('" + Cust_name.Text + "','" + Cust_id.Text + "','" + Cust_address.Text + "','" + Cust_land_1.Text + "-" + Cust_land_2.Text + "','" + Cust_mobile.Text + "','" + Cust_email.Text + "','" + authen + "','" + Cust_date.Text + "','" + gender + "','" + Cust_Refer.Text + "')"; SqlCommand _cmd = new SqlCommand(_Insert, _Conn); _cmd.ExecuteNonQuery(); MessageBox.Show("One Record Inserted"); MainWindow mw = new MainWindow(); this.Close(); mw.Show(); Cust_IDCard card = new Cust_IDCard(); card.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }
private void button2_Click(object sender, RoutedEventArgs e) { string gender = null; try { SqlConnection _Conn = new SqlConnection(connectionString); _Conn.Open(); string authen=null; for (int i = 0; i < listBox1.Items.Count; i++) { authen += listBox1.Items.GetItemAt(i).ToString()+"|/|"; } if (radioButton1.IsChecked == true) { gender = "M"; } else if (radioButton2.IsChecked == true) { gender = "F"; } // Command String string _Insert = @"insert into Customer_Profile (Cust_Name,Cust_ID,Cust_address,Cust_landline,Cust_mobile, Cust_email,Cust_auth,Cust_profile_create,gender,cust_refer) Values('" + Cust_name.Text + "','" + Cust_id.Text + "','" + Cust_address.Text + "','" + Cust_land_1.Text+"-"+Cust_land_2.Text + "','" + Cust_mobile.Text + "','" + Cust_email.Text + "','" + authen + "','" + Cust_date.Text + "','" + gender + "','" + Cust_Refer.Text + "')"; SqlCommand _cmd = new SqlCommand(_Insert, _Conn); _cmd.ExecuteNonQuery(); MessageBox.Show("One Record Inserted"); MainWindow mw = new MainWindow(); this.Close(); mw.Show(); Cust_IDCard card = new Cust_IDCard(); card.Show(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }