DataReader

[patrick]

newbie-question

i have a table with 2 rows and 4 columns. i'm using a datareader for
performance reason. now i would like to assign to a textfield a value from
this datareader, i.e

if value in record1/field1 = bla then
textfield.text = row1.field4
end if

how can i do this?

 

[PeterKellner]

newbie-question

i have a table with 2 rows and 4 columns. i'm using a datareader for
performance reason. now i would like to assign to a textfield a value from
this datareader, i.e

if value in record1/field1 = bla then
textfield.text = row1.field4
end if

how can i do this?

Here is some example code.
while (sqlDataReader.Read())

{

textfield.text = sqlDataReader.IsDBNull(0) ? string.empty :
sqlDataReader.GetString(0);

}