how to insert the bytearray file into a sql table

Question

hai i wish to know how to insert the byte array file into a sql table and also is it possible to insert large files. Thank you

Suthish Nair · Answer

If this query got resolved then please Accept the post that helped you as Answer . So other members can easily find the answers.

Krishna Garad · Answer

Create procedure pname ( @data varbinary(max) ) as Insert statement end Convert byte file into byte array byte[] _data; private void PreapareByteArray() { if (FileUpload1.HasFile) { using (BinaryReader reader = new BinaryReader(FileUpload1.PostedFile.InputStream)) { _data = reader.ReadBytes(FileUpload1.PostedFile.ContentLength); } } } Pass this _data to insert statement it will insert byte array to sql table.