当前位置： 文江博客话题详情

XAML 绑定到 Sql Server

发布于 2024-12-06 05:52:59 字数 7384 浏览 0 评论 0原文

我有一个包含以下表和关系的 SQL Server 数据库：

包含许多会话的作业。 包含许多休息的会议。

首先，不要被这里发布的大量代码吓到。相关部分是处理列表的突出显示部分，其余部分只是为了进行比较，看看我哪里出错了。

在 XAML 中，我在绑定作业时尝试并取得了成功。我让它过滤掉正确的会话。那里没问题。

我的问题是，当我尝试让它过滤属于每个会话的中断时，它不会工作，但我使用所有相同的原则。

我没有使用（也没有兴趣使用）Linq2Sql，因为它创建了太多额外的类，使我的代码变得臃肿。我只是使用直接数据绑定。

我之前曾问过这个问题并发布了代码，但我从未得到任何回复，因为代码太长，无法在合理的时间内阅读。

我的问题是，我做错了什么。我的印象是，既然我可以成功绑定和过滤会话，那么我应该能够对会话和过滤器中断进行同样的操作。但这不起作用。

我有点渴望帮助并感谢任何答案。

编辑：我再次包含了代码示例。我并不是为了保密和版权而试图隐藏代码。这只是我正在做的学习练习，所以我不介意发布完整的代码。但它很长。所以我只会发布我认为相关的部分。如果您想要更多，请询问。

对于那些有兴趣跳到问题所在的好部分的人，请查看“中断”列表框的部分。其余的只是为了比较以帮助您调试。下面还有 C# 代码可以提供进一步帮助。再次查看列表部分，其余部分仅用于调试。

下面是相关的 XAML，

<!--Jobs List box - Works fine-->
<ListBox Name="lstJobs"  DockPanel.Dock="Top"
        MinWidth="150" MinHeight="200" MaxHeight="250"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstJobs_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Tables[JobDetails]}"
        ItemsSource="{Binding}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}"/>
                    <TextBlock Text=" "/>
                    <TextBlock Text="{Binding Path=ID}"/>
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Jobs listbox is bound to relevant fields in jobs table. This works fine-->
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Name="txtJobNo"          Grid.Row="1"                 IsEnabled="False"/>
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Name="txtJobTitle"       Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.Description,   UpdateSourceTrigger=PropertyChanged}" Name="txtJobDesc"        Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>


<!--Sessions List box, Automatically filtered based on relationship (see last binding line). This works fine too-->
<ListBox Name="lstSessions" DockPanel.Dock="Top" MinWidth="150"
        MinHeight="200" MaxHeight="220"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstSessions_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Path=Tables[JobDetails]}"
        ItemsSource="{Binding Path=relJobDetailsSessionDetails}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}" />
                    <TextBlock Text="{Binding Path=ID}" />
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Sessions listbox is bound to relevant fields in Sessions table. This works fine-->
<TextBox Name="txtSessionNo"          Text="{Binding ElementName=lstSessions, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="0"/>
<TextBox Name="txtSessionTitle"       Text="{Binding ElementName=lstSessions, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="3"/>
<TextBox Name="txtSessionDesc"        Text="{Binding ElementName=lstSessions, Path=SelectedItem.Description,   UpdateSourceTrigger=PropertyChanged}" Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>


<!--Breaks List box, Should be automatically filtered (it is), but it does not change when a job or session is selected. Why?? -->
<ListBox Name="lstBreaks" MinWidth="150" MinHeight="140" MaxHeight="140"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstBreaks_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Path=Tables[SessionDetails]}"
        ItemsSource="{Binding Path=relSessionDetailsBreakDetails}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}" />
                    <TextBlock Text="{Binding Path=ID}" />
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Breaks listbox is bound to relevant fields in Breaks table. This works fine as before-->
<TextBox Name="txtBreakNo"          Text="{Binding ElementName=lstBreaks, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="0"/>
<TextBox Name="txtBreakTitle"       Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
<ComboBox Name="cbxBreakType"       Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Description,     UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="3"/>

下面是后面的 C# 代码（再次强调，突出显示的部分是中断，其余部分只是为了比较，因此如果您愿意，可以直接跳到此部分）：

//Connection String
string conString = "XYZ Works ok, no prob here";

//Data Adaptors for various tables
SqlDataAdapter daJobDetails = new SqlDataAdapter();
SqlDataAdapter daSessionDetails = new SqlDataAdapter();
SqlDataAdapter daBreakDetails = new SqlDataAdapter();

//The dataset to hold all of the data
DataSet dsDataSet = new DataSet();

//Step 1: Create Connection
SqlConnection conn = new SqlConnection(conString);

//Open Connection
conn.Open();


//Load Job Details Table - works fine.
daJobDetails.SelectCommand = new SqlCommand("Select * From JobDetails", conn);
daJobDetails.Fill(dsDataSet, "JobDetails");

//Load Session Details table - works fine.
daSessionDetails.SelectCommand = new SqlCommand("SELECT * FROM SessionDetails", conn);
daSessionDetails.Fill(dsDataSet, "SessionDetails");

//Relation: JobDetails.ID = SessionDetails.JobID. - Works fine
dsDataSet.Relations.Add("relJobDetailsSessionDetails",
    dsDataSet.Tables["JobDetails"].Columns["ID"],
    dsDataSet.Tables["SessionDetails"].Columns["JobID"]);


//**** Possible problem code *****
//Load Break Details table - could there be something wrong here.
daBreakDetails.SelectCommand = new SqlCommand("SELECT * FROM BreakDetails", conn);
daBreakDetails.Fill(dsDataSet, "BreakDetails");

//**** Possible problem code *****
//Relation: SessionDetails.ID = BreakDetails.SessionID - Could there be something wrong here
dsDataSet.Relations.Add("relSessionDetailsBreakDetails",
    dsDataSet.Tables["SessionDetails"].Columns["ID"],
    dsDataSet.Tables["BreakDetails"].Columns["SessionID"]);



//Set the DataContext to the DataSet
expJobs.DataContext = dsDataSet;


//Close connection
conn.Close();
原文

I have a SQL Server DB with the following tables and relationships:

Jobs which contains many sessions.
Sessions which contains many breaks.

First of all, dont be frightened by the large amount of code posted here. The relevant parts are the highlighted parts dealing with the list, the rest is just for comparison to see where I am going wrong.

In XAML I am trying and succeeding when binding jobs. I get it to filter out the correct sessions. No problem there.

My problem is that when I try to get it to filter the breaks that belong to each session it wont work but I am using all the same principles.

I am not using (nor interested in using) Linq2Sql as it creates too many additional classes that bloat my code. I am just using direct databinding.

I have asked this question before and posted code, but I never got any reply because the code was simply too long to read in a reasonable timeframe.

My question here is, what am I doing wrong. I was with the impression that since I can successfully bind and filter sessions, then I should be able to do likewise with sessions and filter breaks. But it doesnt work.

I am getting somewhat desparate for help and appreicate any answers.

EDIT: Once again I have included code samples. I am not trying to hide the code for secrecy and copyright. It is just an exercise I am doing to learn so I wouldnt mind posting the full code. But it is very long. So I will just post the parts I think are relevant. If you want more just ask.

For those of you interested in skipping to the good part where the problems are, look under the part of the Breaks list box. The rest is just there for comparison to help you debug. There is also C# code below to help further. Again, look at the list part the rest is just for debugging.

Below is the relevant XAML

<!--Jobs List box - Works fine-->
<ListBox Name="lstJobs"  DockPanel.Dock="Top"
        MinWidth="150" MinHeight="200" MaxHeight="250"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstJobs_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Tables[JobDetails]}"
        ItemsSource="{Binding}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}"/>
                    <TextBlock Text=" "/>
                    <TextBlock Text="{Binding Path=ID}"/>
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Jobs listbox is bound to relevant fields in jobs table. This works fine-->
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Name="txtJobNo"          Grid.Row="1"                 IsEnabled="False"/>
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Name="txtJobTitle"       Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
<TextBox    Text="{Binding        ElementName=lstJobs, Path=SelectedItem.Description,   UpdateSourceTrigger=PropertyChanged}" Name="txtJobDesc"        Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>


<!--Sessions List box, Automatically filtered based on relationship (see last binding line). This works fine too-->
<ListBox Name="lstSessions" DockPanel.Dock="Top" MinWidth="150"
        MinHeight="200" MaxHeight="220"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstSessions_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Path=Tables[JobDetails]}"
        ItemsSource="{Binding Path=relJobDetailsSessionDetails}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}" />
                    <TextBlock Text="{Binding Path=ID}" />
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Sessions listbox is bound to relevant fields in Sessions table. This works fine-->
<TextBox Name="txtSessionNo"          Text="{Binding ElementName=lstSessions, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="0"/>
<TextBox Name="txtSessionTitle"       Text="{Binding ElementName=lstSessions, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="3"/>
<TextBox Name="txtSessionDesc"        Text="{Binding ElementName=lstSessions, Path=SelectedItem.Description,   UpdateSourceTrigger=PropertyChanged}" Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>


<!--Breaks List box, Should be automatically filtered (it is), but it does not change when a job or session is selected. Why?? -->
<ListBox Name="lstBreaks" MinWidth="150" MinHeight="140" MaxHeight="140"
        ScrollViewer.VerticalScrollBarVisibility="Visible"
        SelectionChanged="lstBreaks_SelectionChanged"

        IsSynchronizedWithCurrentItem="True"
        DataContext="{Binding Path=Tables[SessionDetails]}"
        ItemsSource="{Binding Path=relSessionDetailsBreakDetails}"
        >
    <ListBox.ItemTemplate>
        <DataTemplate>
            <Grid>
                <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                    <TextBlock Text="{Binding Path=Title}" />
                    <TextBlock Text="{Binding Path=ID}" />
                </StackPanel>
            </Grid>
        </DataTemplate>
    </ListBox.ItemTemplate>
</ListBox>

<!--How Breaks listbox is bound to relevant fields in Breaks table. This works fine as before-->
<TextBox Name="txtBreakNo"          Text="{Binding ElementName=lstBreaks, Path=SelectedItem.ID,            UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="0"/>
<TextBox Name="txtBreakTitle"       Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Title,         UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
<ComboBox Name="cbxBreakType"       Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Description,     UpdateSourceTrigger=PropertyChanged}" Grid.Row="1" Grid.Column="3"/>

Following is the C# Code behind (Once again, the highlighted part is the breaks and the rest is just for comparison, so you can skip directly to that if you like):

//Connection String
string conString = "XYZ Works ok, no prob here";

//Data Adaptors for various tables
SqlDataAdapter daJobDetails = new SqlDataAdapter();
SqlDataAdapter daSessionDetails = new SqlDataAdapter();
SqlDataAdapter daBreakDetails = new SqlDataAdapter();

//The dataset to hold all of the data
DataSet dsDataSet = new DataSet();

//Step 1: Create Connection
SqlConnection conn = new SqlConnection(conString);

//Open Connection
conn.Open();


//Load Job Details Table - works fine.
daJobDetails.SelectCommand = new SqlCommand("Select * From JobDetails", conn);
daJobDetails.Fill(dsDataSet, "JobDetails");

//Load Session Details table - works fine.
daSessionDetails.SelectCommand = new SqlCommand("SELECT * FROM SessionDetails", conn);
daSessionDetails.Fill(dsDataSet, "SessionDetails");

//Relation: JobDetails.ID = SessionDetails.JobID. - Works fine
dsDataSet.Relations.Add("relJobDetailsSessionDetails",
    dsDataSet.Tables["JobDetails"].Columns["ID"],
    dsDataSet.Tables["SessionDetails"].Columns["JobID"]);


//**** Possible problem code *****
//Load Break Details table - could there be something wrong here.
daBreakDetails.SelectCommand = new SqlCommand("SELECT * FROM BreakDetails", conn);
daBreakDetails.Fill(dsDataSet, "BreakDetails");

//**** Possible problem code *****
//Relation: SessionDetails.ID = BreakDetails.SessionID - Could there be something wrong here
dsDataSet.Relations.Add("relSessionDetailsBreakDetails",
    dsDataSet.Tables["SessionDetails"].Columns["ID"],
    dsDataSet.Tables["BreakDetails"].Columns["SessionID"]);



//Set the DataContext to the DataSet
expJobs.DataContext = dsDataSet;


//Close connection
conn.Close();

如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论， 你可以免费 注册 一个本站的账号。

评论（1）

别再吹冷风 2024-12-13 05:52:59

根据要求，这是一个完整的重现案例。

更新：使用链接中的工作代码进行更新。看起来答案绑定到 SelectedItem =>关系。实际上，非常符合逻辑。

XAML：

<Window x:Class="WpfApplication2.MainWindow" 
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" 
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
    Title="MainWindow" Height="350" Width="525">

    <Grid>
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width=".5*"/>
            <ColumnDefinition Width=".5*"/>
        </Grid.ColumnDefinitions>
        <Grid.RowDefinitions>
            <RowDefinition Height=".33*"/>
            <RowDefinition Height=".33*"/>
            <RowDefinition Height=".33*"/>
        </Grid.RowDefinitions>
        <!--Jobs List box - Works fine-->
        <ListBox Name="lstJobs" Grid.Column="0" Grid.Row="0" 
             MinWidth="150"  
             MinHeight="200"  
             MaxHeight="250"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstJobs_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding Path=JobDetails}"                      
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=ID}"/>
                            <TextBlock Text="{Binding Path=Title}"/>
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>
        <!--How Jobs listbox is bound to relevant fields in jobs table. This works fine-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="0">
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.ID, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobNo" Grid.Row="1" IsEnabled="False"/>
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobTitle" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobDesc" Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>
        </StackPanel>

        <!--Sessions List box, Automatically filtered based on relationship (see last binding line). This works fine too -->
        <ListBox Name="lstSessions" Grid.Column="0" Grid.Row="1" 
             DockPanel.Dock="Top"  
             MinWidth="150"          
             MinHeight="200"  
             MaxHeight="220"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstSessions_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding ElementName=lstJobs, Path=SelectedItem.relJobDetailsSessionDetails}" 
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=Title}" />
                            <TextBlock Text="{Binding Path=ID}" />
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>


        <!--How Sessions listbox is bound to relevant fields in Sessions table. This works fine-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="1">
            <TextBox Name="txtSessionNo" Text="{Binding ElementName=lstSessions, Path=SelectedItem.ID,  UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="1" Grid.Column="0"/>
            <TextBox Name="txtSessionTitle" Text="{Binding ElementName=lstSessions, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="3"/>
            <TextBox Name="txtSessionDesc" Text="{Binding ElementName=lstSessions, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>
        </StackPanel>

        <!--Breaks List box, Should be automatically filtered (it is), but it does not change when a job or session is selected. Why?? -->
        <ListBox Name="lstBreaks" Grid.Column="0" Grid.Row="2" 
             MinWidth="150"  
             MinHeight="140"  
             MaxHeight="140"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstBreaks_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding ElementName=lstSessions, Path=SelectedItem.relSessionDetailsBreakDetails}"          
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=Title}" />
                            <TextBlock Text="{Binding Path=ID}" />
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>
        <!--How Breaks listbox is bound to relevant fields in Breaks table. This works fine as before-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="2">
            <TextBox Name="txtBreakNo" DockPanel.Dock="Bottom"  
             Text="{Binding ElementName=lstBreaks, Path=SelectedItem.ID, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="1"/>
            <TextBox Name="txtBreakTitle" DockPanel.Dock="Bottom" 
             Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="2"/>
            <ComboBox Name="cbxBreakType" DockPanel.Dock="Bottom" 
              Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
              Grid.Row="2" Grid.Column="3"/>
        </StackPanel>

    </Grid>


</Window>

隐藏代码：

using System;
using System.Data;
using System.Windows;
using System.Windows.Controls;

namespace WpfApplication2
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            CreateData();
            this.DataContext = Data;
        }


    public DataSet Data { get; set; }

    private void CreateData()
    {
        Data = new DataSet();
        Data.Tables.Add(CreateJobTable());
        Data.Tables.Add(CreateSessionsTable());
        Data.Tables.Add(CreateBreaks());

        DataRelation relation = GetJobSessionRelations();
        DataRelation relation2 = GetSessionBreakRelations();

        Data.Relations.AddRange(new[] {relation, relation2});
    }

    private DataTable CreateJobTable()
    {
        var jobs = new DataTable();
        jobs.TableName = "JobDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");

        jobs.Columns.Add(col1);
        jobs.Columns.Add(col2);
        jobs.Columns.Add(col3);

        DataRow row = jobs.NewRow();
        row["ID"] = 1;
        row["Title"] = "Job 1";
        row["Description"] = "Job Desc 1";
        jobs.Rows.Add(row);

        DataRow row2 = jobs.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Job 2";
        row2["Description"] = "Job Desc 2";
        jobs.Rows.Add(row2);

        return jobs;
    }

    private DataTable CreateSessionsTable()
    {
        var sessions = new DataTable();
        sessions.TableName = "SessionDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");
        var col4 = new DataColumn("JobID");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");
        col4.DataType = Type.GetType("System.Int32");

        sessions.Columns.Add(col1);
        sessions.Columns.Add(col2);
        sessions.Columns.Add(col3);
        sessions.Columns.Add(col4);

        DataRow row = sessions.NewRow();
        row["ID"] = 1;
        row["Title"] = "Session 1";
        row["Description"] = "Session Desc 1";
        row["JobID"] = 1;
        sessions.Rows.Add(row);

        DataRow row2 = sessions.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Session 2";
        row2["Description"] = "Session Desc 2";
        row2["JobID"] = 1;
        sessions.Rows.Add(row2);

        DataRow row3 = sessions.NewRow();
        row3["ID"] = 3;
        row3["Title"] = "Session 3";
        row3["Description"] = "Session Desc 3";
        row3["JobID"] = 2;
        sessions.Rows.Add(row3);

        DataRow row4 = sessions.NewRow();
        row4["ID"] = 4;
        row4["Title"] = "Session 4";
        row4["Description"] = "Session Desc 4";
        row4["JobID"] = 2;
        sessions.Rows.Add(row4);

        return sessions;
    }

    private DataTable CreateBreaks()
    {
        var breaks = new DataTable();
        breaks.TableName = "BreakDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");
        var col4 = new DataColumn("SessionID");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");
        col4.DataType = Type.GetType("System.Int32");

        breaks.Columns.Add(col1);
        breaks.Columns.Add(col2);
        breaks.Columns.Add(col3);
        breaks.Columns.Add(col4);

        DataRow row = breaks.NewRow();
        row["ID"] = 1;
        row["Title"] = "Break 1";
        row["Description"] = "Break Desc 1";
        row["SessionID"] = 1;
        breaks.Rows.Add(row);

        DataRow row2 = breaks.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Break 2";
        row2["Description"] = "Break Desc 2";
        row2["SessionID"] = 2;
        breaks.Rows.Add(row2);

        DataRow row3 = breaks.NewRow();
        row3["ID"] = 3;
        row3["Title"] = "Break 3";
        row3["Description"] = "Break Desc 3";
        row3["SessionID"] = 3;
        breaks.Rows.Add(row3);


        DataRow row4 = breaks.NewRow();
        row4["ID"] = 4;
        row4["Title"] = "Break 4";
        row4["Description"] = "Break Desc 4";
        row4["SessionID"] = 4;
        breaks.Rows.Add(row4);

        return breaks;
    }

    private DataRelation GetSessionBreakRelations()
    {
        return new DataRelation("relJobDetailsSessionDetails", Data.Tables["JobDetails"].Columns["ID"],
                                Data.Tables["SessionDetails"].Columns["JobID"]);
    }

    private DataRelation GetJobSessionRelations()
    {
        var dataRelation = new DataRelation("relSessionDetailsBreakDetails", Data.Tables["SessionDetails"].Columns["ID"],
                                            Data.Tables["BreakDetails"].Columns["SessionID"]);
        return dataRelation;
    }

    private void lstJobs_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }

    private void lstSessions_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }

    private void lstBreaks_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }
    }
}

As requested, here is a full repro case.

Update: updated with the working code from your link. Looks like the answer was binding to SelectedItem => relation. Very logical, actually.

XAML:

<Window x:Class="WpfApplication2.MainWindow" 
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" 
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" 
    Title="MainWindow" Height="350" Width="525">

    <Grid>
        <Grid.ColumnDefinitions>
            <ColumnDefinition Width=".5*"/>
            <ColumnDefinition Width=".5*"/>
        </Grid.ColumnDefinitions>
        <Grid.RowDefinitions>
            <RowDefinition Height=".33*"/>
            <RowDefinition Height=".33*"/>
            <RowDefinition Height=".33*"/>
        </Grid.RowDefinitions>
        <!--Jobs List box - Works fine-->
        <ListBox Name="lstJobs" Grid.Column="0" Grid.Row="0" 
             MinWidth="150"  
             MinHeight="200"  
             MaxHeight="250"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstJobs_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding Path=JobDetails}"                      
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=ID}"/>
                            <TextBlock Text="{Binding Path=Title}"/>
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>
        <!--How Jobs listbox is bound to relevant fields in jobs table. This works fine-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="0">
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.ID, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobNo" Grid.Row="1" IsEnabled="False"/>
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobTitle" Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="2"/>
            <TextBox Text="{Binding ElementName=lstJobs, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
             Name="txtJobDesc" Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>
        </StackPanel>

        <!--Sessions List box, Automatically filtered based on relationship (see last binding line). This works fine too -->
        <ListBox Name="lstSessions" Grid.Column="0" Grid.Row="1" 
             DockPanel.Dock="Top"  
             MinWidth="150"          
             MinHeight="200"  
             MaxHeight="220"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstSessions_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding ElementName=lstJobs, Path=SelectedItem.relJobDetailsSessionDetails}" 
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=Title}" />
                            <TextBlock Text="{Binding Path=ID}" />
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>


        <!--How Sessions listbox is bound to relevant fields in Sessions table. This works fine-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="1">
            <TextBox Name="txtSessionNo" Text="{Binding ElementName=lstSessions, Path=SelectedItem.ID,  UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="1" Grid.Column="0"/>
            <TextBox Name="txtSessionTitle" Text="{Binding ElementName=lstSessions, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="1" Grid.Column="1" Grid.ColumnSpan="3"/>
            <TextBox Name="txtSessionDesc" Text="{Binding ElementName=lstSessions, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="1" Grid.ColumnSpan="3" Grid.RowSpan="2"/>
        </StackPanel>

        <!--Breaks List box, Should be automatically filtered (it is), but it does not change when a job or session is selected. Why?? -->
        <ListBox Name="lstBreaks" Grid.Column="0" Grid.Row="2" 
             MinWidth="150"  
             MinHeight="140"  
             MaxHeight="140"          
             ScrollViewer.VerticalScrollBarVisibility="Visible"          
             SelectionChanged="lstBreaks_SelectionChanged"           
             IsSynchronizedWithCurrentItem="True"          
             ItemsSource="{Binding ElementName=lstSessions, Path=SelectedItem.relSessionDetailsBreakDetails}"          
             >
            <ListBox.ItemTemplate>
                <DataTemplate>
                    <Grid>
                        <StackPanel Orientation="Horizontal" Margin="3,0,3,0">
                            <TextBlock Text="{Binding Path=Title}" />
                            <TextBlock Text="{Binding Path=ID}" />
                        </StackPanel>
                    </Grid>
                </DataTemplate>
            </ListBox.ItemTemplate>
        </ListBox>
        <!--How Breaks listbox is bound to relevant fields in Breaks table. This works fine as before-->
        <StackPanel Orientation="Vertical" Grid.Column="1" Grid.Row="2">
            <TextBox Name="txtBreakNo" DockPanel.Dock="Bottom"  
             Text="{Binding ElementName=lstBreaks, Path=SelectedItem.ID, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="1"/>
            <TextBox Name="txtBreakTitle" DockPanel.Dock="Bottom" 
             Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Title, UpdateSourceTrigger=PropertyChanged}"  
             Grid.Row="2" Grid.Column="2"/>
            <ComboBox Name="cbxBreakType" DockPanel.Dock="Bottom" 
              Text="{Binding ElementName=lstBreaks, Path=SelectedItem.Description, UpdateSourceTrigger=PropertyChanged}"  
              Grid.Row="2" Grid.Column="3"/>
        </StackPanel>

    </Grid>


</Window>

Code behind:

using System;
using System.Data;
using System.Windows;
using System.Windows.Controls;

namespace WpfApplication2
{
    /// <summary>
    /// Interaction logic for MainWindow.xaml
    /// </summary>
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            CreateData();
            this.DataContext = Data;
        }


    public DataSet Data { get; set; }

    private void CreateData()
    {
        Data = new DataSet();
        Data.Tables.Add(CreateJobTable());
        Data.Tables.Add(CreateSessionsTable());
        Data.Tables.Add(CreateBreaks());

        DataRelation relation = GetJobSessionRelations();
        DataRelation relation2 = GetSessionBreakRelations();

        Data.Relations.AddRange(new[] {relation, relation2});
    }

    private DataTable CreateJobTable()
    {
        var jobs = new DataTable();
        jobs.TableName = "JobDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");

        jobs.Columns.Add(col1);
        jobs.Columns.Add(col2);
        jobs.Columns.Add(col3);

        DataRow row = jobs.NewRow();
        row["ID"] = 1;
        row["Title"] = "Job 1";
        row["Description"] = "Job Desc 1";
        jobs.Rows.Add(row);

        DataRow row2 = jobs.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Job 2";
        row2["Description"] = "Job Desc 2";
        jobs.Rows.Add(row2);

        return jobs;
    }

    private DataTable CreateSessionsTable()
    {
        var sessions = new DataTable();
        sessions.TableName = "SessionDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");
        var col4 = new DataColumn("JobID");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");
        col4.DataType = Type.GetType("System.Int32");

        sessions.Columns.Add(col1);
        sessions.Columns.Add(col2);
        sessions.Columns.Add(col3);
        sessions.Columns.Add(col4);

        DataRow row = sessions.NewRow();
        row["ID"] = 1;
        row["Title"] = "Session 1";
        row["Description"] = "Session Desc 1";
        row["JobID"] = 1;
        sessions.Rows.Add(row);

        DataRow row2 = sessions.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Session 2";
        row2["Description"] = "Session Desc 2";
        row2["JobID"] = 1;
        sessions.Rows.Add(row2);

        DataRow row3 = sessions.NewRow();
        row3["ID"] = 3;
        row3["Title"] = "Session 3";
        row3["Description"] = "Session Desc 3";
        row3["JobID"] = 2;
        sessions.Rows.Add(row3);

        DataRow row4 = sessions.NewRow();
        row4["ID"] = 4;
        row4["Title"] = "Session 4";
        row4["Description"] = "Session Desc 4";
        row4["JobID"] = 2;
        sessions.Rows.Add(row4);

        return sessions;
    }

    private DataTable CreateBreaks()
    {
        var breaks = new DataTable();
        breaks.TableName = "BreakDetails";
        var col1 = new DataColumn("ID");
        var col2 = new DataColumn("Title");
        var col3 = new DataColumn("Description");
        var col4 = new DataColumn("SessionID");

        col1.DataType = Type.GetType("System.Int32");
        col2.DataType = Type.GetType("System.String");
        col3.DataType = Type.GetType("System.String");
        col4.DataType = Type.GetType("System.Int32");

        breaks.Columns.Add(col1);
        breaks.Columns.Add(col2);
        breaks.Columns.Add(col3);
        breaks.Columns.Add(col4);

        DataRow row = breaks.NewRow();
        row["ID"] = 1;
        row["Title"] = "Break 1";
        row["Description"] = "Break Desc 1";
        row["SessionID"] = 1;
        breaks.Rows.Add(row);

        DataRow row2 = breaks.NewRow();
        row2["ID"] = 2;
        row2["Title"] = "Break 2";
        row2["Description"] = "Break Desc 2";
        row2["SessionID"] = 2;
        breaks.Rows.Add(row2);

        DataRow row3 = breaks.NewRow();
        row3["ID"] = 3;
        row3["Title"] = "Break 3";
        row3["Description"] = "Break Desc 3";
        row3["SessionID"] = 3;
        breaks.Rows.Add(row3);


        DataRow row4 = breaks.NewRow();
        row4["ID"] = 4;
        row4["Title"] = "Break 4";
        row4["Description"] = "Break Desc 4";
        row4["SessionID"] = 4;
        breaks.Rows.Add(row4);

        return breaks;
    }

    private DataRelation GetSessionBreakRelations()
    {
        return new DataRelation("relJobDetailsSessionDetails", Data.Tables["JobDetails"].Columns["ID"],
                                Data.Tables["SessionDetails"].Columns["JobID"]);
    }

    private DataRelation GetJobSessionRelations()
    {
        var dataRelation = new DataRelation("relSessionDetailsBreakDetails", Data.Tables["SessionDetails"].Columns["ID"],
                                            Data.Tables["BreakDetails"].Columns["SessionID"]);
        return dataRelation;
    }

    private void lstJobs_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }

    private void lstSessions_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }

    private void lstBreaks_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {

    }
    }
}
回复 原文
~没有更多了~

关于作者

浮华

暂无简介

0 文章
0 评论
23 人气
发私信

相关话题

更多

热门标签

操作系统 程序设计 IT运维 Linux系统管理 JavaScript 服务器应用 solaris C/C++ PHP Shell BSD Vue.js aix Oracle Python HTML 系统管理 HTML5 CSS 前端
更多

推荐作者

亚希

文章 0 评论 0

cyp

文章 0 评论 0

北漠

文章 0 评论 0

11223456

文章 0 评论 0

坠似风落

文章 0 评论 0

游魂

文章 0 评论 0

更多

友情链接

文江博客
    我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站，即表示您同意使用 Cookies 和您的相关数据。
    原文