how to save data from database into combo box using mvvm

Question

0.00/5 (No votes)

See more:

I wants get the out put from database into combo box,
retrieved data from the database but it's not bind into the combo box
all the values are stored into observable collection but it's not binding

here my Code

XAML

XML

<StackPanel Orientation="Horizontal" DataContext="{Binding Path=LocationListModel, Mode=TwoWay}"  >
                   <StackPanel Margin="5" >
                       <Label Content="Location Name"/>
                       <!--<TextBox TextWrapping="Wrap" Name="cmbLocation" Text="{Binding LocationNameLists, Mode=OneWay}" ></TextBox>-->
                       <ComboBox Name="cmbLocation"  Grid.Column="1" Grid.Row="1" Width="200" ItemsSource="{Binding LocationNameList}"  DisplayMemberPath="LocationName"  Loaded="cmbLocation_Loaded">
                           <!--<ComboBoxItem Content="qwerty"/>-->
                       </ComboBox>
                   </StackPanel>
                   <StackPanel Margin="5">
                       <Label Content="Building Name"/>
                       <ComboBox Name="cmbBuilding"  Width="200"/>
                   </StackPanel>
               </StackPanel>

WPF

public class LocationListModel : paymentModel
{
//LocationEntity locationEntity = new LocationEntity();

private ObservableCollection<paymententity> LocationList = new ObservableCollection<paymententity>();
// public ObservableCollection<paymententity> LocationId = new ObservableCollection<paymententity>();

public ObservableCollection<paymententity> LocationNameList
{
get { return LocationList; }

set
{
LocationList = value;

base.RaisePropertyChangedEvent("LocationNameList");
}
}

public ObservableCollection<paymententity> LocationIdList
{
get;
set;

}

public void locationListModel()
{

PaymentEntity paymentEntity = new PaymentEntity();
PaymentBussiness paymentBussienss = new PaymentBussiness();
DataTable LocationNameList = paymentBussienss.GetLocationList();

foreach (DataRow row in LocationNameList.Rows)
{
var obj = new PaymentEntity()
{
LocationId = (int)row.ItemArray[0],
LocationName = (string)row.ItemArray[1]

};

LocationList.Add(obj);

}
base.RaisePropertyChangedEvent("LocationNameList");

}

}

Posted 18-Feb-15 1:41am

PandIyan T

Add a Solution

2 solutions

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)

Naveen Kumar Tiwari · Answer 1 · 2015-02-18T02:08:00

Replace Your combobox with following code

<combobox name="cmbLocation" grid.column="1" grid.row="1" width="200"></combobox>

If you are getting data in datlist then you can bind this data in combobox like that...
public void fillLocation()(Call this Method when you want to bind Location in combobox)
{

cmbLocation.DataContext = dtSource;(your data table name whatever it is)
cmbLocation.SelectedValuePath = "ID";
cmbLocation.DisplayMemberPath = "Name";
cmbLocation.UpdateLayout();
cmbLocation.SelectedValue = 0;
}

Happy Coding............

TheRealSteveJudge · Answer 2 · 2015-02-18T02:11:00

The data context was not set correctly.
This example shows you how you can successfully bind to a ViewModel.

Besides:
1) A model cannot be used as data context.
Data context is always a ViewModel
2) It is not good practice to use code behind in MVVM
You should use Commands instead.

MainWindow.xaml:

XML

<Window x:Class="WpfApplication14.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:local="clr-namespace:WpfApplication14"
        Title="MainWindow" Height="350" Width="525">
    
    <Window.DataContext>
        <local:ViewModel></local:ViewModel>
    </Window.DataContext>
        
    <Grid>
        <StackPanel Orientation="Horizontal">
            <StackPanel Margin="5" >
                <Label Content="Location Name"/>               
                <ComboBox Name="cmbLocation"  Grid.Column="1" Grid.Row="1" Width="200" ItemsSource="{Binding LocationNameList}">                    
                </ComboBox>
            </StackPanel>
            <StackPanel Margin="5">
                <Label Content="Building Name"/>
                <ComboBox Name="cmbBuilding"  Width="200"/>
            </StackPanel>
        </StackPanel>
    </Grid>
</Window>

ViewModel.cs

C#

using System;
using System.Collections.ObjectModel;
using System.ComponentModel;

namespace WpfApplication14
{
    class ViewModel : INotifyPropertyChanged
    {
        [AttributeUsageAttribute(AttributeTargets.Parameter, Inherited = false)]
        public sealed class CallerMemberNameAttribute : Attribute { }

        public event PropertyChangedEventHandler PropertyChanged = delegate { };

        public void OnPropertyChanged([CallerMemberName]string propertyName = null)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
            }
        }

        private ObservableCollection<string> locationNameList;

        public ObservableCollection<string> LocationNameList
        {
            get
            {
                return locationNameList;
            }
            set
            {
                if (locationNameList != value)
                {
                    locationNameList = value;

                    OnPropertyChanged();
                }
            }
        }

        public ViewModel()
        {
            locationNameList = new ObservableCollection<string>();

            LocationNameList.Add("London");
            LocationNameList.Add("Berlin");
            LocationNameList.Add("Paris");
            LocationNameList.Add("Mumbai");
            LocationNameList.Add("Toronto");
        }
    }
}

how to save data from database into combo box using mvvm

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0