C#

byte[] data = null;

            //Use FileInfo object to get file size.
            FileInfo fInfo = new FileInfo(sPath);
            long numBytes = fInfo.Length;
            MessageBox.Show(numBytes.ToString());//for checking remove when finsh

            //Open FileStream to read file
            FileStream fStream = new FileStream(sPath, FileMode.Open,FileAccess.Read);

            //Use BinaryReader to read file stream into byte array.
            BinaryReader br = new BinaryReader(fStream);

            data = br.ReadBytes((int)numBytes);

A_A wrote:

all the images that i load have 13 bytes

A_A wrote:

i do not know how to check the no. of bytes in the (sql 2005)

SqlConnection con = new SqlConnection("DATA SOURCE = MAX_TOSHIBA;Initial Catalog=nodule; Integrated security = true");

                string sql = "INSERT INTO pic (pic_id,patient,id,the_pic,pic_no) values ('" + j + "','" + txt_patient_name.Text + "','" + 0 + "', @a,'" + 0 + "')";
                //string sql = "UPDATE CUSTOMER SET IMAGE = (@ImagPar)";
                SqlCommand cmd = new SqlCommand();
                SqlParameter sp = new SqlParameter("@a", SqlDbType.Image);
                sp.Value = by_img;
                cmd.Parameters.Add(sp);
                cmd.CommandText = sql;
                cmd.CommandType = CommandType.Text;
                cmd.Connection = con;

                //open connection
                con.Open();

                //execute the sql command
                cmd.ExecuteNonQuery();

                con.Close();