How to delete row without delete in database

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hi,
How to delete some row of gridview without delete in database. For example, My tabel has IsDeleted field and in this field if this field is 1 then it deleted in gridview.........

Thanks
Shashank

Posted 28-Oct-11 19:51pm

Member 8357723

Add a Solution

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2011-10-28T19:57:00

Solution 1

Try setting Visible = false, read this : http://stackoverflow.com/questions/592106/how-to-delete-row-from-gridview[^]

Posted 28-Oct-11 19:57pm

Mehdi Gholam

Uday P.Singh · Accepted Answer · 2011-10-28T19:59:00

Solution 2

If I correctly understood your question, then its very simple, you can fill the dataset with following query:

SQL

select * from tablename where IsDeleted!=1;

and use this dataset for gridview.

hope it helps :)

Posted 28-Oct-11 19:59pm

Uday P.Singh

Mohd Wasif · Accepted Answer · 2011-10-28T20:01:00

First you need to add an extra field as flag and its data type as int and set its default value as 0.
Now populate data in gridview with condition where falg=0 and on delete command of gridview update value of flag as 1.

By this no data will be deleted but it will show as deleted in Gridview.

How to delete row without delete in database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

How to delete row without delete in database

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us