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