DataView Vs DataTable in vb.net - what to choose ?
Posted on 2004-04-25
hi to all
i am new to vb.net.i need some help in binding the controls to the dataset in ado.net.
i want to attach comboboxes in my form with the through displaymember and valuemember properties to the tables.
suppose as a test case if i have 2 combos for dept,desig. when ever i select a particular dept then the desig combo should show only the designations in that dept dynamically.
i can't attach the original table directly as the rows in the original disig table changes dynamically ...
for this if i manually add these values dynamically through a datareader into these combos then settng the valuememeber values will be difficult (may not be possible).and these combos are not bound then the changes to the table will not be refreshed automatically.
At present i am creating one temporary table for each of these combos (here it requires 2 tables) and fill the data rows that match the crieteria through an adaptor.(not attaching the original tables)
its working fine. "but i am concerned about the performance and optimization of my application.
Is this approach is correct. or is it better to use views in place of tables.
"will it consume less memory than the tables cosume" ?.
Or is there any other way to achieve this task ?
any body please help me out.
thanx in adv.