Hi there,

Any knows? I have created my own User Defined Type in SQL Server. I wrote it using C#, compiled to DLL, and registered on SQL Server 2005. I created a table that uses this UDT.

Now I want to select from that table using DataAdaptor and Dataset. How should I define the column type in DataSet? How can I use this UDT type to "SqlCommand.Paramater.Add" so that it will fill the DataSet for me?

Thanks very much!!!

The column type is the type of the UDT (such as Point).

SqlParameter can handle UDT value, what you need to do is to specify the SqlDbType as Udt and provide UdtTypename.

SqlParameter param = cmd.Parameters.Add("@p", SqlDbType.Udt);
param.UdtTypeName = "dbo.Point";