Re: What .Net type to use for Sql Server Varbinary Value

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "David Browne" <davidbaxterbrowne no potted meat@xxxxxxxxxxx>
Date: Sun, 16 Oct 2005 07:40:24 -0500

"Phil C." <charlestek@xxxxxxx> wrote in message
news:O55Wdsf0FHA.3300@xxxxxxxxxxxxxxxxxxxxxxx
> Hi. I have a stored procedure that returns a select on a table of sql
> server varbinary values.
> The return gets bound to a datatable and when I examine a cell value from
> the datarow level, i.e. dr("foo column") I don't know what type the value
> is?

Then examine it in the debugger

dim o as Object = dr("foo column")
Console.WriteLine(o.GetType().Name)

David

.

References:
- What .Net type to use for Sql Server Varbinary Value
  - From: Phil C.

Prev by Date: Re: My excuse to Peter van der Goes
Next by Date: Re: My excuse to Peter van der Goes
Previous by thread: What .Net type to use for Sql Server Varbinary Value
Next by thread: Re: What .Net type to use for Sql Server Varbinary Value
Index(es):
- Date
- Thread

Relevant Pages

What .Net type to use for Sql Server Varbinary Value
... I have a stored procedure that returns a select on a table of sql ... drto a byte array. ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet)
Re: DTS packages or stored procedures?
... a DTS script or a stored procedure ... with linked (SQL) servers? ... Prev by Date: ...
(microsoft.public.sqlserver.dts)
Re: Different Date Value for different client time zone
... >> Instead of using a stored procedure, you can also use a SQL ... > Briscobar AT gmail DOT com ... Prev by Date: ...
(microsoft.public.vb.crystal)
Re: Different Date Value for different client time zone
... > Instead of using a stored procedure, you can also use a SQL ... Briscobar AT gmail DOT com ... Prev by Date: ...
(microsoft.public.vb.crystal)
Re: Returning a "Table" type from a stored procedure
... >I am trying to create a stored procedure that has both input and output ... > SELECT * FROM Table1 ... David ... Prev by Date: ...
(microsoft.public.dotnet.framework.adonet)