Updating dataset with gridview


12-Nov-2017 18:42

The Grid View contains three Template Field columns namely, ID, Category Name and Category Description.

The Item Template of the Category Name and Category Description contains a Text Box control since we want to update these fields.

Additionally, the powerful data grid control supports out of the box binding to objects in sub directory as well as their properties for customizing.

The Kettic Grid View component allows users of the Grid View control easily binding to database table or dataset.

I have no earthly idea why the Update command wants to update the key columns by default.

NET component allows users of the Grid View control easily binding to database table or dataset.

Step 4: Please press Ctrl F5 to show Data In page, the test steps just like Data From Data Add "Person" table with three fields "Person ID","First Name","Last Name", Person ID is the primary key of the table, and you can insert some default values in Person table. Drag and drop a Grid View control, two Link Button controls, two Text Box controls and a Panel control into Data From Data page.

Matt Berseth wrote a very interesting article on “Bulk Inserting Data Using the List View Control".

The idea is to give the user an Excel like interface where they can edit the rows with custom data and finally click the update button to persist the data in the database.

The sample demonstrates data source from both database and memory.

For this sample to work, you must install the Sql Server 2008 R2 Express.The following is a guide that shows how to bind the Grid View control to a single data table.