Updating all gridview contents at a time to the database

Yii uses Data Providers to interact with data sources and it provides some widgets to output the data.

updating all gridview contents at a time to the database-19

This will improve performance in cases where you display a large number of rows to the user and the user only updates few rows. Net is useful for displaying large data in a tabular format.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.Matt took the road to update all the rows whether they were changed or not.

In this article we are going to take a look at an alternative method of updating only the changed rows.In this article I will show you how to Bind Grid View in 3 tier in ASP. We will also edit, delete and update the data in Grid View.Initial Chamber Step 1: Open Visual Studio 2010 and create an Empty Website. Step 2: In Solution Explorer you will get your empty website. By going like this: For Web Form Grid View_demo (Your Empty Website) - These all are the Stored Procedures that we will use for updating, deleting and editing data in Grid View.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.The links are all automatically generated by the widget and actions are handled by the Data Provider.