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.
"msnews" <an******@yahoo.com> wrote in message
news:uX*************@TK2MSFTNGP10.phx.gbl...

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.

[Ray Costanzo [MVP]]

prod.GetValues?

Ray at work

"msnews" <an******@yahoo.com> wrote in message
news:uX*************@TK2MSFTNGP10.phx.gbl...

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.

[Fabio Marini]

msnews wrote:

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!