Hello,

I have a connection string in my web.config file <add name = ...> you know when you configure your gridview I clicked yes when it prompted me whether to save it in the web.config file or not.

I would like to insert a row into the same table.  Do I have to create the connection string again?  SqlConnection cn = .... Or is it self implied?  Or how do I access the connection string that was added in the web.config file?

 Thank you.

I am guessing you did it in the browser so to use it again it will prompt you when populaing another control whether to use the same connection or not.  Otherwise you can access it by creating a connection object and using this path ConfigurationSettings.appSettings("ConnectionString").ToString()

 to get a connection string from your web.config use

string connStr = ConfigurationManager.ConnectionStrings["ConnectionStringName"].ConnectionString;

And you do not need to recreate your connection string again on your web.config.

But of course if you are creating a SqlConnection object, you just need to get your connection string to pass it to your SqlConnection instance because this is not done automatically.

no need . u can access the connectionstring from web.config

System.Configuration.ConfigurationManager.AppSettings("ConnectionString")

Thank u

Baba

Please remember to click "Mark as Answer" on this post if it helped you. 

Using Connection string in webconfig

string conn = (string)ConfigurationSettings.ConnectionStrings["ConnectionString"];

or if you are using appSettings in your Webconfig then you can have something like this

System.Configuration.ConfigurationManager.AppSettings["Connection String Key Name"]; 

for more informations you can google the word "web config connection string" to obtain more results

Hope my suggestion helps. 

Include the namespace into class file 

 using System.Configuration;

add the following code to retrieve the namespace

                string constring = ConfigurationManager.AppSettings["ConnectionString"];

                con = new SqlConnection(constring) ;