Deleting rows

[joethecool1]

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?

[CVMichael]

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);

[robdotnet00]

Actaully you should be able if you delete it from the dataset without ever updating the dataset back to the server. I do believe.