Data Relations using GUID (uniqueidentifier)

A

Andrew

I am trying to build a data relationship between two tables in a dataset. I
am making the join on fields that are both System.Guid types in .NET and
uniqueidentifiers in SQL Server 2000. The join works as expected when used
in an SQL query but I get an empty set when I use the join in my dataset.

The join was working correctly when we were using integers as the primary
key but after changing the data types to GUIDs I am not able to make the
join.

Has anyone else experienced this kind of problem.

Thanks,
Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dataset - Relations vb 2005 3
converting string to uniqueidentifier 3
Joining Access Replication ID to SQL Server GUID 16
Error updating GUID columns 1
Problem inserting a GUID into an UniqueIdentifier field on SQL 200 9
SQL JOIN between DataTables in a DataSet 4
Using System.GUID in a RowFilter 3
GUID and uniqueidentifier 2

Top