private void button1_Click(object sender, EventArgs e) { fill_textBox(); string start = comboBox1.Text; string destination = comboBox2.Text; string Class = paseclass(); string type = pasetype(); string passe = textBox1.Text; string price = textBox4.Text; // string tno = textBox5.Text; textBox6.Text = Class; textBox7.Text = type; textBox8.Text = passe; //textBox9.Text = tno; textBox12.Text = start; textBox13.Text = destination; textBox14.Text = price; string tcktno = textBox9.Text; string pclass = textBox6.Text; string tdate = textBox10.Text; string ttime = textBox11.Text; string ptype = textBox7.Text; string froms = textBox12.Text; string tos = textBox13.Text; string noOfPasse = textBox8.Text; string Price = textBox14.Text; string cno = comboBox6.Text; string trainid = comboBox5.Text; SqlConnection con = new DBConnector().getConnection(); try { con.Open(); SqlCommand cmd2 = con.CreateCommand(); cmd2.CommandType = CommandType.Text; cmd2.CommandText = "insert into tdt values('" + tcktno + "','" + pclass + "','" + tdate + "','" + ttime + "','" + ptype + "','" + froms + "','" + tos + "','" + noOfPasse + "','" + Price + "','" + trainid + "','" + cno + "')"; int b = cmd2.ExecuteNonQuery(); if (b > 0) { /*printDialog1.Document = printDocument1; * if (printDialog1.ShowDialog() == DialogResult.OK) * { * * printDocument1.Print(); * * * * * }*/ MessageBox.Show("add successfully"); } else { MessageBox.Show("Printing Failed", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } }