When you bring in SQL records onto an .aspx page, is it possible to delete a row off the page (using VB) without deleting the record itself from the SQL table?
Printable View
When you bring in SQL records onto an .aspx page, is it possible to delete a row off the page (using VB) without deleting the record itself from the SQL table?
No, but you can do a select statement like this to avoid displaying a particular record:
select * from myTable where record_id != 10;
Or, to avoid displaying multiple records:
select * from myTable where record_id not in (1, 2, 3, 8, 9);
Actaully you should be able if you delete it from the dataset without ever updating the dataset back to the server. I do believe.