How to pass SqlDataReader row

[msnews]

Hi All,

I have the following code

------------------------------------------------
Business.Prod prod = new Business.Prod();
SqlDataReader Product = prod.GetProducts();

while (prod.Read())
{
Response.Write(BuildProduct("PASS THE ROW");
}


private string BuildProduct("ACCEPT ROW")
{
//"READ COLUMNS IN ROW"
}
------------------------------------------

Basically, I want to read every row and pass it to the BuildProduct method.
I am not sure how to pass the row, accept it and read the columns.

Please help.

Thanks in Advance.

 

[Vaibhav]

have you tried using DataRow as an argument to the 'BuildProduct' procedure
and then in loop through the columns.

 

[Ray Costanzo [MVP]]

prod.GetValues?

Ray at work

 

[Fabio Marini]

while (prod.Read())
{
Response.Write(BuildProduct("PASS THE ROW");
}

Try:
while (prod.Read())
{
Response.Write(BuildProduct(prod);
}

private string BuildProduct("ACCEPT ROW")
{
//"READ COLUMNS IN ROW"
}

and:
private string BuildProduct(IDataReader dr)
{
// return value in column called col1
return dr["col1"].ToString();
}

Have fun!