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();