using connection stirng

[aradhanathawait]

hi....

How to use the connection string specified in app.config file in a windows form in c#. Please help.

Regards,
Aradhana

[teddarr]

include using System.Configuration;

Then put your connection string in the web.config file in the connectionStrings node.

example:

<add name="nameOfConString" connectionString="Server=serverName;Database=DbNam e;" providerName="System.Data.SqlClient"/>

After that you will need to add a reference to either Windows.Configuration or System.Configuration.

After that add a line in your class to give a global variable, or declare it in each method, or the constuctor...whichever you prefer.

The line is:

Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrin gs("nameOfConString").ConnectionString)

or

SqlConnection conn = ConfigurationManager.ConnectionStrings("nameOfConS tring").ConnectionString;

It's a very handy technique that you will find yourself using from here on out.

[Curtis Rutland]

in C# that would be:

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["name"].ConnectionString;

[teddarr]

see what vb is doing to my brain.

Thanks for the correction. :)