SQL Server Text datatype and OleDBType in ASP.NET

[voidfill3d]

I have a field in a table that is of the datatype "Text". I also have
a store procedure which updates this field and has a parameter of the
same datatype ("Text"). However, in ASP.NET, interfacing this store
procedure, there is no datatype called "Text" in the OleDBType
Enumeration. What would be comparable to use with this so that data is
not truncated?

THANKS!

 

[=?iso-8859-1?Q?Guillermo_Gonz=E1lez_A.?=]

Hi void,

You can use varchar instead

Guillermo G.

--------------------------------------------------------------------------------
Guillermo González Arroyave :: MCP ASP.Net C# :: DCE4

I have a field in a table that is of the datatype "Text". I also have
a store procedure which updates this field and has a parameter of the
same datatype ("Text"). However, in ASP.NET, interfacing this store
procedure, there is no datatype called "Text" in the OleDBType
Enumeration. What would be comparable to use with this so that data is
not truncated?

THANKS!