How i Define Connection String in any class file

सौरभ माहेश्वरी

11y1.2k

Dear Sir/Mam

Please tell me how can i define connection string in my class file.i do not want to describe it in web.config for Database Security.

//SqlConnection mainConnectionString = new SqlConnection();

string str = "server=192.1.1.1;database=db;user id=sa;password=.com;";

SqlConnection mainConnectionString = new SqlConnection(str);

// mainConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

// mainConnectionString.ConnectionString=("server=192.1.1.1;database=db;user id=sa;password=.com;").ToString();

string sam =Convert.ToString( mainConnectionString);

i use all this thing but project not working but if use

// mainConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

ConnectionString from web.config

then its working fine.

please tell me how i solve this problem or any alternative to secure dB USER and password.

or any decrypt or encrypt method use for web.config.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sanjay Sabariya11y ago
you can try this

ConnectionString ="Data Source=sourcename;Initial Catalog=YourdatabaseName;id=id;password=pwd;Integrated Security=True;" ;
0
Nilesh Jadav11y ago
Hello there!

Try this -

You can get your Connection String by going to the database (In Server Explorer right-click on you database then select"Properties". You will then see “Connection String” there. Copy it and paste it into the SQL connection field. Yeah! Surely your connection string is quite different from mine, initially it look like this:

Before
"Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Users\Nilesh\Documents\Visual Studio 2010\WebSites\WebSite13\App_Data\Database.mdf";Integrated Security=True;User Instance=True"
You need to remove the path and make it short like:

C:\Users\Nilesh\Documents\Visual Studio 2010\WebSites\WebSite13\App_Data -- > Remove this

And add this "|DataDirectory|".

After
@"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True"
0
Rajeesh Menoth11y ago
Hi,

Ref this : http://www.codeproject.com/Articles/4416/Beginners-guide-to-accessing-SQL-Server-through-C
0
सौरभ माहेश्वरी11y ago
Lalit Sir its not working.when i use this Con in otherpage its shows null refernce.
0
Lalit Raghav11y ago
You can write you connection string in you class as

SqlConnection con = new SqlConnection("Data Source=192.1.1.1;Initial Catalog=db; user id=sa;password=.com; Integrated Security=True");

then wrte sqlcommand/other operation

if you feel that is help full .Please accept this answer .
0