how to create connection string in App.config for windows applications

Question

1.00/5 (1 vote)

See more:

this is the connection string to get data in the windows application. am getting the data but when i use this application in the another system getting the error

string opera = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + @"\Opera Software\opera stable\History";

SQLiteConnection con = new SQLiteConnection("DataSource=" + opera + "; version=3; new =false;compress=true;"

Posted 22-Dec-14 18:25pm

Srikanth59

Updated 22-Dec-14 19:13pm

v2

Add a Solution

Comments

Praveen Kumar Upadhyay 23-Dec-14 1:12am

What error are you getting?

Srikanth59 23-Dec-14 1:18am

System.IO.FileNotFoundException: Could not load file or assembly 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.

Srikanth59 23-Dec-14 1:36am

Is There any another way without copy dll's files in the local environment

Praveen Kumar Upadhyay 23-Dec-14 1:44am

You need to copy the dlls to the production server into the exe folder.

Maciej Los 23-Dec-14 2:14am

Connection string is wrong. You forgot to add at the end of string the file name ;)
opera = "...\YourDatabase.db";

Srikanth59 23-Dec-14 2:26am

the database is in SQlite,i added the reference to the project but how to create the connection string in the app.config, am getting in my system but when i deployed its not working can you show me the connection setting

Maciej Los 23-Dec-14 2:32am

I'm not get you...
What framework: WPF, WinForms, WebControls?

Srikanth59 23-Dec-14 4:54am

winforms i created the application in c#, i got the browser history files in the datagridview now i want to clear all the history

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Praveen Kumar Upadhyay · Answer 1 · 2014-12-22T19:25:00

Solution 1

You need to copy below dll into the exe folder where it is deployed. These dlls you must be having in your local environment.
System.Data.SQLite.Linq.dll
System.Data.SQLite.DLL

Posted 22-Dec-14 19:25pm

Praveen Kumar Upadhyay

Maciej Los · Answer 2 · 2014-12-22T20:33:00

Solution 2

Please, read my comment to the question.

Here is an idea: Connection Strings and Configuration Files[^]

Posted 22-Dec-14 20:33pm

Maciej Los

ananth.gopal · Answer 3 · 2014-12-23T23:53:00

Hi....
add this below text to app.config in windows application

<configuration>
<connectionstrings>
<add>
name="sqlCon" connectionString="Data Source=Your Sql Server Name;Initial Catalog=Your DataBase Name;User ID=Your SQL user ID;Password=Your SQL Password" />

add below code to cs page
System.Configuration.AppSettingsReader settingsReader = new System.Configuration.AppSettingsReader();
string sConnectionString = (string)settingsReader.GetValue("sqlCon", typeof(string));

now u will get the connectionstring in sConnectionString variable ....

by
anantH.g