Opening connection to db

[John]

Hi

I have the following connection info in my web.config file;

<connectionStrings>
<add
providerName="System.Data.SqlClient" connectionString="Data
Source=MySQLServer.net;Initial Catalog=&quot;MyDB&quot;;Persist Security
Info=True;User ID=&quot;UID&quot;;Password=MyPassword" name="Events" />
</connectionStrings>

How can I open a connection to this db in my code?

Thanks

Regards

[Iaml]

On May 31, 11:42 pm, "John" <[e-mail]:

Hi

I have the following connection info in my web.config file;

<connectionStrings>
<add
providerName="System.Data.SqlClient" connectionString="Data
Source=MySQLServer.net;Initial Catalog=&quot;MyDB&quot;;Persist Security
Info=True;User ID=&quot;UID&quot;;Password=MyPassword" name="Events" />
</connectionStrings>

How can I open a connection to this db in my code?

Thanks

Regards

This following article will help you:

http://msdn.microsoft.com/en-us/library/ms998300.aspx

[Peter Bromberg [C# MVP]]

SqlConnection conn = new
SqlConnection(ConfigurationManager.ConnectionStrin gs["Events"].ConnectionString);
conn.Open();
--Peter
"John" <in**@nospam.infovis.co.ukwrote in message
news:uF**************@TK2MSFTNGP04.phx.gbl...

Hi

I have the following connection info in my web.config file;

<connectionStrings>
<add
providerName="System.Data.SqlClient" connectionString="Data
Source=MySQLServer.net;Initial Catalog=&quot;MyDB&quot;;Persist Security
Info=True;User ID=&quot;UID&quot;;Password=MyPassword" name="Events" />
</connectionStrings>

How can I open a connection to this db in my code?

Thanks

Regards