Connection to the database with dataset

Question

hello all my problem is the database creation. when I create a connection to the database it shows me this error named: An error occured while converting the connection how to solve this problem?

abdelwaheb ammar · Answer

thank you to all who practice to help me i find the solution. the solution is here : http://shahvaibhav.com/solving-the-given-key-was-not-present-in-the-dictionary-error-of-visual-studio-2010/

abdelwaheb ammar · Answer

this show me the same error

Manas Mohapatra · Answer

Try below code: 	est.xlsx  providerName=System.Data.OleDb Extended Properties=Excel 12.0 Xml;HDR=YES /> Here I added the file name as test.xlsx - you can add it own.

abdelwaheb ammar · Answer

providerName=System.Data.OleDb />

Manas Mohapatra · Answer

Please provide your code how you are connecting to database.