public static string get_connetion()
{
CfgDTO oCfgDTO = new CfgDTO();
oCfgDTO = InitializeCFG();
return(oCfgDTO.con);
}
public static CfgDTO InitializeCFG()
{
try
{
CfgDTO cfgDetails = new CfgDTO();
DataSet dbConDataSet;
#pragma warning disable CS0168 // The variable 'database' is declared but never used
string database;
#pragma warning restore CS0168 // The variable 'database' is declared but never used
string dataSource = string.Empty;
string userID = string.Empty;
string password = string.Empty;
string initialCatalog = string.Empty;
string con = string.Empty;
#pragma warning disable CS0168 // The variable 'oSqlConnectionStringBuilder' is declared but never used
SqlConnectionStringBuilder oSqlConnectionStringBuilder;
#pragma warning restore CS0168 // The variable 'oSqlConnectionStringBuilder' is declared but never used
dbConDataSet = new DataSet();
dbConDataSet.ReadXml(@"C:\int\CONFIG.CFG");
database = dbConDataSet.Tables[0].Rows[0]["Database"].ToString();
dataSource = dbConDataSet.Tables[0].Rows[0]["DataSource"].ToString();
userID = dbConDataSet.Tables[0].Rows[0]["UserID"].ToString();
password = dbConDataSet.Tables[0].Rows[0]["Password"].ToString();
initialCatalog = dbConDataSet.Tables[0].Rows[0]["InitialCatalogue"].ToString();
con = dbConDataSet.Tables[0].Rows[0]["con"].ToString();
cfgDetails.DataSource = dataSource;
cfgDetails.UserID = userID;
cfgDetails.Password = password;
cfgDetails.InitialCatalog = initialCatalog;
cfgDetails.con = con;
return(cfgDetails);
}
catch (Exception ex)
{
return(null);
}
}
