In my project I have defined a series of DataAdapter that in turn use each one of them a DataSet.
My problem is that I use a connection string that I need to change for code, and when I make a change in the database, or I have to add some field I have to change the connection string manually in the code that VB.NET generates, I also have problems with the numeration of the DataSet, VB.NET changes the numeration to DataSet 1, DataSet2.................
On the other hand the changes have to also reflect them in the procedures stored with what any change becomes a hell for my.
Does some form exist of avoiding this?
Which the best technique is to make changes in the database and to maintain up-to-date the code?