arkadaşlar bu kodu javaya çevirebilir misiniz çok acil yardımlarınızı bkliyorum
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms;
namespace WindowsFormsApplication1
{ public partial class Form1 : Form
{ public Form2 frm2; public Form3 frm3; public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm2.frm1 = this;
frm3.frm1 = this;
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb"); public OleDbCommand kmt = new OleDbCommand(); public OleDbDataAdapter adtr = new OleDbDataAdapter(); public DataSet dtst = new DataSet();
public **** combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from bos";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{
comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox1.Sorted = true;
}
public **** combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from dolu";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{
frm3.comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
frm3.comboBox1.Sorted = true;
}
public **** listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From musbil", bag);
adtr.Fill(dtst, "musbil");
frm3.dataView1.Table = dtst.Tables[0];
frm3.dataGrid1.DataSource = frm3.dataView1;
adtr.Dispose();
bag.Close();
}
public **** biletyaz()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from musbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{ switch (oku[13].ToString())
{ case "1":
{
frm2.button1.Text = oku[4].ToString();
frm2.button1.BackColor = System.Drawing.Color.Red; break;
} case "2":
{
frm2.button2.Text = oku[4].ToString();
frm2.button2.BackColor = System.Drawing.Color.Red; break;
} case "3":
{
frm2.button3.Text = oku[4].ToString();
frm2.button3.BackColor = System.Drawing.Color.Red; break;
} case "4":
{
frm2.button4.Text = oku[4].ToString();
frm2.button4.BackColor = System.Drawing.Color.Red; break;
} case "5":
{
frm2.button5.Text = oku[4].ToString();
frm2.button5.BackColor = System.Drawing.Color.Red; break;
} case "6":
{
frm2.button6.Text = oku[4].ToString();
frm2.button6.BackColor = System.Drawing.Color.Red; break;
} case "7":
{
frm2.button7.Text = oku[4].ToString();
frm2.button7.BackColor = System.Drawing.Color.Red; break;
} case "8":
{
frm2.button8.Text = oku[4].ToString();
frm2.button8.BackColor = System.Drawing.Color.Red; break;
} case "9":
{
frm2.button9.Text = oku[4].ToString();
frm2.button9.BackColor = System.Drawing.Color.Red; break;
} case "10":
{
frm2.button10.Text = oku[4].ToString();
frm2.button10.BackColor = System.Drawing.Color.Red; break;
} case "11":
{
frm2.button11.Text = oku[4].ToString();
frm2.button11.BackColor = System.Drawing.Color.Red; break;
} case "12":
{
frm2.button12.Text = oku[4].ToString();
frm2.button12.BackColor = System.Drawing.Color.Red; break;
} case "13":
{
frm2.button13.Text = oku[4].ToString();
frm2.button13.BackColor = System.Drawing.Color.Red; break;
} case "14":
{
frm2.button14.Text = oku[4].ToString();
frm2.button14.BackColor = System.Drawing.Color.Red; break;
} case "15":
{
frm2.button15.Text = oku[4].ToString();
frm2.button15.BackColor = System.Drawing.Color.Red; break;
} case "16":
{
frm2.button16.Text = oku[4].ToString();
frm2.button16.BackColor = System.Drawing.Color.Red; break;
} case "17":
{
frm2.button17.Text = oku[4].ToString();
frm2.button17.BackColor = System.Drawing.Color.Red; break;
} case "18":
{
frm2.button18.Text = oku[4].ToString();
frm2.button18.BackColor = System.Drawing.Color.Red; break;
} case "19":
{
frm2.button19.Text = oku[4].ToString();
frm2.button19.BackColor = System.Drawing.Color.Red; break;
} case "20":
{
frm2.button20.Text = oku[4].ToString();
frm2.button20.BackColor = System.Drawing.Color.Red; break;
} case "21":
{
frm2.button21.Text = oku[4].ToString();
frm2.button21.BackColor = System.Drawing.Color.Red; break;
} case "22":
{
frm2.button22.Text = oku[4].ToString();
frm2.button22.BackColor = System.Drawing.Color.Red; break;
} case "23":
{
frm2.button23.Text = oku[4].ToString();
frm2.button23.BackColor = System.Drawing.Color.Red; break;
} case "24":
{
frm2.button24.Text = oku[4].ToString();
frm2.button24.BackColor = System.Drawing.Color.Red; break;
} case "25":
{
frm2.button25.Text = oku[4].ToString();
frm2.button25.BackColor = System.Drawing.Color.Red; break;
} case "26":
{
frm2.button26.Text = oku[4].ToString();
frm2.button26.BackColor = System.Drawing.Color.Red; break;
} case "27":
{
frm2.button27.Text = oku[4].ToString();
frm2.button27.BackColor = System.Drawing.Color.Red; break;
} case "28":
{
frm2.button28.Text = oku[4].ToString();
frm2.button28.BackColor = System.Drawing.Color.Red; break;
} case "29":
{
frm2.button29.Text = oku[4].ToString();
frm2.button29.BackColor = System.Drawing.Color.Red; break;
} case "30":
{
frm2.button30.Text = oku[4].ToString();
frm2.button30.BackColor = System.Drawing.Color.Red; break;
} case "31":
{
frm2.button31.Text = oku[4].ToString();
frm2.button31.BackColor = System.Drawing.Color.Red; break;
} case "32":
{
frm2.button32.Text = oku[4].ToString();
frm2.button32.BackColor = System.Drawing.Color.Red; break;
} case "33":
{
frm2.button33.Text = oku[4].ToString();
frm2.button33.BackColor = System.Drawing.Color.Red; break;
} case "34":
{
frm2.button34.Text = oku[4].ToString();
frm2.button34.BackColor = System.Drawing.Color.Red; break;
}
}
}
bag.Close();
oku.Dispose();
}
public **** biletsil()
{ switch (frm3.comboBox1.Text)
{ case "1":
{
frm2.button1.Text = "1";
frm2.button1.BackColor = System.Drawing.Color.Green; break;
} case "2":
{
frm2.button2.Text = "2";
frm2.button2.BackColor = System.Drawing.Color.Green; break;
} case "3":
{
frm2.button3.Text = "3";
frm2.button3.BackColor = System.Drawing.Color.Green; break;
} case "4":
{
frm2.button4.Text = "4";
frm2.button4.BackColor = System.Drawing.Color.Red; break;
} case "5":
{
frm2.button5.Text = "5";
frm2.button5.BackColor = System.Drawing.Color.Green; break;
} case "6":
{
frm2.button6.Text = "6";
frm2.button6.BackColor = System.Drawing.Color.Green; break;
} case "7":
{
frm2.button7.Text = "7";
frm2.button7.BackColor = System.Drawing.Color.Green; break;
} case "8":
{
frm2.button8.Text = "8";
frm2.button8.BackColor = System.Drawing.Color.Green; break;
} case "9":
{
frm2.button9.Text = "9";
frm2.button9.BackColor = System.Drawing.Color.Green; break;
} case "10":
{
frm2.button10.Text = "10";
frm2.button10.BackColor = System.Drawing.Color.Green; break;
} case "11":
{
frm2.button11.Text = "11";
frm2.button11.BackColor = System.Drawing.Color.Green; break;
} case "12":
{
frm2.button12.Text = "12";
frm2.button12.BackColor = System.Drawing.Color.Green; break;
} case "13":
{
frm2.button13.Text = "13";
frm2.button13.BackColor = System.Drawing.Color.Green; break;
} case "14":
{
frm2.button14.Text = "14";
frm2.button14.BackColor = System.Drawing.Color.Green; break;
} case "15":
{
frm2.button15.Text = "15";
frm2.button15.BackColor = System.Drawing.Color.Green; break;
} case "16":
{
frm2.button16.Text = "16";
frm2.button16.BackColor = System.Drawing.Color.Green; break;
} case "17":
{
frm2.button17.Text = "17";
frm2.button17.BackColor = System.Drawing.Color.Green; break;
} case "18":
{
frm2.button18.Text = "18";
frm2.button18.BackColor = System.Drawing.Color.Green; break;
} case "19":
{
frm2.button19.Text = "19";
frm2.button19.BackColor = System.Drawing.Color.Green; break;
} case "20":
{
frm2.button20.Text = "20";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "21":
{
frm2.button20.Text = "21";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "22":
{
frm2.button20.Text = "22";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "23":
{
frm2.button20.Text = "23";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "24":
{
frm2.button20.Text = "24";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "25":
{
frm2.button20.Text = "25";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "26":
{
frm2.button20.Text = "26";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "27":
{
frm2.button20.Text = "27";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "28":
{
frm2.button20.Text = "28";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "29":
{
frm2.button20.Text = "29";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "30":
{
frm2.button20.Text = "30";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "31":
{
frm2.button20.Text = "31";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "32":
{
frm2.button20.Text = "33";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "33":
{
frm2.button20.Text = "33";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "34":
{
frm2.button20.Text = "34";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
}
}
} private **** Form1_Load(object sender, EventArgs e)
{
combo();
}
private **** button2_Click(object sender, EventArgs e)
{
frm2.Show(); this.Hide();
}
private **** button4_Click(object sender, EventArgs e)
{
Application.Exit();
}
private **** button1_Click(object sender, EventArgs e)
{
frm3.Show(); this.Hide();
}
private **** button3_Click(object sender, EventArgs e)
{ if (textBox1.Text != "" && textBox2.Text != "" && comboBox1.Text != "")
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO musbil(Adi,Soyadi,Adres,Tel_No,E_Posta,Binis_Yeri,Binis_Saati,Varis_Yeri,Varis_Saati,Yol_Tarihi,Sefer_No,Sefer_Güz,Otobüs_Tipi,Koltuk_Num) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox12.Text + "','" + textBox13.Text + "','" + comboBox1.Text + "') ";
kmt.ExecuteNonQuery();
kmt.CommandText = "INSERT INTO dolu(doluyerler) VALUES ('" + comboBox1.Text + "') ";
kmt.ExecuteNonQuery();
kmt.CommandText = "DELETE from bos WHERE bosyerler='" + comboBox1.Text + "'";
kmt.ExecuteNonQuery();
kmt.Dispose();
bag.Close();
comboBox1.Items.Clear();
textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear();
textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear();
textBox9.Clear(); textBox10.Clear(); textBox11.Clear(); textBox12.Clear();
textBox13.Clear();
comboBox1.Text = "";
combo();
biletyaz();
MessageBox.Show("Kayıt işlemi tamamlandı ! ");
} else
{
MessageBox.Show("Boş alanları doldurunuz !!!");
}
}
}
}
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms;
namespace WindowsFormsApplication1
{ public partial class Form1 : Form
{ public Form2 frm2; public Form3 frm3; public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm2.frm1 = this;
frm3.frm1 = this;
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb"); public OleDbCommand kmt = new OleDbCommand(); public OleDbDataAdapter adtr = new OleDbDataAdapter(); public DataSet dtst = new DataSet();
public **** combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from bos";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{
comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
comboBox1.Sorted = true;
}
public **** combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from dolu";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{
frm3.comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
frm3.comboBox1.Sorted = true;
}
public **** listelesene()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From musbil", bag);
adtr.Fill(dtst, "musbil");
frm3.dataView1.Table = dtst.Tables[0];
frm3.dataGrid1.DataSource = frm3.dataView1;
adtr.Dispose();
bag.Close();
}
public **** biletyaz()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from musbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader(); while (oku.Read())
{ switch (oku[13].ToString())
{ case "1":
{
frm2.button1.Text = oku[4].ToString();
frm2.button1.BackColor = System.Drawing.Color.Red; break;
} case "2":
{
frm2.button2.Text = oku[4].ToString();
frm2.button2.BackColor = System.Drawing.Color.Red; break;
} case "3":
{
frm2.button3.Text = oku[4].ToString();
frm2.button3.BackColor = System.Drawing.Color.Red; break;
} case "4":
{
frm2.button4.Text = oku[4].ToString();
frm2.button4.BackColor = System.Drawing.Color.Red; break;
} case "5":
{
frm2.button5.Text = oku[4].ToString();
frm2.button5.BackColor = System.Drawing.Color.Red; break;
} case "6":
{
frm2.button6.Text = oku[4].ToString();
frm2.button6.BackColor = System.Drawing.Color.Red; break;
} case "7":
{
frm2.button7.Text = oku[4].ToString();
frm2.button7.BackColor = System.Drawing.Color.Red; break;
} case "8":
{
frm2.button8.Text = oku[4].ToString();
frm2.button8.BackColor = System.Drawing.Color.Red; break;
} case "9":
{
frm2.button9.Text = oku[4].ToString();
frm2.button9.BackColor = System.Drawing.Color.Red; break;
} case "10":
{
frm2.button10.Text = oku[4].ToString();
frm2.button10.BackColor = System.Drawing.Color.Red; break;
} case "11":
{
frm2.button11.Text = oku[4].ToString();
frm2.button11.BackColor = System.Drawing.Color.Red; break;
} case "12":
{
frm2.button12.Text = oku[4].ToString();
frm2.button12.BackColor = System.Drawing.Color.Red; break;
} case "13":
{
frm2.button13.Text = oku[4].ToString();
frm2.button13.BackColor = System.Drawing.Color.Red; break;
} case "14":
{
frm2.button14.Text = oku[4].ToString();
frm2.button14.BackColor = System.Drawing.Color.Red; break;
} case "15":
{
frm2.button15.Text = oku[4].ToString();
frm2.button15.BackColor = System.Drawing.Color.Red; break;
} case "16":
{
frm2.button16.Text = oku[4].ToString();
frm2.button16.BackColor = System.Drawing.Color.Red; break;
} case "17":
{
frm2.button17.Text = oku[4].ToString();
frm2.button17.BackColor = System.Drawing.Color.Red; break;
} case "18":
{
frm2.button18.Text = oku[4].ToString();
frm2.button18.BackColor = System.Drawing.Color.Red; break;
} case "19":
{
frm2.button19.Text = oku[4].ToString();
frm2.button19.BackColor = System.Drawing.Color.Red; break;
} case "20":
{
frm2.button20.Text = oku[4].ToString();
frm2.button20.BackColor = System.Drawing.Color.Red; break;
} case "21":
{
frm2.button21.Text = oku[4].ToString();
frm2.button21.BackColor = System.Drawing.Color.Red; break;
} case "22":
{
frm2.button22.Text = oku[4].ToString();
frm2.button22.BackColor = System.Drawing.Color.Red; break;
} case "23":
{
frm2.button23.Text = oku[4].ToString();
frm2.button23.BackColor = System.Drawing.Color.Red; break;
} case "24":
{
frm2.button24.Text = oku[4].ToString();
frm2.button24.BackColor = System.Drawing.Color.Red; break;
} case "25":
{
frm2.button25.Text = oku[4].ToString();
frm2.button25.BackColor = System.Drawing.Color.Red; break;
} case "26":
{
frm2.button26.Text = oku[4].ToString();
frm2.button26.BackColor = System.Drawing.Color.Red; break;
} case "27":
{
frm2.button27.Text = oku[4].ToString();
frm2.button27.BackColor = System.Drawing.Color.Red; break;
} case "28":
{
frm2.button28.Text = oku[4].ToString();
frm2.button28.BackColor = System.Drawing.Color.Red; break;
} case "29":
{
frm2.button29.Text = oku[4].ToString();
frm2.button29.BackColor = System.Drawing.Color.Red; break;
} case "30":
{
frm2.button30.Text = oku[4].ToString();
frm2.button30.BackColor = System.Drawing.Color.Red; break;
} case "31":
{
frm2.button31.Text = oku[4].ToString();
frm2.button31.BackColor = System.Drawing.Color.Red; break;
} case "32":
{
frm2.button32.Text = oku[4].ToString();
frm2.button32.BackColor = System.Drawing.Color.Red; break;
} case "33":
{
frm2.button33.Text = oku[4].ToString();
frm2.button33.BackColor = System.Drawing.Color.Red; break;
} case "34":
{
frm2.button34.Text = oku[4].ToString();
frm2.button34.BackColor = System.Drawing.Color.Red; break;
}
}
}
bag.Close();
oku.Dispose();
}
public **** biletsil()
{ switch (frm3.comboBox1.Text)
{ case "1":
{
frm2.button1.Text = "1";
frm2.button1.BackColor = System.Drawing.Color.Green; break;
} case "2":
{
frm2.button2.Text = "2";
frm2.button2.BackColor = System.Drawing.Color.Green; break;
} case "3":
{
frm2.button3.Text = "3";
frm2.button3.BackColor = System.Drawing.Color.Green; break;
} case "4":
{
frm2.button4.Text = "4";
frm2.button4.BackColor = System.Drawing.Color.Red; break;
} case "5":
{
frm2.button5.Text = "5";
frm2.button5.BackColor = System.Drawing.Color.Green; break;
} case "6":
{
frm2.button6.Text = "6";
frm2.button6.BackColor = System.Drawing.Color.Green; break;
} case "7":
{
frm2.button7.Text = "7";
frm2.button7.BackColor = System.Drawing.Color.Green; break;
} case "8":
{
frm2.button8.Text = "8";
frm2.button8.BackColor = System.Drawing.Color.Green; break;
} case "9":
{
frm2.button9.Text = "9";
frm2.button9.BackColor = System.Drawing.Color.Green; break;
} case "10":
{
frm2.button10.Text = "10";
frm2.button10.BackColor = System.Drawing.Color.Green; break;
} case "11":
{
frm2.button11.Text = "11";
frm2.button11.BackColor = System.Drawing.Color.Green; break;
} case "12":
{
frm2.button12.Text = "12";
frm2.button12.BackColor = System.Drawing.Color.Green; break;
} case "13":
{
frm2.button13.Text = "13";
frm2.button13.BackColor = System.Drawing.Color.Green; break;
} case "14":
{
frm2.button14.Text = "14";
frm2.button14.BackColor = System.Drawing.Color.Green; break;
} case "15":
{
frm2.button15.Text = "15";
frm2.button15.BackColor = System.Drawing.Color.Green; break;
} case "16":
{
frm2.button16.Text = "16";
frm2.button16.BackColor = System.Drawing.Color.Green; break;
} case "17":
{
frm2.button17.Text = "17";
frm2.button17.BackColor = System.Drawing.Color.Green; break;
} case "18":
{
frm2.button18.Text = "18";
frm2.button18.BackColor = System.Drawing.Color.Green; break;
} case "19":
{
frm2.button19.Text = "19";
frm2.button19.BackColor = System.Drawing.Color.Green; break;
} case "20":
{
frm2.button20.Text = "20";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "21":
{
frm2.button20.Text = "21";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "22":
{
frm2.button20.Text = "22";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "23":
{
frm2.button20.Text = "23";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "24":
{
frm2.button20.Text = "24";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "25":
{
frm2.button20.Text = "25";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "26":
{
frm2.button20.Text = "26";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "27":
{
frm2.button20.Text = "27";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "28":
{
frm2.button20.Text = "28";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "29":
{
frm2.button20.Text = "29";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "30":
{
frm2.button20.Text = "30";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "31":
{
frm2.button20.Text = "31";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "32":
{
frm2.button20.Text = "33";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "33":
{
frm2.button20.Text = "33";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
} case "34":
{
frm2.button20.Text = "34";
frm2.button20.BackColor = System.Drawing.Color.Green; break;
}
}
} private **** Form1_Load(object sender, EventArgs e)
{
combo();
}
private **** button2_Click(object sender, EventArgs e)
{
frm2.Show(); this.Hide();
}
private **** button4_Click(object sender, EventArgs e)
{
Application.Exit();
}
private **** button1_Click(object sender, EventArgs e)
{
frm3.Show(); this.Hide();
}
private **** button3_Click(object sender, EventArgs e)
{ if (textBox1.Text != "" && textBox2.Text != "" && comboBox1.Text != "")
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "INSERT INTO musbil(Adi,Soyadi,Adres,Tel_No,E_Posta,Binis_Yeri,Binis_Saati,Varis_Yeri,Varis_Saati,Yol_Tarihi,Sefer_No,Sefer_Güz,Otobüs_Tipi,Koltuk_Num) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "','" + textBox6.Text + "','" + textBox7.Text + "','" + textBox8.Text + "','" + textBox9.Text + "','" + textBox10.Text + "','" + textBox11.Text + "','" + textBox12.Text + "','" + textBox13.Text + "','" + comboBox1.Text + "') ";
kmt.ExecuteNonQuery();
kmt.CommandText = "INSERT INTO dolu(doluyerler) VALUES ('" + comboBox1.Text + "') ";
kmt.ExecuteNonQuery();
kmt.CommandText = "DELETE from bos WHERE bosyerler='" + comboBox1.Text + "'";
kmt.ExecuteNonQuery();
kmt.Dispose();
bag.Close();
comboBox1.Items.Clear();
textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear();
textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear();
textBox9.Clear(); textBox10.Clear(); textBox11.Clear(); textBox12.Clear();
textBox13.Clear();
comboBox1.Text = "";
combo();
biletyaz();
MessageBox.Show("Kayıt işlemi tamamlandı ! ");
} else
{
MessageBox.Show("Boş alanları doldurunuz !!!");
}
}
}
}
Moderatör tarafında düzenlendi:

