public StatDAL() { db = new DBConnect(); }
public ActualiteDAL() { db = new DBConnect(); }
/// <summary> /// GetInfoSet - Fetch the mutliple record from the database based on SQL Query /// </summary> /// <param name="sQuery">String</param> /// <returns>DataSet</returns> public static DataSet GetInfoSet(string sQuery) { DBConnect obj; DataSet ds = null; try { obj = new DBConnect(); ds = obj.FetchMultipleTable(sQuery); } catch { ds = null; } finally { obj = null; } return ds; }
/// <summary> /// GetInfoById - Fetch the Single record from the database based on SQL Query /// </summary> /// <param name="sQuery">String</param> /// <returns>DataRow</returns> public static DataRow GetInfoById(string sQuery) { DBConnect obj; DataRow dr = null; try { obj = new DBConnect(); dr = obj.FetchSingleRecord(sQuery); } catch { dr = null; } finally { obj = null; } return dr; }
/// <summary> /// GetInfo - Fetch the mutliple record from the database based on SQL Query /// </summary> /// <param name="sQuery">String</param> /// <returns>DataTable</returns> public static DataTable GetInfo(string sQuery) { DBConnect obj; DataTable dt = null; try { obj = new DBConnect(); dt = obj.FetchMultipleRecord(sQuery); } catch { dt = null; } finally { obj = null; } return dt; }
public Log4NetDAL() { db = new DBConnect(); }