Delete Database on Gridview ASP.net

Question

Is It Possible To Delete A Record On A Gridview But When We Open At The Database  It Still Has It's Data Is It Possible To Do That ? If Possible please Reply me Fast it's Urgent THANK YOU

Riddhi Valecha · Answer

Hi.. I would suggest..... do soft delete of records in database.. Eg - Keep a column -IsDeleted or Flag with datatype - bit in the database. 1 ==> true ==> Active records. 0 ==> false ==> InActive Records. While loading fire the query - select * from tablename where flag = 1 While deleting  fire query - update tablename set flag = 0 where ID = 1 --------- This will keep a history of all records. This can help in future also.

Pankaj Kumar Choudhary · Answer

hello @Eric first right click om table and select design option. after that select your column name to which you want to set default after that goes to column property and set the default property as 1 and save your table ctrl +s hope it will work for you..

Eric Sebastian · Answer

where will i put the default value

Pankaj Kumar Choudhary · Answer

hello @eric i think #Riddhi is correct you should add an extra column _IsDelted with datatype Bit and set default value 1. when you binding the data to gridview then you can select all data from table where _Isdeleted is equal to 1. when you delete an data from gridview then you can set this column to 0. such that data will be remove from gridview and also remain save in table...

g s · Answer

It is Possible To Delete Explain Below Links http://dotnetdrizzles.blogspot.in/2014/09/insertupdatedelete-in-gridview-using.html http://screenshotdrizzles.blogspot.in/2014/10/insertupdatedelete-in-gridview-using.html

Gowtham Rajamanickam · Answer

http://www.c-sharpcorner.com/UploadFile/asmabegam/insert-select-update-delete-in-Asp-Net-with-simple-login/

Gowtham Rajamanickam · Answer

http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx

Tom Mohan · Answer

Hi Eric Get the primary key(or any unique filed) of the record from gridview during deletion. Call you sql query(Delete from table where column=key) and commit transaction .

Eric Sebastian · Answer

I Don't Understand

Syed Shanu · Answer

Check this links hope this will help you. http://www.c-sharpcorner.com/UploadFile/asmabegam/insert-select-update-delete-in-Asp-Net-with-simple-login/ http://www.aspsnippets.com/Articles/GridView-CRUD-Select-Insert-Edit-Update-Delete-using-Single-Stored-Procedure-in-ASPNet.aspx http://www.c-sharpcorner.com/uploadfile/raj1979/select-add-update-and-delete-data-in-a-Asp-Net-gridview-control/