Sunday, March 1, 2009

Connection string in web.config asp.net c#

We can also specify connection string in our web.config file.
In asp.net 1.1 we can specify connection in 2 ways
1) In AppSettings
<appSettings>

<add key="ConnectionInfo" value="server=servername;uid=userid;pwd=password;Initial Catalog=database"/>
<appSettings>

2)connectionStrings
<add connectionString="Server=severname;Database=DB;UID=userid; pwd=password;" name="conn" providerName="MySql.Data.MySqlClient;"/>
</connectionStrings>

No comments:

Post a Comment