Hi Oliver,
zu Deiner Ausgangsfrage hatte ich Dir schon geantwortet. Hier mal eine Konsolendemo zur Verdeutlichung:
using System;
using System.Data;
namespace ConsoleApp1
{
class Program21
{
static void Main(string[] args)
{
try
{
Demo c = new Demo();
c.Execute();
}
catch (Exception ex) { Console.WriteLine(ex.ToString()); }
Console.WriteLine("Fertig, Abschluss mit beliebiger Taste");
Console.ReadKey();
}
/// <summary>
/// Klasse, die das arbeitende Programm simuliert
/// </summary>
internal class Demo
{
internal void Execute()
{
/// Master-Tabelle
DataSet t1 = new DataSet();
DataTable dtSide = new DataTable("Master");
DataTable dtSerials = new DataTable("Child");
t1.Tables.AddRange(new DataTable[] { dtSide, dtSerials });
DataColumn col11 = dtSide.Columns.Add("Id", typeof(int));
col11.AutoIncrement = true;
col11.AutoIncrementSeed = -1;
col11.AutoIncrementStep = -1;
dtSide.Columns.Add("Number", typeof(string));
// Child-Tabelle
DataColumn col21 = dtSerials.Columns.Add("Id", typeof(int));
col21.AutoIncrement = true;
col21.AutoIncrementSeed = -1;
col21.AutoIncrementStep = -1;
DataColumn col22 = dtSerials.Columns.Add("IdSide", typeof(int));
dtSerials.Columns.Add("Position", typeof(string));
// Beziehung
ForeignKeyConstraint fkc = new ForeignKeyConstraint("FKc", col11, col22) { DeleteRule = Rule.Cascade };
dtSerials.Constraints.Add(fkc);
t1.Relations.Add("rel1", col11, col22);
// BindingSources
System.Windows.Forms.BindingSource bsMaster = new System.Windows.Forms.BindingSource(t1, "Master");
System.Windows.Forms.BindingSource bsChild = new System.Windows.Forms.BindingSource(bsMaster, "rel1");
// Master-Datensätze
for (int i = 1; i <= 10; i++)
{
DataRowView drv = bsMaster.AddNew() as DataRowView;
drv["Number"] = $"Master {i}";
}
// Child-Datensätze
Random rnd = new Random(); // Für zufälligen Master-Datensatz
for (int i = 0; i < 100; i++)
{
bsMaster.Position = rnd.Next(0, bsMaster.Count);
DataRowView drv = bsChild.AddNew() as DataRowView;
drv.BeginEdit();
drv["Position"] = $"Child {i + 1}";
drv.EndEdit();
}
// Testanzeige
foreach (DataRow row1 in dtSide.Rows)
{
Console.WriteLine($"{row1[0]} {row1[1]}");
foreach (DataRow row2 in row1.GetChildRows("rel1"))
Console.WriteLine($" {row2[0]} {row2[1]} {row2[2]}");
}
}
}
}
}
--
Viele Grüsse
Peter Fleischer (ehem. MVP)
Meine Homepage mit Tipps und Tricks
