VB.NET DataSet

Question

Can I create multiple DateSets from a single database table in VB.NET? I am building different user interfaces where each user interface (Form) will display a different data. What is the best way to do this?

Karthikeyan Anbarasan · Answer

Best option is use a single dataset with n number of datatables to it... so that u can bind it with the datatable required...

Martin van Eerde · Answer

Yes there is nothing stopping you having multiple DataSets don't forget a database can hold data from more than one table as well as any relationship between the tables. Are your views displaying different data or just a different view of the same data. I think you need to have a look at the Model View Controller pattern although this pattern is mostly implemented in web applications it is applicable for all types of development http://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller http://msdn.microsoft.com/en-us/library/ff649643.aspx