Execute the below SP_Customer stored procedure in sql server database which is used to handle insert, update, select and delete a record into customer table.
Here we are not deleting a record permanently but using active flag column, make it inactive the record while doing the delete operation then make it active and get it whenever you want.
NET Architecture MVP (Microsoft Most Valuable Professional) works as an Architect Consultant and provides consultancy on how to design and develop Web applications.
Suprotim is also the founder and primary contributor to Dev Curry, Dot Net Curry and SQLServer Curry.
In this article, we will explore how to add, update, delete and select a record from sql server database using gridview control in a simple way.