How to bind ComboBox cell to "splitted" String in DataTabe Column

Question

0.00/5 (No votes)

See more:

, +

Hi guys,

I can't figured it out... For example I have DataTable "Table1" with "ID" and "Names" columns.
Rows look like:
ID Names
1 test1|test2|test3
2 test4|test5|test6

I bind ID column like this:

C#

C#
...
DataSet dataset = new DataSet();
DataGridView.ItemSource = dataset.Table1.DefaultView;
...

XAML
...
<DataGrid.Columns>
 <DataGridTextColumn Binding="{Binding Path=ID}" Header="ID" />
...

This part works well. But how can I bind combobox column for "Names" in my situation?

Please give me direction. Thank you.

[UPDATE]
"Names" has values like "test1|test2|test3" in DataSet for each row.
I'm looking for solution to display value "test1|test2|test3" from DataSet in DataGridView row with ComboBox which will have items:
- test1
- test2
- test3

Let me know if it's still unclear

Timur.

Posted 12-Feb-12 2:19am

TimGameDev

Updated 15-Feb-12 23:27pm

v2

Add a Solution

Comments

Mohamed Ahmed Abdullah 13-Feb-12 14:45pm

try this
<combobox itemssource="{Binding Names}"/>

Nestor Arturo 15-Feb-12 8:26am

Do you mean "Names" has a value like "test1|test2|test3", all in the same column?

TimGameDev 16-Feb-12 5:30am

I've updated my question with details. Let me know if it's still unclear

3 solutions

Solution 1

Try this

HTML

<datagridcomboboxcolumn header="Column Header" selecteditembinding="{Binding ID} DisplayMemberPath=" hold=" /></pre><br mode="></datagridcomboboxcolumn>

Posted 15-Feb-12 1:19am

Ibrahim Yusuf

Comments

TimGameDev 16-Feb-12 5:31am

It will display ComboBox with one item which will have value "test1|test2|test3", isn't it? Please check my question again.

Thanks, Timur

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

SteveAdey · Accepted Answer · 2012-02-16T00:05:00

Solution 2

In your ViewModel define a property like:

public IEnumerable<string> Names
{
get
{
   return nameColumn.Split('|');
}
}

Then bind your ComboBox ItemsSource to Names

Ok, the ViewModel will look like:

public class MainViewModel
{
    private string contentNames = "test1|test2|test3";

    public IEnumerable<string> SplitContentNames
    {
        get
        {
            return contentNames.Split('|');
        }
    }
}

The XAML will look like:

<Grid>
    <Grid.RowDefinitions>
        <RowDefinition Height="Auto"/>
    </Grid.RowDefinitions>
    <ComboBox ItemsSource="{Binding SplitContentNames}"/>
</Grid>

And the code behind of MainViewWindow.cs will bind the DtaContext like so:

this.DataContext = new MainViewModel();

Then to get the selected item into your view model, add a property for your selected item:

public string SelectedName
{
    get;
    set;
}

and then bind the SelectedValue using XAML:

<ComboBox ItemsSource="{Binding SplitContentNames}" SelectedValue="{Binding SelectedName}"/>

Now when you change the value in the combobox the current value will be set in the SelectedName property.

Posted 16-Feb-12 0:05am

SteveAdey

Updated 20-Feb-12 21:10pm

v4

Comments

TimGameDev 19-Feb-12 10:20am

Unfortunately I cannot make your solution works. Anyway I found worked solution by myself. It's binding converter.

SteveAdey 19-Feb-12 11:05am

hmmm, not sure why you couldn't get this to work, given your solution, as they should equate to the same thing. Mine's just doing it in the ViewModel, while yours is doing it in a converter (IMHO not the way to go). But, if it works for you...

TimGameDev 19-Feb-12 12:07pm

Steve, could you please provide detailed example how I should change ViewModel and bind combobox to new property? Probably I do something wrong.
And one more question - what is problem with converters from your point?

Thanks for participation.

SteveAdey 19-Feb-12 16:31pm

Hi Timur, I've now updated my solution with an example. My main reason for not recommending the Value Converter in this case, is that it's something the view model should be dealing with. The Converters are really to convert data from one type into a more visual type. This will do what you want, but what if some data came from another source as was not delimited by the '|' character? Or you had a list that was not delimited at all? This would make for some very messy XAML. I'm not saying that you shouldn't use it here, just that it's not good practice.

TimGameDev 20-Feb-12 18:22pm

Thank you very match! My problem was in Binding, incorrect source was specified...Now it works perfect. If you don't mind I leave my solution as accepted also (as alternative)

Timur.

TimGameDev 20-Feb-12 18:45pm

Aargh, one more question...I binded combobox to a ViewModel property like in your example and it works. But in reality each row has its own value and my question is how can I get current row value for splitting? Thanks in advance.

PS: I rejected solution currently.

SteveAdey 21-Feb-12 3:10am

I've now updated the solution to show you how to bind to the selected value.

Each row should have its own ViewModel. i.e. you want an overall ViewModel with an ObservableCollection of your row ViewModels.

If you take a look at http://tap-source.com/?p=160, that should give you some idea of how to do this. If you're going to do WPF, then you really need to learn MVVM.

TimGameDev 21-Feb-12 7:03am

Steve, thanks a lot!

You are absolutely right I feel lack of experience with MVVM. Will work on it.

SteveAdey 21-Feb-12 7:13am

Sorry, that wasn't a dig, more of a suggestion to help you in the future.

TimGameDev · Accepted Answer · 2012-02-19T04:25:00

Okay, any solutions represented here do not work for me.

I solved by myself again. Here is the solution:

Create class like:

C#

[ValueConversion(typeof(String), typeof(String))]
public class StringSplitterConverter : IValueConverter
{

    public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
    {
        return value.ToString().Split('|');
    }

    public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
    {
        return value;
    }
}

Use this converter in combobox binding:

C#

...
            <datagrid.resources>
                <local:stringsplitterconverter x:key="splitterConverter" xmlns:x="#unknown" xmlns:local="#unknown" />
            </datagrid.resources>
...
                    <datagridtemplatecolumn.celltemplate>
                        <datatemplate>
                            <combobox itemssource="{Binding Path=ContentNames, Converter={StaticResource splitterConverter}}"></combobox>
                        </datatemplate>
                    </datagridtemplatecolumn.celltemplate>

This solution works great.

How to bind ComboBox cell to "splitted" String in DataTabe Column

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us