Veri tabanı kullanarak Combobox1’te seçilen şehire göre ilçeleri Combobox2’ye Atmak — Csharp
[code lang=”csharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;//www.gorselprogramlama.com
using System.Windows.Forms;
using System.Data.OleDb;
namespace il_gore_ilce
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Ace.Oledb.12.0;Data Source=data.accdb");
OleDbCommand kmt = new OleDbCommand();
DataTable tablo = new DataTable();//www.gorselprogramlama.com
OleDbDataAdapter adtr = new OleDbDataAdapter();
void ilEkle()
{
DataTable dt = new DataTable();
adtr = new OleDbDataAdapter("select * from iller ", bag);
adtr.Fill(dt);
comboBox1.ValueMember = "id";
comboBox1.DisplayMember = "ilAdi";
comboBox1.DataSource = dt;//www.gorselprogramlama.com
}
private void Form1_Load(object sender, EventArgs e)
{
ilEkle();
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText="select ilceAdi From ilceler Where ilid=" + comboBox1.SelectedValue;
OleDbDataReader oku;
oku = kmt.ExecuteReader();//www.gorselprogramlama.com
comboBox2.Items.Clear();
while (oku.Read())
{
comboBox2.Items.Add(oku[0].ToString());
}
bag.Close();
}//www.gorselprogramlama.com
}
}
[/code]
