Refreshing GridView after Insert

[Chad Hensley]

I have a gridview that uses outside controls to insert/update/delete rows.

I fill it with a tableadapter.

        private void ManageLocations_Load(object sender, EventArgs e)
        {
            this.wISE_LocationsTableAdapter.Fill(this.locations.WISE_Locations);

        }

I insert/update/delete using custom calls.  The following works fine -- it inserts fine and grid refreshes with inserted record -- but when I close the child form in which it is called, and then reopen the child form, the grid is missing the new record.

        private void InsertLoc()
        {
            sh.InsertLoc(txtName.Text, txtZip.Text, string.Empty, string.Empty);
            this.rgLocations.Rows.Add(txtName.Text, txtZip.Text);
            this.UpdatePanelInfo(this.rgLocations.CurrentRow);
        }

The same thing with the update and delete.  It is like the tableadapter isn't refreshing with the new data.

I am using a SQLCE db, and that db is in my bin folder.

Any ideas on how I can refresh the tableadapter so that the grid always reflects exactly what is in the db?

Thanks

Chad

[Victor]

Hi Chad Hensley,

Are you sure your are committing your changeset to the database after update/insert/delete operations, that is, are you calling AcceptChanges()?

Sincerely yours,
Victor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Chad Hensley]

I don't use the TableAdapter to do insert/update/delete.  I use a middle tier that updates the db on button click.

Where would I do acceptchanges?

[Jack]

Hi Chad,

I see that you are using a TableAdapter to wrap your data source. In this case you should call its Update method when closing the form. You can find more information in the following MSDN article.

Greetings,

Jack
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.