Question Visual Studio 2010 express

[Mow]

Hi all , hope you can help .

I am new to development in visual studio and have the following problem.

visual studio express 2010 allows you to set databindings in the gui. This is a really nice feature that greatly simplifies work. However connections to excel data using the connection string :

("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & sFile & ";Extended Properties=""Excel 12.0 Xml;HDR=YES""")

is not supported and needs to be coded manually . Is there a way I can manually set a connection string for use within this bindingsmanager ? So that i can use the GUI to Manage data properties ?

Your help in this matter would be greatly appreciated.

If i am not clear please notify me so that I can try to clarify my request.

 

[JuggaloBrotha]

Store the connection strings in the My.Settings, then in code set the BindingSource's Connection's ConnectionString to use whichever on from My.Settings you need it to use.