Web Development

protected DataTable ExecuteDataTable(DbCommand command, ParamData[] pDataArr)
{
    DataTable returnValue = null;
    try
    {

        if (_connection == null)
            OpenConnection();
        else
        {
            if (_connection.State == ConnectionState.Closed)
                OpenConnection();
        }

        command.Connection = _connection;
        command.CommandType = CommandType.Text;
        command.CommandTimeout = 12000;

        //add Parameter
        for (int i = 0; i < pDataArr.Length; i++)
        {
            DbParameter parameter = command.CreateParameter();
            parameter.ParameterName = pDataArr[i].pName;
            parameter.DbType = pDataArr[i].pDataType;
            parameter.Value = pDataArr[i].pValue;
            command.Parameters.Add(parameter);
        }

        // Create a DataTable
        returnValue = new DataTable();

        DbDataReader reader;
        reader = command.ExecuteReader();

        using (reader)
        {
            // Fill DataTable
            returnValue.Load(reader, LoadOption.OverwriteChanges);
        }

        reader.Close();

        if (!KeepAlive && _connection.State == ConnectionState.Open)
        {
            CloseConnection();
        }
    }
    catch (Exception e)
    {
        if (e is EntryPointNotFoundException)
            throw e;
        _iserror = true;
        LogBLL bll = new LogBLL();
        bll.WriteErrorLog(e);
    }

    pDataArr = null;

    return returnValue;
}