Вид для Базы

[SIZE=2][COLOR=#008080]DataSet[/COLOR][/SIZE][SIZE=2] dataSet = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#008080]DataSet[/COLOR][/SIZE][SIZE=2]();
[/SIZE][SIZE=2][COLOR=#008000]//......добавляем в dataSet нужные нам таблицы, можно через DataAdapter.Fill(DataSet, String);
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2] Actors = dataSet.Tables[[/SIZE][SIZE=2][COLOR=#800000]"Actors"[/COLOR][/SIZE][SIZE=2]]; [/SIZE][SIZE=2][COLOR=#008000]//id_actor, name
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2] Roles = dataSet.Tables[[/SIZE][SIZE=2][COLOR=#800000]"Roles"[/COLOR][/SIZE][SIZE=2]]; [/SIZE][SIZE=2][COLOR=#008000]//id_role, name
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2] WhereWhen = dataSet.Tables[[/SIZE][SIZE=2][COLOR=#800000]"WhereWhen"[/COLOR][/SIZE][SIZE=2]]; [/SIZE][SIZE=2][COLOR=#008000]//id_wherewhen, where, when
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2] Common = dataSet.Tables[[/SIZE][SIZE=2][COLOR=#800000]"Common"[/COLOR][/SIZE][SIZE=2]]; [/SIZE][SIZE=2][COLOR=#008000]//id_role, id_actor, id_wherewhen
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2] Result = [/SIZE][SIZE=2][COLOR=#0000ff]new[/COLOR][/SIZE][SIZE=2] [/SIZE][SIZE=2][COLOR=#008080]DataTable[/COLOR][/SIZE][SIZE=2]([/SIZE][SIZE=2][COLOR=#800000]"Result"[/COLOR][/SIZE][SIZE=2]);
[/SIZE][SIZE=2][COLOR=#0000ff]foreach[/COLOR][/SIZE][SIZE=2] ([/SIZE][SIZE=2][COLOR=#008080]DataRow[/COLOR][/SIZE][SIZE=2] commonRow [/SIZE][SIZE=2][COLOR=#0000ff]in[/COLOR][/SIZE][SIZE=2] Common.Rows)
{
[/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2] actorId = ([/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2])commonRow.ItemArray[0]; [/SIZE][SIZE=2][COLOR=#008000]//читаем id_actor
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2] roleId = ([/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2])commonRow.ItemArray[1]; [/SIZE][SIZE=2][COLOR=#008000]//читаем id_role
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2] wherewhenId = ([/SIZE][SIZE=2][COLOR=#0000ff]string[/COLOR][/SIZE][SIZE=2])commonRow.ItemArray[2]; [/SIZE][SIZE=2][COLOR=#008000]//читаем id_wherewhen
[/COLOR][/SIZE][SIZE=2][/SIZE][SIZE=2][COLOR=#008080]DataRow[/COLOR][/SIZE][SIZE=2][] actorRows = Actors.Select([/SIZE][SIZE=2][COLOR=#008080]String[/COLOR][/SIZE][SIZE=2].Format([/SIZE][SIZE=2][COLOR=#800000]"id_actor={0}"[/COLOR][/SIZE][SIZE=2], actorId)), [/SIZE][SIZE=2][COLOR=#008000]//выбраем записи из таблицы Actors, которые удовлетворяют текущему id_actor. Эта запись одна или вообще нет, т.к. она ключевая
[/COLOR][/SIZE][SIZE=2]roleRows = Roles.Select([/SIZE][SIZE=2][COLOR=#008080]String[/COLOR][/SIZE][SIZE=2].Format([/SIZE][SIZE=2][COLOR=#800000]"id_role={0}"[/COLOR][/SIZE][SIZE=2], roleId)),
whenwhereRows = WhereWhen.Select([/SIZE][SIZE=2][COLOR=#008080]String[/COLOR][/SIZE][SIZE=2].Format([/SIZE][SIZE=2][COLOR=#800000]"id_wherewhen={0}"[/COLOR][/SIZE][SIZE=2], wherewhenId));
Result.Rows.Add(actorRows[0].ItemArray[1], roleRows[0].ItemArray[1], whenwhereRows[0].ItemArray[1]); [/SIZE][SIZE=2][COLOR=#008000]//Добавляем новые ячейки в результирующу таблицу
[/COLOR][/SIZE][SIZE=2]}
[/SIZE]