Category: Database

Nov 07 2009

How to add Winform connection string in app.config

Open App.config File in Project Solution Explorer write connectionString using appsettings

<?xml version=”1.0″ encoding=”utf-8″ ?>
<configuration>

<configSections>
<sectionGroup name=”applicationSettings” type=”System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ >
<section name=”WinFormApp.Properties.Settings” type=”System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ requirePermission=”false” />
</sectionGroup>
</configSections>
<appSettings>
<add key=”ConnectionString” value=”Persist Security Info=False;Data Source=lokesh;Initial Catalog=winForms;User ID=sa;Password=xyz;” />
</appSettings>

<applicationSettings>
<WinFormApp.Properties.Settings>
<setting name=”WinFormApp_localhost_Service1″ serializeAs=”String”>
<value>http://localhost:2557/Service1.asmx</value>
</setting>
</WinFormApp.Properties.Settings>
</applicationSettings>
</configuration>

ConnectionString is the name of the connection used to retrieve connection into class files and form files

DataSource=lokesh: It is the Database server name if you are using localhostthen DataSource=localhost/SQLEXPRESS

Initial Catalog=winForms: Winform is Database name

Getting app.config file connection string into Class file

using System.Data.SqlClient;
using System.Configuration;
//add this namespace

SqlConnection objConn = new SqlConnection(ConfigurationSettings.AppSettings["ConnectionString"]);
SqlCommand objCmd = new SqlCommand(”select *from tblCategory”, objConn);


Alibi3col theme by Themocracy