1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41
|
DataTable dt1 = new DataTable("Carac");
dt1.Columns.Add("CaracId", typeof(int));
dt1.Columns.Add("CaracNom", typeof(string));
DataTable dt2 = new DataTable("Value");
dt2.Columns.Add("ValueId", typeof(int));
dt2.Columns.Add("CaracId", typeof(int));
dt2.Columns.Add("ValueValeur", typeof(string));
DataSet ds = new DataSet();
ds.Tables.AddRange(new DataTable[] { dt1, dt2 });
ds.Relations.Add("Carac.Value", ds.Tables["Carac"].Columns["CaracId"],
ds.Tables["Value"].Columns["CaracId"]);
ds.Tables["Carac"].Rows.Add(new object[] { 0, "c0" });
ds.Tables["Carac"].Rows.Add(new object[] { 1, "c1" });
ds.Tables["Carac"].Rows.Add(new object[] { 2, "c2" });
ds.Tables["Value"].Rows.Add(new object[] { 0, 0, "c0v0" });
ds.Tables["Value"].Rows.Add(new object[] { 1, 0, "c0v1" });
ds.Tables["Value"].Rows.Add(new object[] { 2, 1, "c1v0" });
ds.Tables["Value"].Rows.Add(new object[] { 3, 1, "c1v1" });
ds.Tables["Value"].Rows.Add(new object[] { 4, 1, "c1v2" });
ds.Tables["Value"].Rows.Add(new object[] { 5, 0, "c0v2" });
ds.Tables["Value"].Rows.Add(new object[] { 6, 2, "c2v0" });
this.InitializeComponent();
BindingSource sourcecarac = new BindingSource();
sourcecarac.DataSource = ds;
sourcecarac.DataMember = "Carac";
BindingSource sourcevalue = new BindingSource();
sourcevalue.DataSource = sourcecarac;
sourcevalue.DataMember = "Carac.Value";
ColCarac.DataSource = sourcecarac;
ColCarac.DisplayMember = "CaracNom";
ColCarac.ValueMember = "CaracId";
ColValue.DataSource = sourcevalue;
ColValue.DisplayMember = "ValueValeur";
ColValue.ValueMember = "ValueId"; |
Partager