WCF RIA Services

Re: Combobox Binding to SQL Database

bbakermai — Fri, 03 Jul 2009 22:46:04 GMT

Did you look at this blog post?

Re: Combobox Binding to SQL Database

Walesman — Thu, 02 Jul 2009 21:45:22 GMT

Thanks for your response Michael. Actually, it was quiet simple in then end (see below) and I dont know what I was doing wrong.

In your xaml code, what does the 'DisplayMemeberPath' do differently from what I have below.

Thanks

Phillip

<ComboBox.ItemTemplate>

<DataTemplate>

<StackPanel Orientation="Horizontal">

<TextBlock Margin="5,0,0,0" Text="{Binding Path=CategoryName}" Width="100"/>

</StackPanel>

</DataTemplate>

</ComboBox.ItemTemplate>

</ComboBox>

Re: Combobox Binding to SQL Database

mchlSync — Thu, 02 Jul 2009 18:48:16 GMT

Hello,

Are you seeing the type of object instead of CategoryName? I think you can try setting CategoryName to DisplayMemberPath of Combobox.

For example:

<ComboBox x:Name="uxd_Category"

ItemsSource="{Binding CategoryList}"

DisplayMemberPath="CategoryName"

Combobox Binding to SQL Database

Walesman — Thu, 02 Jul 2009 14:47:54 GMT

Could someone please provide or direct me to a 'simple' example of bindng data to a combobox. I have found many articles in various forums on binding to a combobox, but they all seem to deviate from the simple scenario I am trying to replicate.

I am using SL3, RIA Services, Entity Framework and the NorthWind DB. All I want to do is create a combobox and bind to the the 'CategoryName' column from the Categories table. I create the relevant Data Model, Service, Domain Data Source and bindins in xaml, but I dont get the correct content. What I see in the resulting combobox is

Category 1

Category 2

Category 3

etc

It appears to be a binding issue, but I am at a loss. If anyone has a simple example to show me the error of my ways I would greatly appreciate it.

Thanks