Get the GUID from a Dataset

[JohannS]

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?

[jkcontra]

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

[JohannS]

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!