connectionStrings

[SaharMoj]

i need help with this subject. i want to set connectionString in web.config. don`t know how!

[John ph]

http://www.dotnetjohn.com/articles.aspx?articleid=3[^]

Regards
J O H N :rose:
"Even eagles need a push." David McNally

---

[Vasudevan Deepak Kumar]

http://msdn2.microsoft.com/en-us/library/ms178411.aspx[^]

Vasudevan Deepak Kumar Personal Homepage Tech Gossips

[Michael Sync]

ASP.NET 1.1

<appSettings>
<add key="ConnectionInfo" value="server=(local);database=Northwind;Integrated Security=SSPI" />
</appSettings>

Reading this string from code ~ ConfigurationSettings.AppSettings["ConnectionInfo"]; ASP.NET 2.0,

<connectionStrings>
<add name="YourConnectionString" connectionString="Data Source=YourSQLServer; Initial Catalog=YourDatabase; User ID=YourUserID; Password=YourPassword" providerName="System.Data.SqlClient" />
</connectionStrings>

Reading this string from code ~ if (((ConfigurationManager.ConnectionStrings("YourConnectionString") == null) || _)) { ConfigurationManager.ConnectionStrings("YourConnectionString").ConnectionString.Trim() = ""; throw new Exception("Connection Error"); } else { conn.ConnectionString = ConfigurationManager.ConnectionStrings("YourConnectionString").ConnectionString; }

Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)

[Ahmad Adnan]

if u mean that u wanto to edit the ConnectionString within the code(Dynamiclay) u couldn't only by the web configuration tool or manual regrds

[Paul Conrad]

Add www.connectionstrings.com[^] to your bookmark. It is very helpful and can be of use if you work with numerous different databases.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

[Abolfazl Sheikhloo]

salam kheyli khoshhal shodam ke tedade iraniha dar in talar har ruz bishtar mishe. va amma moshkele shoma: shoma mitavanid dar file web.config yek klid mesle: ijad konid , jahate estefade az an: private SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["connectionName"]); dar har gesmat az code garar dahid. dar zemn behtare ruye foldere Bin right click karde va componente System.Configuration ra add konid. My Real Email: abolfazl585@yahoo.com We Can Do Anything, If We Want It