Loading Database by Open File Dialog

Question

I Want To Make A C# Windows Application(Quiz Module) Where 5 Question Sets Are in 5 .sdf database files. At run time one user can select any question set(.sdf file) and after opening that questions will appear in windows form. I have coded SqlConnection con = new SqlConnection(); con.ConnectionString = Data Source= + openFileDialog1.FileName; Initial Catalog=ques;Integrated Security=True;; con.Open(); But it shows an sql data exception. Please Help.

Mahesh Chand · Answer

Clearly your connections string is wrong. You need to see if Integrated Security is set otherwise you will have to pass SQL Server User ID and Password in your connection string. Here is an article: http://www.c-sharpcorner.com/uploadfile/nipuntomar/connection-strings-for-sql-server-2005/ If you do not know how to write connection string you can use Visual Studio to generate a string also. http://www.c-sharpcorner.com/uploadfile/suthish_nair/how-to-generate-or-find-connection-string-from-visual-studio/