Hi Viv,
I'm sorry I don't have an answer for you, but I wondered if you got this all figured out yet.
I don't use DataReaders, so without actually playing with this a bit myself, I didn't want to take a stab at the answer (I hate being wrong <g>). I've been way too busy to do any playing though.
~~Bonnie
>Hi,
>
>I'm looking at using .NET UDTs in SQLSERVER. The twist is that we need to construct a .NET DataTable on the fly and then add them in using a DataReader. I can query the DB for the UDT type and set the relevant properties when I create the DataColumn but I'm not sure whether this will let me populate the row without casting using something like: DataRow["ColumnName"] = dr["Data"]
>
>Won't work on this till Monday so maybe someone will let me know if I'm going to be wasting by time before then......
>
>Regards,
>Viv