Interview Question in SQL Server Management Studio


 

Interview Question :: Data access in Visual Basic 2005


I am moving from VB 6 to Visual Studio 2005.
How can I write code which is path independent (for MS Access) and server-independent (for SQL Server) i.e where the user can enter the path of the database and the SQL Server at runtime, which will be passed to the connection string.
Answers to "Data access in Visual Basic 2005"
RE: Data access in Visual Basic 2005?

construct your connection string in your submitButtonName_click event and append the user provided parameters to your connection string.




 
Vote for this answer ::  
Update Alert Setting