disable row

[jds1207]

How do you disable rows in SQL using vb.net? jds1207

[Dave Kreskowiak]

Disable rows in a datbase table?? You don't. Using security in SQL Server, you can manage the access to the entire table, but not the individual rows.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
     2006, 2007

[nlarson11]

like Dave said, there is no "built-in" method. you can add a column to the table calling it "Enabled" or something and in your 'where' clause ask for all rows where Enabled=1

[Drew]

Well, I know you can do that sort of thing in a Janus GridEX by using conditional formatting. Maybe you can tell it to hide rows. I believe there is a trial version on the web somewhere. It is possible you could mean columns, which is easy from a datatable in VB.NET. If you really need to, use some special conditional formatting code and move the rows you do not want to a separate table.