/* 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); } }