How to update remote MS SQL Database using dataGridView1

using c#/winforms, I used the designer view to add a datagridview control to the form and set it up... It can successfully read from the remote database :) but I need for it to be able to update the database too, for example, when I add new rows or edit/remove existing ones.

Ho开发者_StackOverflow中文版w can this be done?

Thanks, and any help is much appreciated :)

There are many ways. One is to use a binding source component tied to a typed dataset or business object as datasource.

BindingSource will handle the CRUD functions between user and dataset/datatable. Use tableadapters for final updates.

BindingSource Component