i have access file by name song.mdb which has field by name file
where i am storing mp3 file in binary format .
when i tried to read the field into
ret byte array i am able to read only first 25 bytes .

Why am i not getting the full array which is 1024 bytes long

byte[] ret = new byte[2000];
OleDbCommand cmd = new OleDbCommand("select file from song", mycon);
            System.Data.OleDb.OleDbDataReader dr;
            dr = cmd.ExecuteReader();
            if (dr.Read())
                ret = (byte[])dr.GetValue(0);
8 Years
Discussion Span
Last Post by coollife

Upload the access database you are working with.

unable to upload its saying not support file


ZIP it and upload the zip.

private void button1_Click_1(object sender, EventArgs e)
            String strFileName;
            String str;

            OpenFileDialog dialog = new OpenFileDialog();

            dialog.InitialDirectory = "C:";
            dialog.Title = "Select a text file";
            if (dialog.ShowDialog() == DialogResult.OK)
                strFileName = dialog.FileName;

            //if strFileName == " ")
            //    return; //user didn't select a file to opena

            //insertsql = "insert into songs(ID,file) values(1,data)";
            str = dialog.FileName;

            FileStream fs = new FileStream(str, FileMode.Open);
            //int Size = 1024;
            byte[] data = new byte[100000];
            int b = fs.Read(data, 0, 100000);
            while (b != 0)
                b = fs.Read(data, 0, 100000);
            OleDbCommand cmd = new OleDbCommand("INSERT INTO song VALUES('1', '" + data + "')", mycon);

        private void button2_Click(object sender, EventArgs e)
        //    byte[] ret = new byte[2000];
        //    mycon.Open();

        //    //OleDbCommand cmd = new OleDbCommand("select file from song", mycon);
        //    //System.Data.OleDb.OleDbDataReader dr;
        //    //dr = cmd.ExecuteReader();
        //    //if (dr.Read())
        //    //{
        //    //    ret = (byte[])dr.GetValue(0);
        //    //}

        //    BinaryReader br = new BinaryReader();
        //    br.Read(

        //    DataSet ds = new DataSet();
        //    OleDbDataAdapter adapter = new OleDbDataAdapter("Select * from song", mycon);
        //    adapter.Fill(ds);

        //    //// close the connection
        //    //mycon.Close();
        //   //ret = (byte[])ds.Tables[0].Rows[0];
        //    ret = (byte[])dr.GetValue(0);
        //    //ret = ds.Tables[0].Rows[0];


hi i have added the whole code in button1_click i am uploading it into ms access database , but still the whole song is not getting stored there and even the half stored song i am unable to retrieve it .


ZIP it and upload the zip.

hi i will tell what exactly is my requirement .
I want to store a mp3 song into ms access database in encrypted format .
Firstly if it gets stored in normal format also its ok .

Later i have to retrieve it and play it .

Now u please correct the code as it has few problems.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.