/*----------------------------------------------------------------------------- | Function GetDataTable: Return DataTable | -----------------------------------------------------------------------------*/ public static DataTable GetDataTable(string strSQL, string strConn) { DataTable Returndt = null; DataTable dt = new DataTable(); ClassFunction_Eform.ConnectDatabase Conn; if (strConn == "") { Conn = new ClassFunction_Eform.ConnectDatabase(System.Configuration.ConfigurationManager.ConnectionStrings["Myconnect"].ConnectionString); } else { Conn = new ClassFunction_Eform.ConnectDatabase(System.Configuration.ConfigurationManager.ConnectionStrings[strConn].ConnectionString); } try { Conn.OpenDatabase(); dt = Conn.GetData(strSQL); if ((dt == null)) { dt = null; } else { if (dt.Rows.Count == 0) { Returndt = null; } else { Returndt = dt; } } } catch (Exception ex) { Conn.RollbackDatabase(); throw ex; } finally { Conn.CloseDatabase(); } return(Returndt); }