combobox’dan seçileni datagridview’da listelemek

 

 

 

 

 

 

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.OleDb;

 

namespace WindowsFormsApplication1

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        OleDbConnection Conn;

        OleDbCommand sorgu;

        OleDbDataReader veri;

        OleDbDataAdapter adaptor;

        DataSet ds;

 

        private void Form1_Load(object sender, EventArgs e)

        {

            Conn = new OleDbConnection();

            Conn.ConnectionString = “Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\subeler_db.accdb”;

            Conn.Open();

            sorgu = new OleDbCommand();

            sorgu.Connection = Conn;

            sorgu.CommandText = “select * from tbl_subeler”;

            veri = sorgu.ExecuteReader();

            while (veri.Read())

            {

                comboBox1.Items.Add(veri[1]);

            }

            comboBox1.SelectedIndex = 1;

            adaptor = new OleDbDataAdapter(“select * from tbl_subeler where sube_kodu='” + comboBox1.SelectedItem + “‘”, Conn);

            ds = new DataSet();

            ds.Clear();

            adaptor.Fill(ds, “tbl_subeler”);

            grid1.DataSource = ds.Tables[“tbl_subeler”];

            grid1.Refresh();

            adaptor.Dispose();

        }

 

        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

        {

            adaptor = new OleDbDataAdapter(“select * from tbl_subeler where sube_kodu='” + comboBox1.SelectedItem + “‘”, Conn);

            ds = new DataSet();

            ds.Clear();

            adaptor.Fill(ds, “tbl_subeler”);

            grid1.DataSource = ds.Tables[“tbl_subeler”];

            grid1.Refresh();

            adaptor.Dispose();

        }

    }

}