access SqlDataReader using foreach

[jarod1701]

Hi everyone,

is there a way to access every record from a SqlDataReader via
"foreach" ?
I want to write a class which (besides doing some other stuff)
retrieves a recordset using SqlCommand.ExecuteReader().

Something like:

MyDbClass db = new MyDbClass("SELECT * FROM tblUsers");
foreach(MyRecordClass record in db.getRecordSet())
{
Console.WriteLine(MyRecordClass["UserId"]);
}

I know this has something to do with GetEnumerator (which SqlDataReader
implements) but I don't know how to start or if it's possible at all.

I hope someone can help me out.

Thanks in advance,

Kevin

[sloan]

The syntax is:

IDataReader dataReader = // something to get an IDataReader
try
{
while (dataReader.Read())
{
if (!(dataReader.IsDBNull(0)))
{
Console.WriteLine(dataReader.GetString(0));
}
}
{
finally
{
if (!((dataReader == null)))
{
try
{
dataReader.Close();
}
catch
{
}
}
}

See full example at:


http://sholliday.spaces.live.com/blog/
5/24/2006 Entry
Custom Objects/Collections and Tiered Development

The CustomerController.cs file has it.

<ja*******@gmx.dewrote in message
news:11**********************@k70g2000cwa.googlegr oups.com...

Hi everyone,

is there a way to access every record from a SqlDataReader via
"foreach" ?
I want to write a class which (besides doing some other stuff)
retrieves a recordset using SqlCommand.ExecuteReader().

Something like:

MyDbClass db = new MyDbClass("SELECT * FROM tblUsers");
foreach(MyRecordClass record in db.getRecordSet())
{
Console.WriteLine(MyRecordClass["UserId"]);
}

I know this has something to do with GetEnumerator (which SqlDataReader
implements) but I don't know how to start or if it's possible at all.

I hope someone can help me out.

Thanks in advance,

Kevin

[Yury]

We use smth like List.ForEach:

public int ReadAll(SqlCommand cmd, Action<IDataRecordaction)
{
if (cmd == null)
throw new ArgumentNullException("cmd");

if (action == null)
throw new ArgumentNullException("action");

SqlDataReader reader = null;
try
{
OpenConnection(cmd);
reader = cmd.ExecuteReader();
while (reader.Read())
action(reader);
return reader.RecordsAffected;
}
finally
{
if (reader != null)
reader.Close();
CloseConnection();
}
}

and usage:
List<ProductTypeproducts = new List<ProductType>();

MainDB.ReadAll(cmd, delegate(IDataRecord record) {
ProductType pt =
(ProductType)Convert.ToInt32(record["ProductTypeId"]);
products.Add(pt);
});

also, you can replace delegate call with yield and use foreach then.