Store and Retrive Connection string from INI file or Configuration file.

Here I will explain how to store or retrive connection string in INI file or Configuration file.


Add this namespace.

using System.Runtime.InteropServices;
using System.Text;


Add  this code on your page.

[DllImport("kernel32", CharSet = CharSet.Unicode)]
static extern int GetPrivateProfileString(string Section, string Key, string Default, StringBuilder RetVal, int Size, string FilePath);


[DllImport("kernel32")]
static extern long WritePrivateProfileString(string section, string key, string val, string filePath);

public void Write(string section, string key, string value)
{
     WritePrivateProfileString(section, key, value, System.Web.HttpRuntime.BinDirectory + "Config.ini");
}


For Write in .ini file.
Write("config", "IP", IP);
Write("config", "DB", DB);
Write("config", "U", Username);
Write("config", "P", Password);

Sample Config.ini File
[config]
IP=jGBat3KKrWH4WtaNN/jQR+zNQ91eIRdFvR5RDWjxicv90lvYrfGqDIO+XxAD5TON
DB=dshfjdshfkjsd+
U=fNu2o78fGJtGI
P=+r5tUDo4tpQ



For retrive value from .ini file.

string Str = "";
var RetVal = new StringBuilder(255);
GetPrivateProfileString("config", "DB", "error", RetVal, 255, System.Web.HttpRuntime.BinDirectory + "Config.ini");

string DB = RetVal.ToString();
GetPrivateProfileString("config", "IP", "error", RetVal, 255, System.Web.HttpRuntime.BinDirectory + "Config.ini");

string IP = RetVal.ToString();
GetPrivateProfileString("config", "U", "error", RetVal, 255, System.Web.HttpRuntime.BinDirectory + "Config.ini");

string U = RetVal.ToString();
GetPrivateProfileString("config", "P", "error", RetVal, 255, System.Web.HttpRuntime.BinDirectory + "Config.ini");

string P = RetVal.ToString();
Str = "Connect TimeOut = 0; Data Source =" + IP + "; Initial Catalog = " + DB + "; User Id = " + U + ";Password=" + P + "; Persist Security Info = True";