i have two database addresses in my config.ini.
i am not confirm that which database address is valid for open but one is valid.
i want open connection which is valid but how to use in short code C#; i want write this code into short lines help ?
public void conect()
{
if (System.IO.File.Exists("config.ini"))
{
String[] INI = System.IO.File.ReadAllLines("config.ini");
for (int i = 0; i < INI.Length; i++)
{
if (INI[i].StartsWith("DBPATH_VPN"))
{
vpn_db = (INI[i].Substring(INI[i].IndexOf("=") + 1));
}
if (INI[i].StartsWith("PATHDB_VPN"))
{
db_vpn = (INI[i].Substring(INI[i].IndexOf("=") + 1));
}
}
}}
public void CollectVendas()
{
try
{
String path = string.Format("DataSource={0}; DataBase={1};User=SYSDBA; Password=masterkey", vpn, vpn_db);
FbConnection cnn = new FbConnection(path);
cnn.Open();
// here i want collect data from database.
}
catch
{
String path = string.Format("DataSource={0}; DataBase={1};User=SYSDBA; Password=masterkey", vpn, db_vpn);
FbConnection cnn = new FbConnection(path);
cnn.Open();
// here i want collect data from database.
}