asked on

deleting a DS

I have a rather large TABLE in a DATABASE with about 200 or so columns
part of my app calls a DS with about 50 of those columns in the SET
they are bound to a datagridview on a form, but the SET is not loaded for this chunk of code

what I want to do is DELETE the columns of the MAIN DATABASE TABLE of the smaller DS

?'s
Must I fill the dataset CLEAR ALL COLUMNS and the reupdate ?
How do I do this?

ElrondCT

I'm not entirely clear what you're asking. By "DS," do you mean a dataset? What do you mean by "the smaller DS"? Do you want to remove the columns of data from the actual database stored on disk? If so, how is the database stored on disk? Is it an Access database, SQL Server, Excel spreadsheet, or something else? Or do you simply want to blank out the values of those columns, so they can be used later? Keep in mind that if you delete the columns from the database, all your Select and Update commands will have to be rewritten.

Which version of Visual Basic are you using?

MBHEY131

ASKER

I just want to blank out the columns and reapply the set to the database
the smaller set is part of the main table in the database

ElrondCT

You may be able to execute global commands directly against the database (that is, a single command that applies to all records), rather than loading and updating by record. To do that, we need to know what kind of database you have (Access, SQL Server, etc.).

MBHEY131

ASKER

SQL SERVER

ASKER CERTIFIED SOLUTION

ElrondCT

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial