Visial Studio 2003 problem
Posted on 2005-04-28
i have problem and i dont know if its a limitation or a bug in visual studio. I am using asp.net with vb.net on an xp pro and visual studio 2003.
The problem is; when i oledbdataadapter in my web form the connection string is automatically created with it. But i want to use server.mappath in my connection string and the dataadapter wizard wont let this. So i m changing the connectionstring in codebehind but i m getting an error. Error doesnt effect anything and the page runs with no problem but anytime i change someting in the page design (adding a label or deleting a label...) the connection string clears out. If i configure it the way visual studio wants there is no problem.
My question is: is there a way to set the connectionstring property with server.mappath in design time or is there a way to stop visual studio clearing my custom string after something changes in the page? I can finalize everthing and then change the connection string to my custom string and build my application but i want to know if there is another proper way for this.
any help will be appreciated.