国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

圖片保存到數據庫和從數據庫讀取圖片并顯示(c#)

2019-11-18 16:45:00
字體:
來源:轉載
供稿:網友

        public void imgToDB(string sql)
        {   //參數sql中要求保存的imge變量名稱為@images
            //調用方法如:imgToDB("update UserPhoto set Photo=@images where UserNo='" + temp + "'");
            FileStream fs = File.OpenRead(t_photo.Text);
            byte[] imageb = new byte[fs.Length];
            fs.Read(imageb, 0, imageb.Length);
            fs.Close();
            SqlCommand com3 = new SqlCommand (sql,con);
            com3.Parameters.Add("@images", SqlDbType.Image).Value = imageb;
            if (com3.Connection.State == ConnectionState.Closed)
                com3.Connection.Open();
            try
            {
                com3.ExecuteNonQuery();
            }
            catch
            { }
            finally
            { com3.Connection.Close(); }
        }

數據庫中讀出圖片并顯示在picturebox中:

方法一:
PRivate void ShowImage(string sql)
     {
     //調用方法如:ShowImage("select Photo from UserPhoto where UserNo='" + userno +"'");
     SqlCommand cmd = new SqlCommand(sql, conn);
     conn.Open();
     byte[] b= (byte[])cmd.ExecuteScalar();
     if (b.Length 〉 0)
     {
     MemoryStream stream = new MemoryStream(b, true);
     stream.Write(b, 0, b.Length);
     pictureBox1.Image = new Bitmap(stream);
     stream.Close();
     }
     conn.Close();
     }

方法二:當在dg中選中某行時:
  private void dg_MouseUp(object sender, MouseEventArgs e)
        {
            //整行選擇
            if (e.Button == System.Windows.Forms.MouseButtons.Left)
            {//用戶編號,姓名,性別,身份證號,籍貫,學院,系所,校區,部門,電話,照片
                 //顯示相片
                object imgobj=dg[10, dg.CurrentRow.Index].Value;
                if (imgobj != null && !Convert.IsDBNull(imgobj))
                {
                    byte[] imgb = (byte[])imgobj;
                    MemoryStream memStream = new MemoryStream(imgb);
                    try
                    {
                        Bitmap myimge = new Bitmap(memStream);
                        this.pictureBox1.Image = myimge;
                    }
                    catch
                    {
                        DB.msgbox("從數據庫讀取相片失敗!");
                    }
                }
                else
                    pictureBox1.Image = null;
            }
        }

http://www.survivalescaperooms.com/tuyile006/archive/2007/01/08/614718.html


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 麻栗坡县| 随州市| 乌兰县| 荣昌县| 镇康县| 宽甸| 涞源县| 达尔| 马鞍山市| 梁平县| 昂仁县| 景东| 津市市| 尼勒克县| 正定县| 根河市| 来安县| 毕节市| 茶陵县| 镇江市| 鸡泽县| 德保县| 秦皇岛市| 玛纳斯县| 霍城县| 炎陵县| 南通市| 多伦县| 沈阳市| 洛浦县| 寻甸| 永靖县| 阿合奇县| 栾城县| 金华市| 额尔古纳市| 石林| 南汇区| 赤水市| 静宁县| 常宁市|