private void btnGoster_Click(object sender, EventArgs e)
{
connection = @"Data Source =C:\Users\merve_l7t2av4\Desktop\Yeni klasör\otel.db;version=3";
SQLiteConnection bag = new SQLiteConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
aramaAgaci = new IkiliAramaAgaci();
while (dr.Read())
{
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
switch (cmbAgacDuzeyi.SelectedIndex)
{
case 0:
aramaAgaci.PreOrder();
break;
case 1:
aramaAgaci.InOrder();
break;
case 2:
aramaAgaci.PostOrder();
break;
default:
break;
}
MessageBox.Show(aramaAgaci.DugumleriYazdir().ToString());
}
private void frmOtelGoruntule_Load(object sender, EventArgs e)
{
connection = @"Data Source =C:\Users\merve_l7t2av4\Desktop\veriYapilari\Yeni klasör\otel.db;version=3";
SQLiteConnection bag = new SQLiteConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SQLiteCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
aramaAgaci = new IkiliAramaAgaci();
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void frmOtelGoruntule_Load(object sender, EventArgs e)
{
connection = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\OtelDB.mdf;Integrated Security=True;Connect Timeout=30";
SqlConnection bag = new SqlConnection(connection);
try
{
bag.Open();
string komut = @"SELECT * FROM otelbilgi";
cmd = new SqlCommand(komut, bag);
dr = cmd.ExecuteReader();
while (dr.Read())
{
aramaAgaci = new IkiliAramaAgaci();
Otel ot = new Otel();
ot.Ad = dr["otelismi"].ToString();
aramaAgaci.IsmeGoreOtelEkle(ot);
}
}
catch (Exception hata)
{
MessageBox.Show(hata.Message);
}
}
