Delete Database on Gridview ASP.net

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..

where will i put the default value

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...

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

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 .

I Don't Understand

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.

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/