üç farklı Datagridview İlk datagridview ıdsıne tıklayınca diğer iki datagridview o Id göre bilgi getirme

 private void Form1_Load(object sender, EventArgs e)
        {
            SqlDataAdapter adapter=new SqlDataAdapter("Select ID from OKUL",bag);
            DataSet ds=new DataSet();
            adapter.Fill(ds);
            dataGridView1.DataSource=ds.Tables[0];
        }
        int ID;
        private void dataGridView1_DoubleClick(object sender, EventArgs e)
        {
            SqlDataAdapter adapter=new SqlDataAdapter("Select AdSoyad,Memleket from OKUL where ID='"+ dataGridView1.SelectedCells[0].Value.ToString()+"'",bag);
            DataSet ds=new DataSet();
            adapter.Fill(ds);
            dataGridView2.DataSource=ds.Tables[0];

            SqlDataAdapter adapter2= new SqlDataAdapter("Select OKUL,DERS from OKUL where ID='" + dataGridView1.SelectedCells[0].Value.ToString() + "'", bag);
            DataSet ds2 = new DataSet();
            adapter2.Fill(ds2);
            dataGridView3.DataSource = ds2.Tables[0];
           
        }

Yorumlar

Daha yeni Daha eski