public List <T> CopyDataReaderToObjectList <T>(string aCommandString, DataParameter aSqlParameter, CommandType aCommandType, bool doNotCloseDataReader = false)
{
return(CopyDataReaderToObjectList <T>(GetSqlDataReader(aCommandString, aSqlParameter, aCommandType), doNotCloseDataReader));
}
public object GetScalarValue(string aCommandString, CommandType aCommandType, DataParameter aSqlParameter)
{
IList <DataParameter> sqlParam = new List <DataParameter>();
sqlParam.Add(aSqlParameter);
return(GetScalarValue(aCommandString, sqlParam, aCommandType));
}
public DataListItem GetDataListItemSingleRow(string aCommandString, DataParameter aDataparameter, CommandType aCommandType)
{
SqlDataReader _dataReader = GetSqlDataReader(aCommandString, aDataparameter, aCommandType);
return(GetDataListItemSingleRow(_dataReader));
}
public DataTable GetDataTable(string aCommandString, DataParameter aSqlParameter, CommandType aCommandType)
{
return(GetDataSet(aCommandString, aSqlParameter, aCommandType).Tables[0]);
}
public SqlDataAdapter GetSqlDataAdapter(string aCommandString, DataParameter aSqlParameter, CommandType aCommandType)
{
_sqlCommand = GetCommandObject(aCommandString, aCommandType, aSqlParameter);
return(new SqlDataAdapter(_sqlCommand));
}
public SqlDataReader GetSqlDataReader(string aCommandString, DataParameter aSqlParameter)
{
return(GetSqlDataReader(aCommandString, aSqlParameter, CommandType.Text));
}
public SqlCommand GetCommandObject(string aCommandString, CommandType aCommandType, DataParameter aSqlParameter)
{
List <DataParameter> sqlParam = new List <DataParameter>();
sqlParam.Add(aSqlParameter);
return(GetCommandObject(aCommandString, aCommandType, sqlParam));
}
public SqlCommand GetCommandObject(string aCommandString, DataParameter aSqlParameter)
{
return(GetCommandObject(aCommandString, CommandType.Text, aSqlParameter));
}