保存到數(shù)據(jù)庫
????public?int?DyfcListInsert(int?id,string?name,string?username,string?content,Byte[]?photo)
????????{
????????????string?sql?=?"S_DyfcList_Insert";
????????????SqlCommand?sqlcmd?=?new?SqlCommand(sql,DwzxConfiguration.ConnectDB()?,DwzxConfiguration.SqlTran);
????????????sqlcmd.CommandType?=?CommandType.StoredProcedure;
????????????if(id>0)
????????????{
????????????????sqlcmd.Parameters?.Add?("@Id",SqlDbType.Int?,4).Value=id;
????????????}
????????????sqlcmd.Parameters?.Add?("@Name",SqlDbType.VarChar?,50).Value=name;
????????????sqlcmd.Parameters?.Add?("@UserName",SqlDbType.VarChar?,500).Value=username;
????????????sqlcmd.Parameters?.Add?("@Content",SqlDbType.NText?).Value=content;
????????????sqlcmd.Parameters?.Add?("@Photo",SqlDbType.Binary).Value=photo;
????????????sqlcmd.Parameters?.Add?("@RETURN_VALUE",SqlDbType.Int?,4).Direction=ParameterDirection.ReturnValue?;
????????????sqlcmd.ExecuteNonQuery?();
????????????return?(int)sqlcmd.Parameters?["@RETURN_VALUE"].Value?;
????????} 保存到服務(wù)器的方法(http://www.cnblogs.com/interboy/archive/2007/04/12/710024.aspx)

public?byte[]?getBytes(string?filePath)
{
????System.IO.FileStream?fs?=?new?System.IO.FileStream(filePath,?System.IO.FileMode.Open);
????byte[]?imgData?=?new?byte[fs.Length];
????fs.Read(imgData,?0,?(int)fs.Length);
????return?imgData;
}
byte[]?fileData?=?this.FileUpload1.FileBytes;

string?sql?=?"insert?into?t_img(img)?values?(@img)";
string?strconn?=?System.Configuration.ConfigurationManager.ConnectionStrings["fengdongDB"].ToString();
SqlConnection?sqlConn?=?new?SqlConnection(strconn);
SqlCommand?sqlComm?=?new?SqlCommand(sql,?sqlConn);
sqlComm.Parameters.Add("@img",?SqlDbType.Image);//添加參數(shù)
sqlComm.Parameters["@img"].Value?=?fileData;//為參數(shù)賦值

sqlConn.Open();
sqlComm.ExecuteNonQuery();
sqlConn.Close();

轉(zhuǎn)載于:https://www.cnblogs.com/nonsuch/archive/2007/07/11/813868.html

總結(jié)

以上是生活随笔為你收集整理的压缩图片上传到数据库的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。