file to a byte array

krithika muthukrishnan

hi
can anyone tell me.how can i convert the file into byte array.
Thank you

34 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Garad15y ago
Accepted answer
Kritika best do it in stored procedure like bellow now.

In database create procedure

Create Procedure Sp_InsertFile
(
@resume VarBinary(max)
)
As
Begin
Insert Into Sample(Resume)Values(@resume)
End

Now in .cs file
if(FileUpload1.Hasfile)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
           byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);


            string strconn = @"data source=system-7\sqlexpress;initial
                catalog=jobs;uid=sa;pwd=as";
            SqlConnection conn = new SqlConnection(strconn);
            conn.Open();


            SqlCommand cmd = new SqlCommand("Sp_InsertFile", conn);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@resume", SqlDbType.VarBinary);
            cmd.Parameters[0].Value = buffer;
            cmd.ExecuteNonQuery();
            Response.Write("");
            cmd.Dispose();
            conn.Close();
}
And while Executing put a break point and check exact what kind of error is it. Because both code work fine.
0

here is an image to byte array.
Imports System.IO
Imports System.Drawing.Printing
Imports RasterEdge.Imaging
Imports RasterEdge.Imaging.Processing
Imports RasterEdge.Imaging.Converting.ImageToByte

Dim Image As New RasterEdgeImaging()
If True Then
    Dim image As New MemoryStream()
    ImageID.Save(image, System.Drawing.Imaging.ImageFormat.Jpeg)
    Return ms.ToArray()
End If
Image.save()

Bharat Bhushan15y ago
see my article
http://useofaspdotnet.blogspot.com/2011/01/how-to-encrypt-password-and-store-it-in.html
0
Suthish Nair15y ago
Lots of sample available on internet, just a bing/google will do.

Dont copy paste the code, will not helps you. try to understand how the code/procedure works.

Check below all links, if this didnt helps you so we cant.

Link1 Link2 Link3 Link4

0
krithika muthukrishnan15y ago
k.Thanks.
0
Krishna Garad15y ago
Thank god it's solved. Previous code also works fine but it is recommended to follow the stored procedure not for byte array for any kind of data.
0
krithika muthukrishnan15y ago
ya,now it works well.i got corrrect result.
but i dont know why the previous codings didn't give best answer.
0
krithika muthukrishnan15y ago
now here i attached my codings.After modify the codings also the same error will occur.Implicit conversion is not allowed
0
Krishna Garad15y ago
where is it I'm unable to see. You miss it pls attach again.
0
krithika muthukrishnan15y ago
hi ,
here i attached my code behind page.
0
Suthish Nair15y ago
Kiruthika, better you attach your codebehind page (.cs) not code.
0
Krishna Garad15y ago
Tell me why you are using Method as byte[]. It's working actually which I posted earlier. I tested it
else also write like this don't modify anything in this.

if (FileUpload1.HasFile)
        {
            BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
            byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
            Response.Write(buffer);

            string strconn = @"data source=system-7\sqlexpress;initial
                catalog=jobs;uid=sa;pwd=as";

            SqlConnection conn = new SqlConnection(strconn);
            conn.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandText = ("insert into sample(resume) values('" + buffer + "')");

            cmd.ExecuteNonQuery();
            Response.Write("");
            cmd.Dispose();
            conn.Close();
        }
just copy and paste it's working. if it not worked again just restart your SQL Server and visual studio.
0
krithika muthukrishnan15y ago
after check the Fileupload1.hasfile i call this file to byte array function at that time also the same error will occur on the same line.

    public byte[] FileToByteArray()
      {
          BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
           byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
            Response.Write(buffer);
            string strconn = @"data source=system-7\sqlexpress;initial
                catalog=jobs;uid=sa;pwd=as";
            SqlConnection conn = new SqlConnection(strconn);
            conn.Open();
            string query = "insert into sample(resume) values('" + buffer + "')";
            SqlCommand cmd = new SqlCommand(query, conn);
            cmd.ExecuteNonQuery();
            Response.Write("");
            cmd.Dispose();
            conn.Close();
            return buffer;
}
0
Krishna Garad15y ago
Hello what you want to insert string into VarBinary Column check out comments puted where you were wrong.

public byte[] FileToByteArray(string FileName)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
Response.Write(buffer);

string strconn = @"data source=system-7\sqlexpress;initial catalog=jobs;uid=sa;pwd=as";
//string query = "select * from register";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand cmd = new SqlCommand(); //Here you dont want to pass you select query
cmd.Connection = conn;
cmd.CommandText = ("insert into sample(columnname) values(" +buffer + ")");
//add columname in place of columnname.
cmd.ExecuteNonQuery();//Error occur in this line
Response.Write("");
cmd.Dispose();
conn.Close();
return buffer;
}
I tested it in my db also it's now working. let me know if not. and if fileupload hasfile then only it will create byte[].
0
krithika muthukrishnan15y ago
After modifying it also the same error will occur on the same line.
0
Krishna Garad15y ago
I was told you to insert buffer variable in insert statement you are inserting Param which is SqlParameter tell me how it will insert SqlParameter Class object. use this
public byte[] FileToByteArray(string FileName)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
Response.Write(buffer);

string strconn = @"data source=system-7\sqlexpress;initial catalog=jobs;uid=sa;pwd=as";
string query = "select * from register";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand cmd = new SqlCommand(query);
cmd.Connection = conn;
cmd.CommandText = ("insert into sample(columnname) values(" +buffer + ")");
//add columname in place of columnname.
cmd.ExecuteNonQuery();//Error occur in this line
Response.Write("");
cmd.Dispose();
conn.Close();
return buffer;
}
0
krithika muthukrishnan15y ago

public byte[] FileToByteArray(string FileName)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
Response.Write(buffer);
SqlParameter[] Param=new SqlParameter[1];
Param[0] = new SqlParameter("@image", SqlDbType.Image);
Param[0].Value = buffer;
string strconn = @"data source=system-7\sqlexpress;initial catalog=jobs;uid=sa;pwd=as";
string query = "select * from register";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlCommand cmd = new SqlCommand(query);
cmd.Connection = conn;
cmd.CommandText = ("insert into sample values('" + Param + "')");
cmd.ExecuteNonQuery();//Error occur in this line
Response.Write("");
cmd.Dispose();
conn.Close();
return buffer;
}
0
Krishna Garad15y ago
Upload your source file here I'll resolve it.
0
krithika muthukrishnan15y ago
when i insert the parameter to the sql table the error will occur.
Implicit conversion from datatype varchar to varbinary is not allowed error will occur in cmd.executenonquery() line.
0
Krishna Garad15y ago
Is it solved
0
Krishna Garad15y ago

SqlParameter[] Param=new SqlParameter[1];//this is the error
Param[0] = new SqlParameter("@image", SqlDbType.VarBinary);
Param[0].Value = buffer
increase the size of SqlParameter
0
krithika muthukrishnan15y ago

BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);
byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);Response.Write(buffer);
SqlParameter[] Param=new SqlParameter[0];
Param[0] = new SqlParameter("@image", SqlDbType.Image);
Param[0].Value = buffer;//here the error will occur index was outside the range
0
Krishna Garad15y ago
Please attach your code here.
0
krithika muthukrishnan15y ago
when i used this the error occur
ERror: Index was outside the bounds of the array.
0
Krishna Garad15y ago
See whenever you are inserting this byte array it will go as string for that you have to explicitly specify the database type see the example bellow.
In aspx.cs where you are uploading event happens
byte[] buffer;
if(FileUpload1.HasFile)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);



             byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
// Insert this byte array now to database as buffer.
}

In Insert Method
Insert File (byte[] filearray)
{
SqlParameter[] Param=new SqlParameter[0];
        Param[0] = new SqlParameter("@image", SqlDbType.Image);
        Param[0].Value = filearray;
//further insert to database attach this parameter to your command.
}
0
krithika muthukrishnan15y ago
hi,
in sql table i create the field for store byte array in a data type varbinary(max).when i insert the bytearray buffer to the sql table ,I have an error like
Error : Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
0
Suthish Nair15y ago
Convert
0
Krishna Garad15y ago
that file path is not correct. pass valid file path as filename.
byte[] buffer;
if(FileUpload1.HasFile)
{
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);

byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
// Insert this byte array now to database as buffer.
}
0
krithika muthukrishnan15y ago
word file.
0
Krishna Garad15y ago
which file you are trying to convert in byte array.
0
krithika muthukrishnan15y ago
hi
when i use this coding,i have an error in this line ,i choose the file from D:\.but it will show the error like could not find file in C:\.how to solve this.
coding :
FileStream fs = new FileStream(FileName, FileMode.Open,FileAccess.Read);
Error :
Could not find file 'C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE\time.doc'.
0
Krishna Garad15y ago
using BinaryWriter you can write the byte to file.
0
krithika muthukrishnan15y ago
hi,
i wish to know how to convert the bytearray to a file,
thank you
0
Krishna Garad15y ago
Not converting you have to read the bytes of file in byte array like this
BinaryReader br = new BinaryReader(FileUpload1.PostedFile.InputStream);

byte[] buffer = br.ReadBytes(FileUpload1.PostedFile.ContentLength);
0