Now we access this connection string on the page so we can open a connection with the relation database. The first one accesses the connection string and the other is for the SQL connection.Now we define a method for opening a connection with the relation database and returns a SQL connection object depending on the connection string that is passed as a parameter of the Sql Connection class constructor.Create SQL Connection We need a connection with a Microsoft SQL Server database so we can access data and perform an operation on it.We define a connection in the web.config file and give a name to the connection string.This enables you to provide an event-handling method that performs a custom routine, such as checking the results of the update operation, whenever this event occurs.A Grid View Updated Event Args object is passed to the event-handling method, which enables you to determine the number of rows affected and any exceptions that might have occurred. Delete a Record We can delete a record from the database table by clicking on the delete button that is in the Delete column of the Grid View.

You can hide a Command Field or Button Field based on the position (index) in the Grid View." Select Command="SELECT a.tenantcode, a.name, a.fixedrate, a.percentrate, a.percentage, b.locationd, c.status FROM TENANTNEW AS a INNER JOIN LOCATION AS b ON a.Storing datatable in View State is not a good practice as it increases the size of your page and reduces the performance, also View State can be deciphered on the client side, so the Data Table is not secure.Step 1 – Create database table and create new web application. Step 3 – Add name space for sql connection Data Table object. Now, finishing design make connection between sql database and web application.In this gridview example we use sql connection and sql dataadapter method for connectivity.Next Select your database and Set “Save Entity connection string in Web.config as” option true giving name Sample Entities.Select Both Category and Customer tables Give Model Namespace and click on Finish. NET Gridview Footer row for inserting record, inbuilt way to edit and delete records.You can also indicate whether the exception was handled in the event-handling method by setting the On Row Updated Row Canceling Edit On Row Canceling Edit Row Deleted On Row Deleted Row Deleting On Row Deleting Row Editing On Row Editing Row Updating On Row Updating Grid View Class System. Now you can ask questions directly to me on my new site ASPForums. When I Filter the data using dropdown selected Index Changed event the gridview shall load data based on what is searched.I need to do the updating operation on what row is clicked.This article explains how to perform insert, update and delete operations in ASP. Let us take an example to perform CRUD operations using Entity Framework Database First approach.Suppose we’ve to work on Customer table having Category ID as foreign key.In previous post we have discussed about insert update and delete data in gridview using dataset and table adapter method.In this post we will learn insert edit update and delete data in gridview control in using SQLConnection and SQLData Adapter method.