AnsweredAssumed Answered

vrf sending binary data to SQL Server

Question asked by VRFuser on Oct 31, 2007
Hi All

 

Does anyone have an example of how to upload a binary object (such as a jpg or other file) to a SQLServer database field using ADO.net.

 

I currently talk to the SQL server using ADO.net and the oledbconnection.

 

Someone who uses ADO.net through VB has given me an example SQL string that looks like:

 

Cmd = "UPDATE " & TableName & " SET " & FieldName & " = @img WHERE ID=" & ID

 

In his case, he stores the file to large byte array called img before running this SQL command. 

 

I just can’t get my head around how to use this command from within vee.  Any help would be greatly appreciated.

 

Thanks and regards

 

Nick

 

 


---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list, email "vrf@agilent.com".
If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes