Telerik gridview : How to refresh grid view after Database change

Question

I'm using radgridview in C# winform application to show data from database. I'm also altering database through ADO.Net. The problem is after I change the database, for example by deleting a row or adding a new row, changes do not appear in gridview.
I also want to mention that I have bound database to gridview through smart tags and when I tried to create a new dataset and assign it to radgridview1.datasource I got tons of errors.
Any suggestion on how can force radgridview to reload it's datasource ?

I don't think you can find anything special in code, After user presses delete button, I delete the row through ADO. that's all. — Rsh, May 17 '13 at 10:45

score 7 · Answer 1 · edited Dec 14 '13 at 12:51

7

When datasource get changes, to refresh datagrid use following code :

this.radGridViewName.MasterTemplate.Refresh(null);

this line solved my problem :-)

edited Dec 14 '13 at 12:51

giampaolo

6,906
5
45
73

answered Dec 14 '13 at 12:29

Priyanka

91
1
3

1

Also try `this.radGridViewName.TableElement.UpdateView();` – Behzad Ebrahimi Jun 01 '19 at 23:37

score 4 · Answer 2 · answered May 17 '13 at 10:52

4

You can use simple soultion to refresh data in grid:

MyGrid.DataSource = null;
MyGrid.DataSource = updatedData;

answered May 17 '13 at 10:52

alexmac

19,087
7
58
69

Again load it from the database. – alexmac May 17 '13 at 11:02
If I create a new dataset and fill it through `adapter.Fill(ds)` I get null pointer exception in `itemDatabound` event handler. – Rsh May 17 '13 at 11:04
As I said before, I didn't connect to db programmitically, I used smart tags properties. – Rsh May 17 '13 at 11:06

score 2 · Accepted Answer · answered May 17 '13 at 16:25

2

Well, I found the answer myself. Although it only works on dataGridView and doesn't work on dataListView.
To delete a record and commit changes to database :

radGridView1.CurrentRow.Delete();
this.yourTableAdapter.Update(yourDataSet);

On the other hand, if you have added new records and you want to reform the list :

this.yourTableAdapter.Fill(yourDataSet.yourTabel);

If you know how to do the same with dataListView, I'll be glad to hear.

answered May 17 '13 at 16:25

Rsh

7,214
5
36
45

Well updating the TableAdapter is just what I suggested above :). Good luck. – checho Aug 27 '14 at 15:45

score 1 · Answer 4 · answered May 18 '13 at 10:30

Here is a tutorial, explaining in a step by step manner how to bind the grid. Once it is bound, changes introduced to the underlying source will be automatically reflected and changed in RadGridView will be updated in the DataTable after you Update the TableAdapter.

score 0 · Answer 5 · answered Jun 27 '14 at 13:15

This solution is similar to Alexander's:

List<ClassOfDataRow> t = radGridView.ItemsSource as List<ClassOfDataRow>;
radGridView.ItemsSource = null;
radGridView.ItemsSource = t;

ClassOfDataRow is the class used to store one row of data in the grid and radGridView is the name of your RadGridView.

score 0 · Answer 6 · answered May 09 '16 at 13:19

0

The dataset has a clear function which can be called before new data is passed to the dataset :

Resultset.Clear();
DataAdapter.fill(Resultset);
Radgridview.datasource=Resultset;

answered May 09 '16 at 13:19

wsduho

377
3
9

Telerik gridview : How to refresh grid view after Database change

6 Answers6

Linked