Retrieving data value

[fkheng]

Apart from obtaining a value using blabla.getString(0) for example, are there other ways of obtaining it (other syntax?) for example by specifying the field name instead?

[Robby]

Do you mean the value field of say a dropdown? If so, use the SelectedItem.Value method.

[fkheng]

er......not a dropdown

but a value from a database field...

[wyrd]

Well what is blahbla? Is that a xxxDataReader or..? You can use xxxDataReader["column"]; (note that it returns an object)

[fkheng]

yeap

it is a datareader

i see...

thanx, just found out that i can do the same with a datarow in a dataset...

 

er.....i have another question

 

dr("UserName") = DirectCast(dr("UserName"), String).ToUpper

 

dr is a datarow

 

in my db, username is declared as a text type

is it necessary to convert it to a string type?

can i directly use it?

[wyrd]

If DataRow["column"] returns an object, then yes you should cast it before using it.

[Robby]

You can just use .ToString without the cast

[fkheng]

i see, so a data field in a datarow is generally viewed as an object?

so the field type which i state in the ms access database is not recognised in .net till i convert it?

like in my case, the field is of a text type in the database table, but i have to convert it to string before i can use it?

[wyrd]

I ment to cast it before using it, by that I mean manipulating the data in some way or to perform calculations. If you just want the value then object.ToString() should work (like Robby said)