private void button1_Click(object sender, EventArgs e) { //MessageBox.Show("Item has been added to the database!!"); string vid = textBox1.Text; double price = 0; string model = ""; try { int count = 0; //This is my connection string i have assigned the database file address path string MyConnection2 = "datasource=localhost;port=3306;username=root;password=aman"; //This is my insert query in which i am taking input from the user through windows forms string Query = "(SELECT V_MODEL,V_PRICE FROM automobile.vehicles where V_ID ='" + vid + "');";// and Password = '******')"; //This is MySqlConnection here i have created the object and pass my connection string. MySqlConnection MyConn2 = new MySqlConnection(MyConnection2); //This is command class which will handle the query and connection object. MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); MySqlDataReader MyReader2; MyConn2.Open(); MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database. //MessageBox.Show("Save Data"); while (MyReader2.Read()) { model = MyReader2.GetString("V_MODEL"); price = MyReader2.GetDouble("V_PRICE"); } //textBox2.Text = count.ToString(); MyConn2.Close(); } catch (Exception ex) { } try { //This is my connection string i have assigned the database file address path string MyConnection2 = "datasource=localhost;port=3306;username=root;password=aman"; //This is my insert query in which i am taking input from the user through windows forms string a = "SA4"; string show = "S1"; string Query = "insert into automobile.sales values('" + a + "','" + vid + "','" + Form2.id + "','" + show + "'," + price + ",'" + model + "');"; //This is MySqlConnection here i have created the object and pass my connection string. MySqlConnection MyConn2 = new MySqlConnection(MyConnection2); //This is command class which will handle the query and connection object. MySqlCommand MyCommand2 = new MySqlCommand(Query, MyConn2); MySqlDataReader MyReader2; MyConn2.Open(); MyReader2 = MyCommand2.ExecuteReader(); // Here our query will be executed and data saved into the database. MessageBox.Show("Save Data"); while (MyReader2.Read()) { } MyConn2.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }