Updating Database Table Automatically when changes are made in gridview which is bounded to it.

[Rakesh]

I am not able to update/insert/delete the data of database table which is bounded to a radgridview by selecting the Data Source for it.
The changes which i make in the gridview, i want that to be reflected in the database table automatically or on a button click, which i could not so please help me and give me code for it in c#.
The database I am using is Sql. 

[Julian Benkov]

Hi Rakesh,

The RadGridView control not support this functionality automatically. The grid control bounds and renders different types of data and load/save logic from databases and other storages is implemented as business logic of the developed application.

If you are using DataTable and TableAdapter to retrieve and update data from a SQL Server database in a button click handler use this code snippet:

public partial class Form6 : Form
{
    public Form6()
    {
        InitializeComponent();
    }

    private void Form6_Load(object sender, EventArgs e)
    {
        // TODO: This line of code loads data into the 'northwindDataSet.Customers' table. You can move, or remove it, as needed.
        this.customersTableAdapter.Fill(this.northwindDataSet.Customers);

        this.radGridView1.DataSource = this.northwindDataSet.Customers;

    }

    private void radButton1_Click(object sender, EventArgs e)
    {
        this.customersTableAdapter.Update(this.northwindDataSet.Customers);
    }
}

Sincerely yours,
Julian Benkov
the Telerik team