Save/Retrieve Long Text from VB.NET

• Rob Hershfield

  SSC-Addicted

  Points: 440

  More actions

  June 27, 2004 at 8:51 am

  #360164

  I have a VB.NET/ADO app that saves/retrieves long text data from a memory stream to a file.  I now want to save/retrieve using an NTEXT variable in the database instead.

  From researching BOL and this site, it seems i have two options: 1) use an ADO recordset or 2) use a stored procedure with WRITETEXT/UPDATETEXT and READTEXT.  Unfortunately for option #2, it sounds like I can pass a long text stream as a stored procedure input parameter but cannot return a long NTEXT value from a stored procedure - I would have to return it in 4000 byte chunks.

  Does anyone have a recommendation on which approach is better, or a better suggestion, and any examples?

  Thanks!

   

  Rob H

• Mark Cohen

  Old Hand

  Points: 321

  More actions

  June 29, 2004 at 6:47 am

  #512401

  Hi Rob

  What version SQL Server are you using?  If you're on sql 2k you can do basic oerations without using chunks, just use stored procs with @var declared as ntext and table col as ntext

  Mark

  ---

  Mark Cohen

• Rob Hershfield

  SSC-Addicted

  Points: 440

  More actions

  June 29, 2004 at 7:29 pm

  #512557

  Yes, I'm using 2K but can I pass the complete ntext value back from a stored proc to a VB.NET program and if so, how?

  Thanks

• Mark Cohen

  Old Hand

  Points: 321

  More actions

  July 3, 2004 at 8:24 am

  #513241

  Rob,

  Just try select it out the table in the sproc and return straight to your vb.net app (via a datareader works for sure, (you are using a reador / adapter ?) - I use text fields like that without issues.

  Mark

  ---

  Mark Cohen

• Rob Hershfield

  SSC-Addicted

  Points: 440

  More actions

  July 8, 2004 at 8:16 pm

  #513951

  So simple!  That worked (using adapter).

  Thanks for tip,

  Rob