How can I get one field from a row from the DB? [Archive]

Click to See Complete Forum and Search --> : How can I get one field from a row from the DB?

RY33

February 4th, 2003, 07:03 AM

How can I get one field from a row from the DB?
I have a select query which brings me one row with one column.
How can I put this information in a String object?

pareshgh

February 4th, 2003, 11:52 AM

use SqlDataReader to get results
and perform its Read method in a loop so that you get each row.

its .GetValue(index) should return the field value(column value)

Paresh