İlçe Bilgilendirme Sistemi – Veri tabanına il ve ilçe ve bilgilerini ekleyerek görüntüleme — C#
Form1
[code lang=”csharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;//www.gorselprogramlama.com
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb; // oledb sınfıı
namespace Veri_Tabanına_İl_ve_ilce_ekleyip_veri_cekmek
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
public OleDbConnection connect = new OleDbConnection("Provider=Microsoft.ACE.OleDb.12.0;Data Source=iller.accdb");
public void baglantiKur()
{
if (connect.State == ConnectionState.Closed)
{
connect.Open();//www.gorselprogramlama.com
}
}
void Listele()
{
baglantiKur();
string sorgu = "SELECT * FROM il_ilceler";
OleDbDataAdapter adp = new OleDbDataAdapter(sorgu, connect);
DataTable dt = new DataTable();
adp.Fill(dt);
dataGridView1.DataSource = dt;
connect.Close();//www.gorselprogramlama.com
}
void bilgiEkle()
{
baglantiKur();
string sorgu = "INSERT INTO il_ilceler(il_Adi,ilce_Adi,ilce_Bilgi) VALUES(‘" + cb_iller.Text +"’,’" + txt_ilceler.Text + "’,’" + txtIlceBilgisi.Text + "’)";
OleDbCommand cmd = new OleDbCommand(sorgu,connect);
cmd.ExecuteNonQuery();
connect.Close();
}
public void il_cek(ComboBox cmb)
{
baglantiKur();//www.gorselprogramlama.com
cmb.Items.Clear();
string sorgu = "SELECT DISTINCT il_Adi FROM il_ilceler";
OleDbCommand cmd = new OleDbCommand(sorgu, connect);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
while (oku.Read())
{
cmb.Items.Add(oku[0]);
}
connect.Close();
}//www.gorselprogramlama.com
private void btnFrm2_Click(object sender, EventArgs e)
{
Form2 frm2 = new Form2();
frm2.Show();
}
private void btnEkle_Click(object sender, EventArgs e)
{
bilgiEkle();
Listele();
il_cek(cb_iller);
cb_iller.Text = "";
txt_ilceler.Text = "";
txtIlceBilgisi.Text = "";//www.gorselprogramlama.com
}
private void Form1_Load(object sender, EventArgs e)
{
il_cek(cb_iller);
Listele();
}
}
}
[/code]
Form2
[code lang=”csharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;//www.gorselprogramlama.com
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;
namespace Veri_Tabanına_İl_ve_ilce_ekleyip_veri_cekmek
{
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
Form1 frm1 = new Form1();
private void Form2_Load(object sender, EventArgs e)
{
frm1.il_cek(cb_iller);//www.gorselprogramlama.com
}
private void cb_iller_SelectedIndexChanged(object sender, EventArgs e)
{
ilce_cek();
}
void ilce_cek()
{
frm1.baglantiKur();
cb_ilceler.Items.Clear();
string sorgu = "SELECT DISTINCT * FROM il_ilceler WHERE il_Adi=’" + cb_iller.Text + "’";
OleDbCommand cmd = new OleDbCommand(sorgu, frm1.connect);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
while (oku.Read())
{
cb_ilceler.Items.Add(oku[2]);
}
frm1.Close();//www.gorselprogramlama.com
}
private void btnGoster_Click(object sender, EventArgs e)
{
frm1.baglantiKur();
string sorgu = "SELECT * FROM il_ilceler WHERE il_Adi=’" + cb_iller.Text + "’ AND ilce_Adi=’" + cb_ilceler.Text + "’" ;
OleDbCommand cmd = new OleDbCommand(sorgu, frm1.connect);
OleDbDataReader oku;
oku = cmd.ExecuteReader();
while (oku.Read())//www.gorselprogramlama.com
{
txt_ilceBilgisi.Text = oku[3].ToString();
}
frm1.Close();
}
}
}
[/code]
