SQL Server Text datatype and OleDBType in ASP.NET

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

voidfill3d@yahoo.com - 21 Jul 2005 18:55 GMT

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!

Reply to this Message

Guillermo González A. - 21 Jul 2005 21:00 GMT

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!

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...