Loading Database by Open File Dialog
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 ChandPosted Nov 8, 2012, 11:16 AM
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/