varbinary

Question

if i use Varbinary datatype for image in sql server than which datatype i use in c# for accessing them

Manas Mohapatra · Answer

Try to use below code: string filePath = Server.MapPath(APP_DATA/TestDoc.docx); string filename = Path.GetFileName(filePath); FileStream fs = new FileStream(filePath FileMode.Open FileAccess.Read); BinaryReader br = new BinaryReader(fs); Byte[] bytes = br.ReadBytes((Int32)fs.Length); br.Close(); fs.Close(); Secondly what is your data value.

Chandu Kumawat · Answer

i used store procedure calling this procedure dc.insert_procedure(nameemailcommentscontentnamecontenttypebyte[](data)ref retValue) how can convert that line for byte[]

Manas Mohapatra · Answer

You need to use byte[] in C# for Varbinary data type in Database. Please go through below link: http://www.aspsnippets.com/Articles/Read-and-Write-BLOB-Data-to-SQL-Server-database-using-C-and-VBNet.aspx