Designing a Dataset

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Dear Experts,

Good Afternoon, May you please help us with this issue. We're using VB.NEt 2005.

Which dataset is better in terms of Design, Flexibility and Speed in Processing. Will you please rank them based on the criteria I gave you and Give us

A. System that consist only 1 Dataset and containing all Datatables with relationship designed from an SQL Database.
* All Datatables were previously Filled

B. System that consist only 1 Dataset and containing all Datatables with relationship designed from an SQL Database.
* Selected or Needed Datatables were previously Filled and Called by

C. System that consist of 1 Dataset for every Form and Containing Only Needed and Selected Datatables with relationship specifically Configured and accessed by Specific Forms that needs the data
* Selected Datatables were previously Filled


D. System that consist of Many Dataset for very Form and Containing Only Needed and Selected Datatables with relationship specifically Configured and accessed by Specific Forms that needs the data
* Selected Datatables were previously Filled


Thanks in advance for your reply..

Regards,

Alvin

.