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

Can you post some code, please?

--
Carsten Thomsen
Enterprise Development with Visual Studio .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Andrew" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>