I need badly to REMOVE a row from a DataGrid without effecting the DB

  • Thread starter Thread starter Jordan Kaufman
  • Start date Start date
J

Jordan Kaufman

Hi,

I need to remove a row from a DataGrid without effecting the Database. I've
seen this question posted on the all over but never answered.

(f it helps I use the datagrid to export an excel file, but need to preen
down the grid based on an algorith that can not be put into my SQL Query.)

PLEASE HELP!
 
Jordan,

You can make an extra boolean column in your datatable by instance
Show.On.Grid.
Use that in your rowfilter of the defaultview or dataview.

I hope this helps,

Cor
 
Its not very clear ur question, but :

You can remove from the grid and not update the dataset. I mean not to use
dataset.update(...)

Or u can make a copy of the table to another table and work with that copy.

Or as Cor said u can add another collumn and use taht collumn to filter.
 
Back
Top