SQL Server Text datatype and OleDBType in ASP.NET

V

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top