insert a image to the database(convert byte[] to binary)

来源:互联网 发布:奉贤网络电视台 编辑:程序博客网 时间:2024/05/17 23:46

byte[] data = null;

            string sPath = "C://photoimage.jpg";

            //Use FileInfo object to get file size.

            FileInfo fInfo = new FileInfo(sPath);

            long numBytes = fInfo.Length;

            //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);

            //Read Image Bytes into a byte array

            byte[] imageSampleData = data;

            //Initialize SQL Server Connection

            string str_db_err = string.Empty;

            DataSet ds = new DataSet();

            //string str = Encoding.Unicode.GetString(imageSampleData);

            string str = BitConverter.ToString(imageSampleData);

            str = "0x" + str.Replace("-","");

            //string querystr = "INSERT INTO ClearanceDB.dbo.Perso (PhotoImage,PhotoImageFormat) values(imageSampleData,'jpeg')";

            string querystr = "update table1 SET PhotoImage = " +  str + " WHERE ID = 1";

            ds = MySQLHelper.ExecuteStoredProcedure(querystr,null);

            str_db_err = MySQLHelper.DBError;

            // gets database data about job details and sets it for display

            if (str_db_err == "")

            {

            }