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.
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.