assigning a database value to a string.

[Asgill]

hi...

can someone tell me how do i assign a value to a string to do further processing...so far i've done this

oleDbDonnection1.Open();

oleDbDataAdapter.SelectCommand.CommandText = ......

string UserType = (string) oleDbDataAdapter.SelectCommand.ExecuteScalar(); // is this correct...the usertype column is not the first column its the third column...

UserType.ToString();

[Tewl]

i dont know much about ado .net but wouldnt you fill a dataset an pull the value from it?

[hellswraith]

ExecuteScalar only returns one value, which is the first value in the first row of the result set that is returned from the query.

So, if what you want is the third value in your query, you will never get it with ExecuteScalar.

Either adjust your CommandText to get just the one value, or you need to ExecuteReader or ExecuteDataset and manually map to the column you are looking for.