Insert into multiple table PM and FkEy mysql database.

I want that value tblpetinfo.petid = tblpetowner.petid and tbladdress.address = tblpetowner.addressid

Can you add a condition for Terms List Box = lbTerm, CheckBox I Agree = chkTerm

Thank!!!

SOURCE CODE:::

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.Configuration;
namespace gpis
{
public partial class registrationform : Form
{
public registrationform()
{
InitializeComponent();
}
private void picHome_Click(object sender, EventArgs e)
{
menu frm = new menu();
frm.Show();
this.Hide();
}
private void bRegister_Click(object sender, EventArgs e)
{
try
{
//This is my connection string i have assigned the database file address path
string dbsource = "datasource=localhost;port=3306;username=root;password=admin1234; database=db_gpis";
//This is MySqlConnection here i have created the object and pass my connection string
MySqlConnection MyConn1 = new MySqlConnection(dbsource);
//This is my insert query in which i am taking input from the user through windows forms
string qpowner = "insert into tblpetowner (polname,pofname,pomi,podob,pogen,pocontact,poemail,addressid) values(@ln,@fn,@mi,@dob,@gen,@cn,@em,addressid);";
//This is command class which will handle the vetinsert and myconn1 object.
MySqlCommand cmd1 = new MySqlCommand(qpowner, MyConn1);
cmd1.Parameters.AddWithValue("@ln", tLastname.Text);
cmd1.Parameters.AddWithValue("@fn", tFirstname.Text);
cmd1.Parameters.AddWithValue("@mi", tMiddleinitial.Text);
cmd1.Parameters.AddWithValue("@dob", tDob.Text);
cmd1.Parameters.AddWithValue("@gen", cmbGender.Text);
cmd1.Parameters.AddWithValue("@cn", tContactnum.Text);
cmd1.Parameters.AddWithValue("@em", tEmailadd.Text);
MySqlDataReader rdr1;
MyConn1.Open();
rdr1 = cmd1.ExecuteReader(); // Here our query will be executed and data saved into the database.
//while (rdr1.Read())
//{
//}
//MyConn1.Close();
//NEW CONNECTION
MySqlConnection addconn2 = new MySqlConnection(dbsource);
//This is my insert query in which i am taking input from the user through windows forms
string qaddress = "insert into tbladdress (addressid,hnum,street,brgy,city,region,country,zcode) values(@id,@hn,@st,@brgy,@cty,@re,@coun,@zc);";
//This is MySqlConnection here i have created the object and pass my connection string.
//This is command class which will handle the query and connection object.
MySqlCommand cmd2 = new MySqlCommand(qaddress, addconn2);
cmd2.Parameters.AddWithValue("@id", null);
cmd2.Parameters.AddWithValue("@hn", tHousenum.Text);
cmd2.Parameters.AddWithValue("@st", tStreet.Text);
cmd2.Parameters.AddWithValue("@brgy", tBrgy.Text);
cmd2.Parameters.AddWithValue("@cty", cmbCity.Text);
cmd2.Parameters.AddWithValue("@re", cmbRegion.Text);
cmd2.Parameters.AddWithValue("@coun", cmbCountry.Text);
cmd2.Parameters.AddWithValue("@zc", tZipcode.Text);
MySqlDataReader rdr2;
addconn2.Open();
rdr2 = cmd2.ExecuteReader();
//while (rdr2.Read())
//{
//}
//addconn2.Close();
//NEW CONNECTION
MySqlConnection addconn3 = new MySqlConnection(dbsource);
//This is my insert query in which i am taking input from the user through windows forms
string qpet = "insert into tblpetinfo (petid,petname, petcolor, petgen, ptype, pbreed) values(@id,@pn,@pc,@pg,@pt,@pb);";
//This is MySqlConnection here i have created the object and pass my connection string.
//This is command class which will handle the query and connection object.
MySqlCommand cmd3 = new MySqlCommand(qpet, addconn3);
cmd3.Parameters.AddWithValue("@id", null);
cmd3.Parameters.AddWithValue("@pn", tPetname.Text);
cmd3.Parameters.AddWithValue("@pc", tPetcolor.Text);
cmd3.Parameters.AddWithValue("@pg", cmbPetgender.Text);
cmd3.Parameters.AddWithValue("@pt", cmbType.Text);
cmd3.Parameters.AddWithValue("@pb", cmbBreed.Text);
MySqlDataReader rdr3;
addconn3.Open();
rdr3 = cmd3.ExecuteReader();
MessageBox.Show("Successful account registered");
menu menuForm = new menu();
menuForm.Show();
this.Hide();
while (rdr3.Read())
{
}
addconn3.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Enzo Enzo9y ago
Hi Bikesh! I dont have Idea about transaction scope. Can you apply with my codes?
Enzo Enzo9y ago
My registration form has different table, then I would like that tblpetowner, tbladdrss and petowner to be linked using foreign key. How to apply in C#?
Bikesh Srivastava9y ago
Hi,
I think you are doing good ,but you need to change some little bit of code,
due to transaction issue you need to use transaction scope in this application.