Visual basic.net using rows in sql server tables

[Elizabeth]

In a visual basic.net 1.1 windows application, I need to pass required and
optional values from a sql server 2000 table for a windows application to
process. Each of the 250 columns in the sql server 2000 database table are
options on how a windows application with process. The user will pick all the
options they want and then hit a submit button.
I am trying to decide how to pass all these options to the business logic
layer that will do the acutally processing. Each row in the sql server 2000
database contains the 250 optional ways for processing. Would it be better to
pass these values in a collection, struct, serialization, and/or some other
way? Would you show me some code and/or url on how to accomplish this task?

Thanks!

[Cor Ligthert [MVP]]

Elizabeth,

In the language.vb newsgroup is at the moment an almost actual the same
question from Mike.

I have to compose a message to him that takes more time. However my first
thought is a datagrid that holds al your rules with a bool (checkbox) column
in it.

You can fill that than up first with the rules that already apply from a
table from every user.

Than that one can be processed as soon as the user has pushed a button to
process.

Probably I will make a sample, however that depends how much time I have
today.

Just my first thought,

Cor

[Cor Ligthert [MVP]]

Elizabeth,

This is the result from the sample I made for mike.

http://www.vb-tips.com/default.aspx?...4-d5f9861ba534

Maybe you can use it as well.

Cor