🙂 İNSANLARIN EN HAYIRLISI INSANLARA FAYDALI OLANDIR 🙂

Ramazan HABER / C# RMOS / master detail gridview master detail gridcontrol

1-) C# RMOS - master detail gridview master detail gridcontrol

 

 

 GridOptionsView.ShowGroupPanel true yap otomatik olur aşağıdakine grek yok

 

 

 

DİĞER

 

 

using System;

using System.Data;

using System.Windows.Forms;

 

namespace masterDetail

{

    public partial class Form1 : Form

    {

        public Form1()

        {

            InitializeComponent();

        }

 

        private void simpleButton1_Click(object sender, EventArgs e)

        {

            DataTable dt1 = getDt1(); // 1,2,3,4

            DataTable dt2 = getDt2(); // 1,1,2,2

 

 

            gridControl_master.DataSource = dt1;

            gridControl_detail.DataSource = dt2;

 

            dt1.TableName = "dt1";

            dt2.TableName = "dt2";

 

            DataSet dataSet = new DataSet();

            dataSet.Tables.Add(dt1);

            dataSet.Tables.Add(dt2);

           // dataSet.Relations.Add(dataSet.Tables[0].Columns["id"], dataSet.Tables[1].Columns["master_id"]);

       dataSet.Relations.Add(dataSet.Tables["dt1"].Columns["id"], dataSet.Tables["dt2"].Columns["master_id"]);

  dataSet.Relations[0].RelationName = "ogrenci";

 

           gridControl_masterDetail.DataSource = dataSet.Tables["dt1"];

        }

 

        public DataTable getDt1() // master

        {

            DataTable dt = new DataTable();

            dt.Columns.Add("id", typeof(int));

            dt.Columns.Add("ad");

            dt.Columns.Add("soyad");

 

            DataRow dr = dt.NewRow();

            dr["id"] = 1;

            dr["ad"] = "ramazan1";

            dr["soyad"] = "haber11";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 2;

            dr["ad"] = "ramazan2";

            dr["soyad"] = "haber2";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 3;

            dr["ad"] = "ramazan3";

            dr["soyad"] = "haber3";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 4;

            dr["ad"] = "ramazan4";

            dr["soyad"] = "haber4";

            dt.Rows.Add(dr);

 

 

            return dt;

        }

 

        public DataTable getDt2() // detail

        {

            DataTable dt = new DataTable();

            dt.Columns.Add("id", typeof(int)); //

            dt.Columns.Add("master_id", typeof(int)); //

            dt.Columns.Add("ad");

            dt.Columns.Add("il");

 

            DataRow dr = dt.NewRow();

            dr["id"] = 1;

            dr["master_id"] = 1;

            dr["ad"] = "ramazan1";

            dr["il"] = "antalya1";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 2;

            dr["master_id"] = 1;

            dr["ad"] = "ramazan2";

            dr["il"] = "antalya2";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 3;

            dr["master_id"] = 2;

            dr["ad"] = "ramazan3";

            dr["il"] = "antalya3";

            dt.Rows.Add(dr);

 

            dr = dt.NewRow();

            dr["id"] = 4;

            dr["master_id"] = 2;

            dr["ad"] = "ramazan4";

            dr["il"] = "antalya4";

            dt.Rows.Add(dr);

 

 

            return dt;

        }

 

       

    }

}

 

 2023 Ocak 04 Çarşamba
 469