Hi everyone,
I've tried to save details in a data table from two winforms. It is saving form1 data in 1st row and form2 data in 2nd row. But i want it to save in a single row. Can you guys suggest me how?
//FORM1 CODE
private void button1_Click(object sender, EventArgs e)
{
string c = @"Data Source=mysql; Initial Catalog=SampleDB; Integrated Security=True";
Form2 f2 = new Form2();
SqlConnection con = new SqlConnection(c);
con.Open();
SqlCommand cmd = new SqlCommand("studentdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name",txtName.Text.Trim());
cmd.Parameters.AddWithValue("@Contact",txtContact.Text.Trim());
cmd.Parameters.AddWithValue("@Email", f2.txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@Address", f2.txtAddress.Text.Trim());
cmd.ExecuteNonQuery();
MessageBox.Show("Details Saved..!");
}
private void button2_Click(object sender, EventArgs e)
{
Form2 f2 = new Form2();
f2.Show();
}
//FORM2 CODE
private void button1_Click(object sender, EventArgs e)
{
string c = @"Data Source=mysql; Initial Catalog=SampleDB; Integrated Security=True";
Form1 f1=new Form1();
SqlConnection con = new SqlConnection(c);
con.Open();
SqlCommand cmd = new SqlCommand("studentdetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name",f1.txtName.Text.Trim() );
cmd.Parameters.AddWithValue("@Contact",f1.txtContact.Text.Trim());
cmd.Parameters.AddWithValue("@Email", txtEmail.Text.Trim());
cmd.Parameters.AddWithValue("@Address", txtAddress.Text.Trim());
cmd.ExecuteNonQuery();
MessageBox.Show("Details Saved..!");
}