/* new methods starts general methods */
public DataTable GetData(string SQL, string database)
{
try
{
StrCCon = CConnection.GetDMISConnectionString();
if (database == "DMIS")
{
StrCCon = CConnection.GetDMISConnectionString();
}
else if (database == "FAMSConnectionString")
{
StrCCon = CConnection.GetFamsConnectionString();
}
else
{
StrCCon = CConnection.GetConnectionString();
}
SqlDataAdapter dta = new SqlDataAdapter(SQL, StrCCon);
DataTable dt = new DataTable();
dta.Fill(dt);
return(dt);
}
catch (Exception e)
{
// msg = e.Message;
//GlobalVar.mErrorMessage = " Cretical connection Error cant continue ,please contact with concern person \n" + e.Message;
return(null);
}
}
