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); } }