Save data entered from two forms

Question

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..!");

}