110,567
社区成员
发帖
与我相关
我的任务
分享
//從數據庫中讀取圖片
string sql = "select img from t_img ";
string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(strconn);
sqlConn.Open();
SqlCommand sqlComm = new SqlCommand(sql, sqlConn);
byte[] fileData = (byte[])sqlComm.ExecuteScalar();
System.IO.MemoryStream ms = new System.IO.MemoryStream(fileData);
System.Drawing.Image img = System.Drawing.Image.FromStream(ms);
img.Save(Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
sqlConn.Close();
//將圖片讀取成二進制,寫入數據庫
//取一張測試圖片
byte[] fileData=System.IO.File.ReadAllBytes(@"D:\img\Chrysanthemum.jpg");
string sql = "insert into t_img(img) values (@img)";
//以你自己的方式連接數據庫
string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
SqlConnection sqlConn = new SqlConnection(strconn);
SqlCommand sqlComm = new SqlCommand(sql, sqlConn);
sqlComm.Parameters.Add("@img", SqlDbType.Image);//添加参数
sqlComm.Parameters["@img"].Value = fileData;//为参数赋值
sqlConn.Open();
sqlComm.ExecuteNonQuery();
sqlConn.Close();