Edit and Update Record in GridView Without C# Code

Introduction

This article explains how to edit and update records using a GridView without writing a single line of code behind C# code.

Step 1

First of all create a table using the following scripts in SQL Server:

Step 2

Now open Visual Studio and create a new project and provide the name, whatever you want. Add a page to your project and drag and drop a GridView.



Step 3

Click on the new data source and:



Step 4

Select the proper database and click on ok.



Step 5

Enter proper information and click on ok then another window will open like:



Step 6

Click on "Next" and:



Step 7

Select a table name and click on the advanced button, then check those two checkboxes and click on ok and go to next.



Now test the query and click on the Finish button.

Step 8

Now check all the checkboxes that you require.

 

• For Edit operation check Enable Editing.
• Delete operation check Enable Deleting.
• Sorting enable shorting and so on.

Now if you go to the source it will look like:

GridView =>

And SqlDataSource =>
You can change the data source's select, update and delete query as your need.

Now run the page using Ctrl+F5; it will look like:



Now click on the edit or delete button and modify the data.



Here you can see I have not written a single line of cs code in code behind.

Summary

In this illustration we learned how to update and delete database records using a GridView without C# code. Please provide your valuable comments about this article.