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;
}
}
}