DataSet with GUIDs
-
I have a DataTable with a PKey defined as a GUID. The problem is trying to "lookup" values in the
DataTable.SelectMethod. Since this is a GUID column, I cannot do the normal things like I could in SQL Server (i.e. DataTable.Select("ID = '" & sID & "'")). In SQL, the GUID DataType is treated like a String. I generated an XSD Schema of my table, and I got this info for the PKey:xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"
How can I get my DataTable to treat my PKey like a String at run time without loading aa Schema first? Or, how can I lookup GUID values in a DataTable??? :omg::wtf:
-
I have a DataTable with a PKey defined as a GUID. The problem is trying to "lookup" values in the
DataTable.SelectMethod. Since this is a GUID column, I cannot do the normal things like I could in SQL Server (i.e. DataTable.Select("ID = '" & sID & "'")). In SQL, the GUID DataType is treated like a String. I generated an XSD Schema of my table, and I got this info for the PKey:xs:element name="ID" msdata:DataType="System.Guid, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"
How can I get my DataTable to treat my PKey like a String at run time without loading aa Schema first? Or, how can I lookup GUID values in a DataTable??? :omg::wtf: