public static DataSet GenerateExport(int id, string query, string name) { DataSet ds = new DataSet(name); User user = (User)System.Web.HttpContext.Current.Session[Constant.session.User]; IDBManager dbmgr = new DBManager(user.plantDBStr); dbmgr.ConnectionString = user.plantDBStr; try { dbmgr.Open(); ds = dbmgr.ExecuteDataSet(CommandType.Text, query); ds.DataSetName = name; } catch (Exception ex) { throw (ex); } finally { dbmgr.Dispose(); } return ds; }