Hi, I have a Dataset with many TableAdapters. Each TableAdapter has a property connection. The problem occurs when I will transfer my project to another computer and I cannot edit the TableAdapters because its connection is linked to the connection string of my other computer. Is there a way (code) to loop all TableAdapters so that I can change the connection property?
Connection to DB
- Thread starter missshhhh
- Start date
Atanas Vanchev
Active member
- Joined
- Nov 7, 2006
- Messages
- 33
- Programming Experience
- 5-10
Are you storing your connection information in the Web.config or an App.config file? If not then you should do so and then update those files.
cjard
Well-known member
- Joined
- Apr 25, 2006
- Messages
- 7,081
- Programming Experience
- 10+
Look at the "ConnectionString" entry in the Settings area of the project properties.Note that if youre having these p[roblems, you should sort out your conenction string properly by removing all machine-specific references because these errors SHOULDNT occur.. It should not require developer intervention to get the database working every time an app is installed on a new machine
