winrt sql data not displaying via mvvm

Question

1.00/5 (2 votes)

See more:

C#

public class Customer
    {
        [PrimaryKey, AutoIncrement]
        public int Id { get; set; }
        public string Name { get; set; }
        public string City { get; set; }
        public string Contact { get; set; }

C#

public ObservableCollection<Customer> _customerlist { get; set; }
        public Customer CustomerToAdd { get; set; }
        /// <summary>
        /// Add Customer data to the table
        /// </summary>
        public RelayCommand AddCustomerCommand { get; set; }
        private async void addCustomer()
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,"data.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                // Create the tables if they don't exist
                db.Insert(new Customer()
                {
                    Name = CustomerToAdd.Name,
                    Contact = CustomerToAdd.Contact,
                    City = CustomerToAdd.City,
                    
                });


                db.Commit();
                db.Dispose();
                db.Close();
                var line = new MessageDialog("Records Inserted");
                await line.ShowAsync();
            }
        }
        /// <summary>
        /// Delete Selected Customer data from the table
        /// </summary>
        public RelayCommand DeleteSelectedCustomerCommand { get; set; }
        private void deleteSelectedCustomer()
        {

        }
        /// <summary>
        /// edit Selected Customer data from the table
        /// </summary>
        public RelayCommand EditSelectedCustomerCommand { get; set; }
        private void editSelectedCustomer()
        {

        }
        /// <summary>
        /// Delete All Customer data from the table
        /// </summary>
        public RelayCommand DeleteAllCustomerCommand { get; set; }
        private void deleteAll()
        {

        }

        public MainPageViewModel()
        {
            AddCustomerCommand = new RelayCommand(addCustomer);
            CustomerToAdd = new Customer();
            _customerlist = new ObservableCollection<Customer>();
            DeleteAllCustomerCommand = new RelayCommand(deleteAll);
            EditSelectedCustomerCommand = new RelayCommand(editSelectedCustomer);
            DeleteSelectedCustomerCommand = new RelayCommand(deleteSelectedCustomer);
        }

XML

<Page.DataContext>
        <ViewModels:MainPageViewModel>

        </ViewModels:MainPageViewModel>
    </Page.DataContext>

    <Grid removed="{ThemeResource ApplicationPageBackgroundThemeBrush}">
        <ListView ItemsSource="{Binding _customerlist}"
                  HorizontalAlignment="Left" Margin="44,65,0,327" Width="456">
            <ListView.ItemTemplate>
                <DataTemplate>
                    <StackPanel Width="400" removed="Chocolate">
                        <StackPanel Orientation="Horizontal">
                            <TextBlock Text="{Binding Name}" FontSize="30" />
                            <TextBlock Text="," FontSize="30" />
                            <TextBlock Text="{Binding City }" FontSize="30" />
                        </StackPanel>
                        <TextBlock Text="{Binding Contact}" FontSize="30" />
                    </StackPanel>
                </DataTemplate>
            </ListView.ItemTemplate>
        </ListView>

        <Button Command="{Binding  AddCustomerCommand}" 
        		Content="Add person" 
        		FontSize="40" Margin="588,465,0,230"/>
        <Button Command="{Binding EditSelectedCustomerCommand}" 
        		Content="Edit" 
        		FontSize="40" Margin="865,465,0,230"/>
        <Button Command="{Binding DeleteSelectedCustomerCommand}" 
                Content="Delete" 
                FontSize="40" Margin="1037,465,0,230" />
        <Button Command="{Binding DeleteAllCustomerCommand }" 
                Content="Delete All" 
                FontSize="40" Margin="979,619,0,76" />

        <TextBlock Text="Name" FontSize="30" Margin="633,65,598,640" Height="63"/>
        <TextBox DataContext="{Binding CustomerToAdd}" Text="{Binding Name, Mode=TwoWay}" 
                 FontSize="30" Margin="868,62,80,640"/>
        <TextBlock Text="City " FontSize="30" Margin="633,181,551,524"/>
        <TextBox DataContext="{Binding CustomerToAdd}" Text="{Binding City, Mode=TwoWay}" 
                 FontSize="30" Margin="868,181,80,525"/>
        <TextBlock Text="Contact" FontSize="30" Margin="633,296,536,400"/>
        <TextBox DataContext="{Binding CustomerToAdd}" Text="{Binding Contact, Mode=TwoWay}" 
                 FontSize="30" Margin="868,296,80,403"/>
    </Grid>

i am insert data and its show "Records Inserted" but list box not showing that data

Posted 20-May-14 19:36pm

luan_luna

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)

luan_luna · Accepted Answer · 2014-05-21T01:59:00

C#

private async void addCustomer()
        {
            var dbpath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path,"data.db3");
            using (var db = new SQLite.SQLiteConnection(dbpath))
            {
                // Create the tables if they don't exist
                db.Insert(new Customer()
                {
                    Name = CustomerToAdd.Name,
                    Contact = CustomerToAdd.Contact,
                    City = CustomerToAdd.City,
                    
                });
                var newCustomer = new Customer()
                {
                    Name = CustomerToAdd.Name,
                    Contact = CustomerToAdd.Contact,
                    City = CustomerToAdd.City,
                };
                db.Insert(newCustomer);
                _Customerlist.Add(newCustomer);
               
                db.Commit();
                db.Dispose();
                db.Close();
                var line = new MessageDialog("Records Inserted");
                await line.ShowAsync();
            }
        }

Naz_Firdouse · Accepted Answer · 2014-05-21T02:03:00

Try this

C#

Instead of using this
  db.Insert(new Customer()
                {
                    Name = CustomerToAdd.Name,
                    Contact = CustomerToAdd.Contact,
                    City = CustomerToAdd.City,
                    
                });
 
Use the following
 Customer newCustomer = new Customer() {
                    Name = CustomerToAdd.Name,
                    Contact = CustomerToAdd.Contact,
                    City = CustomerToAdd.City,
                    
                };
db.Insert(newCustomer);
customerlist.Add(newCustomer);

The reason is you are inserting the recod in DB but the same is not added to the list which is binded to lsitbox.

so you either need to add the customer object to the list whenever a new object is created or you need to pull the data from DB.

winrt sql data not displaying via mvvm

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0