Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing binary data into database
Message
 
 
À
12/04/2016 12:22:54
Information générale
Forum:
ASP.NET
Catégorie:
Code, syntaxe and commandes
Versions des environnements
Environment:
C# 5.0
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01634652
Message ID:
01634708
Vues:
25
>>>I'm not going to dig in that code
>>>
>>>(1) Is the field binary in the database ? and how is it stored
>>>
>>>(2) If yes, you have to convert it to a byte[] array and maybe convert the \x?? into one byte at a time
>>
>>I have another quick question. How should I access that column?
>>
>>Say, I have samples of
>>
>>table.Rows[0].Field<decimal>("fieldName")
>>
>>But what should it be for varbinary(max) column?
>
table.Rows[0].Field<byte[]>("fieldName")
Thanks, Rob, but this didn't work in the immediate window. The only thing I had access to was table.Rows[0].ItemArray
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform