using System.Configuration;
using System.Web.Configuration;
using System.Net.Configuration; // gerekmeyebilir
yoksa ekliyoruz.
// connectionStrings e erişim
public static string GetConnKey(string key) // varsa değer yoksa null döndürür
{
if (WebConfigurationManager.ConnectionStrings[key] != null)
{
return WebConfigurationManager.ConnectionStrings[key].ConnectionString;
}
else
{
return null;
}
}
// düzenleme
public static bool SetConnValue(string anahtar, string deger) // bağlantı stringini set eder yoksa ekler :).anahtar boş olamaz!!!
{
try
{
Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringsSection connSettingsSection = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
ConnectionStringSettings ss = new ConnectionStringSettings();
ss.ConnectionString = deger;
ss.Name = anahtar;
ss.ProviderName = "System.Data.SqlClient";
if (string.IsNullOrEmpty(GetConnKey(anahtar)))
{
connSettingsSection.ConnectionStrings.Add(ss);
configuration.Save();
}
else
{
connSettingsSection.ConnectionStrings[anahtar].ConnectionString = deger;
configuration.Save();
}
return true;
}
catch
{
return false;
}
}
// kaldırma
public static bool RemoveConnKey(string key) // conn keyi web.config den kaldırır
{
try
{
Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~");
ConnectionStringsSection connSettingsSection = (ConnectionStringsSection)configuration.GetSection("connectionStrings");
if (GetConnKey(key) != null)
{
connSettingsSection.ConnectionStrings.Remove(key);
configuration.Save();
}
return true;
}
catch
{
return false;
}
}
Tags: connectionStrings