switching dataset for windows form

• Question

• 

  

  0

  Sign in to vote

  Hi, All!

  I got the following scenario and I'm looking for an elegant solution.

  Database structure:

  There are two tables in SQL server. The second table have the same columns as the first table and some additional columns. The purpose of the second table is to allow records from the first  table to be moved to the second one. The reason for that is to keep the first table in a reasonable size.

  Code:

  I created a dataset for the first table and a windows form containing some controls.

  The controls are bounded to the dataset thru binding-source using visual studio designer.

  How can I switch the dataset used on the form,   from the first one to the second one???

  I'm trying to reuse the form I create for both datasets.

  • Edited by Lior83 Tuesday, May 12, 2009 2:19 AM

  Tuesday, May 12, 2009 2:18 AM