/// <summary> /// Returns a DataTable with rows from stored procedure. /// Use this function when you need to increase the default db timeout value. /// (DB timeout default value is 60sec) /// </summary> /// <param name="storedProcedureName">stored procedure name</param> /// <param name="param">hashtable list of parameter name, parameter value.</param> /// <param name="timeOutSeconds">db timeout value in seconds.</param> public static DataTable ExecuteDataTable(string storedProcedureName, Hashtable param, int timeOutSeconds) { DataAccessObject dao = new DataAccessObject(); dao.TimeOutSeconds = timeOutSeconds; return(dao.GetDataTable(storedProcedureName, param, timeOutSeconds)); }
/// <summary> /// Returns a DataTable with rows from stored procedure. /// Use this function when you need to increase the default db timeout value. /// (DB timeout default value is 60sec) /// </summary> /// <param name="storedProcedureName">stored procedure name</param> /// <param name="param">hashtable list of parameter name, parameter value.</param> /// <param name="timeOutSeconds">db timeout value in seconds.</param> public static DataTable ExecuteDataTable(string storedProcedureName, Hashtable param, int timeOutSeconds) { DataAccessObject dao = new DataAccessObject(); dao.TimeOutSeconds = timeOutSeconds; return dao.GetDataTable(storedProcedureName, param, timeOutSeconds); }
/// <summary> /// Returns a DataTable with rows from stored procedure. /// Use this function when the stored procedure requires only one parameter /// </summary> /// <param name="storedProcedureName">stored procedure name</param> /// <param name="param">the MySqlParameter required by the sproc</param> public static DataTable ExecuteDataTable(string storedProcedureName, MySqlParameter param) { DataAccessObject dao = new DataAccessObject(); return dao.GetDataTable(storedProcedureName, param); }
/// <summary> /// Returns a DataTable with rows from stored procedure. /// Use this function when the stored procedure requires only one parameter /// </summary> /// <param name="storedProcedureName">stored procedure name</param> /// <param name="param">the MySqlParameter required by the sproc</param> public static DataTable ExecuteDataTable(string storedProcedureName, MySqlParameter param) { DataAccessObject dao = new DataAccessObject(); return(dao.GetDataTable(storedProcedureName, param)); }