Adding Row to DataGrid Silverlight

Question

4.50/5 (2 votes)

See more:

I have a Datagrid which show data from a database.
each time i load the data from my data vase the old data is earsed and the is replaced with the new data.

What i want is for the pervious row to remain and the new data to be appened to the end of the datagrid.

my code is as shown below :

C#

public MainPage()
        {
            InitializeComponent();
            dataGrid1.Columns.Add(new DataGridTextColumn { Header = "Year", Binding = new System.Windows.Data.Binding("year") });
            dataGrid1.Columns.Add(new DataGridTextColumn { Header = "Running", Binding = new System.Windows.Data.Binding("One") });
            dataGrid1.Columns.Add(new DataGridTextColumn { Header = "Idle", Binding = new System.Windows.Data.Binding("Two") });
            dataGrid1.Columns.Add(new DataGridTextColumn { Header = "Turned Off", Binding = new System.Windows.Data.Binding("Three") });

        }

C#

void client_DoWorkCompleted(object sender, DoWorkCompletedEventArgs e)
        {

                       dataGrid1.ItemsSource = list;

        }

how do i append the new data from the database rather than overwriting the data ??

Posted 28-Feb-11 15:05pm

Amd_eagle

Add a Solution

4 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)

Dave Kreskowiak · Answer 1 · 2011-02-28T16:14:00

Solution 1

Keep your data in a DataTable object, then bind the grid to it. When you get a new record, add it to the DataTable and refresh the binding.

Posted 28-Feb-11 16:14pm

Dave Kreskowiak

Comments

Amd_eagle 28-Feb-11 22:33pm

I am writing it in a Silverlight Application so I am not able to use DataTable.

Amd_eagle 28-Feb-11 22:34pm

I am writing the datagrid in a silverlight application so i not able to use the DataTable.

Abhinav S · Answer 2 · 2011-02-28T17:24:00

Solution 2

Add a new item to your datasource collection i.e. list.

If you have done your binding correctly, a row will get added automatically to the datagrid.

Posted 28-Feb-11 17:24pm

Abhinav S

Comments

Amd_eagle 1-Mar-11 0:28am

how do i go about doing it ??

Abhinav S 1-Mar-11 1:30am

something like
list.add(new model());
where model is your model class.

ashokm01 · Answer 3 · 2012-10-24T19:34:00

Solution 3

Create an global declaration
ObservableCollection<person> myObs = new ObservableCollection<person>();

Add New Function

Private void AddRows(){
myObs.Add(new Person() {});
datagrid1.itemsource=myObs;
}

Call the above function in a button click to add new rows dynamically.

Posted 24-Oct-12 19:34pm

ashokm01

Pushkar The Heaven · Answer 4 · 2014-08-08T02:25:00

Solution 4

DataClass obj=new DataClass(); // this is the class used in databinding

observablecollectionobj[0] = obj ; // if want to insert at any position, you have mention the index no.

Posted 8-Aug-14 2:25am

Pushkar The Heaven