There are a couple of ways of doing this that I can think of.
1. You can create two independent dataset that are filled with same data. This will require two trips to server.
2. You can create one dataset and use DataSet.CopyTo() method to create a duplicate dataset. This will be more efficient way to do it.
>Hi, all,
>
>I'm working on an vb.net app with a sql2000 database that will require double entry for a table and a copy of the table. In the FoxPro version I'm converting from, this was pretty straightforward, I just opened the dupe table as an alias and used the same form for both.
>
>What's the best way to use similar indirection on a dataset with bound controls to accomplish the same thing without doing two forms?
>
>Thanks.
- Jayesh