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".
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".