dc

dc

  • NA
  • 663
  • 0

C#.net working with data adapter designer

Jul 17 2011 6:03 PM
I am modifying a C#.net 2008 windows forms application, and I have the following questions about using the designer when working with data adapter tables designer.

**Note: what I am working on is having a production database change. I am going to use the same desktop application. I just need to change tables and/or columns when it is appropriate.

1. In one table adpate, a new table is going to replace the orginal table. The table names are different and the column names are different, but the two tables basically contain the same data. I want to use the same table adpter, but point to the new table. The designer will not let me remove all columns from the original table. Thus, I would like to know what you suggest I do.

2. One main table is being broken up into 5 tables since the original table  contained so many columns. Thus my plan is to  join all the new tables together into one tableadapter (the original way).  Basically I will use the one original data adapter, to limit the amount of code changes I will have. Thus,is this a good idea? How would you accomplish this task?