Get the GUID from a Dataset

Hi There

I've got the following problem. My Database (SQL 2000) uses Global Unique ID's as row ID's. At the moment I can retrieve these ID's with a datagrid using the datakeyfield and datakeys properties. This works great. But I now need to get the Guid of a certain row, without binding it to a datagrid first.

I'm thinking along the lines of using a datarow, and then using one of it's properties to somehow give me the GUID for that row.

Any ideas?

Why dont you give me some Coding examples of the exersize you gave me then maybe ill be able to help you

Dim myConnection As New SqlClient.SqlConnection(Connectionstring)
Dim myCommand As New SqlClient.SqlCommand(strSelect, myConnection)
myConnection.Open()
Dim Reader As SqlClient.SqlDataReader = myCommand.ExecuteReader
Reader.Read()
GetGuid = Reader.GetSqlGuid(0).Value
myConnection.Close()
myConnection.Dispose()

Voila!