sqlserver如何用二進(jìn)制保存mp3文件

先程序中把MP3文件讀取為byte數(shù)組，然后就可以保存到數(shù)據(jù)庫(kù)中二進(jìn)制字段VARBINARY(max)中

目前累計(jì)服務(wù)客戶成百上千，積累了豐富的產(chǎn)品開(kāi)發(fā)及服務(wù)經(jīng)驗(yàn)。以網(wǎng)站設(shè)計(jì)水平和技術(shù)實(shí)力，樹(shù)立企業(yè)形象，為客戶提供網(wǎng)站設(shè)計(jì)制作、網(wǎng)站建設(shè)、網(wǎng)站策劃、網(wǎng)頁(yè)設(shè)計(jì)、網(wǎng)絡(luò)營(yíng)銷、VI設(shè)計(jì)、網(wǎng)站改版、漏洞修補(bǔ)等服務(wù)。成都創(chuàng)新互聯(lián)始終以務(wù)實(shí)、誠(chéng)信為根本，不斷創(chuàng)新和提高建站品質(zhì)，通過(guò)對(duì)領(lǐng)先技術(shù)的掌握、對(duì)創(chuàng)意設(shè)計(jì)的研究、對(duì)客戶形象的視覺(jué)傳遞、對(duì)應(yīng)用系統(tǒng)的結(jié)合，為客戶提供更好的一站式互聯(lián)網(wǎng)解決方案，攜手廣大客戶，共同發(fā)展進(jìn)步。

求采納

Sqlserver數(shù)據(jù)庫(kù)存儲(chǔ)的圖片格式(二進(jìn)制數(shù)據(jù))怎么顯示到頁(yè)面？

1.將圖片以二進(jìn)制存入數(shù)據(jù)庫(kù)

//保存圖片到數(shù)據(jù)庫(kù)

protected void Button1_Click(object sender, EventArgs e)

{

//圖片路徑

string strPath = "~/photo/03.JPG";

string strPhotoPath = Server.MapPath(strPath);

//讀取圖片

FileStream fs = new System.IO.FileStream(strPhotoPath, FileMode.Open, FileAccess.Read);

BinaryReader br = new BinaryReader(fs);

byte[] photo = br.ReadBytes((int)fs.Length);

br.Close();

fs.Close();

//存入

SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

string strComm = " INSERT INTO personPhoto(personName, personPhotoPath, personPhoto) ";

strComm += " VALUES('wangwu', '" + strPath + "', @photoBinary )";

SqlCommand myComm = new SqlCommand(strComm, myConn);

myComm.Parameters.Add("@photoBinary", SqlDbType.Binary,photo.Length);

myComm.Parameters["@photoBinary"].Value = photo;

myConn.Open();

myComm.ExecuteNonQuery();

myConn.Close();

}

2.讀取二進(jìn)制圖片在頁(yè)面顯示

//讀取圖片

SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

string strComm = " SELECT personPhoto FROM personPhoto WHERE personName='wangwu' ";

SqlCommand myComm = new SqlCommand(strComm, myConn);

myConn.Open();

SqlDataReader dr = myComm.ExecuteReader();

while (dr.Read())

{

byte[] photo = (byte[])dr["personPhoto"];

this.Response.BinaryWrite(photo);

}

dr.Close();

myConn.Close();

或

SqlConnection myConn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE personName='11' ", myConn);

DataSet myds = new DataSet();

myConn.Open();

myda.Fill(myds);

myConn.Close();

byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];

this.Response.BinaryWrite(photo);

3.設(shè)置Image控件顯示從數(shù)據(jù)庫(kù)中讀出的二進(jìn)制圖片

---------------------------------------------

SqlConnection myConn = new SqlConnection("Data Source=192.168.0.1;Initial Catalog=TestDB;User ID=sa;Password=sa");

SqlDataAdapter myda = new SqlDataAdapter(" SELECT personPhoto FROM personPhoto WHERE personName='11' ", myConn);

DataSet myds = new DataSet();

myConn.Open();

myda.Fill(myds);

myConn.Close();

byte[] photo = (byte[])myds.Tables[0].Rows[0]["personPhoto"];

//圖片路徑

string strPath = "~/photo/wangwu.JPG";

string strPhotoPath = Server.MapPath(strPath);

//保存圖片文件

BinaryWriter bw = new BinaryWriter(File.Open(strPhotoPath,FileMode.OpenOrCreate));

bw.Write(photo);

bw.Close();

3.顯示圖片

this.Image1.ImageUrl = strPath;

4.GridView中ImageField以URL方式顯示圖片

--------------------------

asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"

Columns

asp:BoundField DataField="personName" HeaderText="姓名" /

asp:ImageField DataImageUrlField="personPhotoPath"

HeaderText="圖片"

/asp:ImageField

/Columns

/asp:GridView

5.GridView顯示讀出的二進(jìn)制圖片

//樣板列

asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound"

Columns

asp:BoundField DataField="personName" HeaderText="姓名" /

asp:ImageField DataImageUrlField="personPhotoPath"

HeaderText="圖片"

/asp:ImageField

asp:TemplateField HeaderText="圖片"

ItemTemplate

asp:Image ID="Image1" runat="server" /

/ItemTemplate

/asp:TemplateField

/Columns

/asp:GridView

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowIndex 0)

return;

// System.ComponentModel.Container

string strPersonName = (string)DataBinder.Eval(e.Row.DataItem, "personName");

Image tmp_Image = (Image)e.Row.Cells[2].FindControl("Image1");

if (!System.Convert.IsDBNull(DataBinder.Eval(e.Row.DataItem, "personPhoto")))

{

//

byte[] photo = (byte[])DataBinder.Eval(e.Row.DataItem, "personPhoto");

//圖片路徑

string strPath = "~/photo/" + strPersonName.Trim() + ".JPG";

string strPhotoPath = Server.MapPath(strPath);

//保存圖片文件

BinaryWriter bw = new BinaryWriter(File.Open(strPhotoPath, FileMode.OpenOrCreate));

bw.Write(photo);

bw.Close();

//顯示圖片

tmp_Image.ImageUrl = strPath;

}

}

怎樣在sqlserver2008中用sql語(yǔ)句操作二進(jìn)制數(shù)據(jù)

怎樣在sqlserver2008中用sql語(yǔ)句操作二進(jìn)制數(shù)據(jù)

sqlserver之二進(jìn)制和字符串sql語(yǔ)句

正常情況下我們對(duì)數(shù)據(jù)庫(kù)的操作就是如下的寫(xiě)法來(lái)操作數(shù)據(jù)庫(kù)

SELECT TOP 10 ID AS 編號(hào),BookName AS 書(shū)名 FROM dbo.books ORDER BY ID;

UPDATE dbo.books SET BookName='新的書(shū)名' WHERE ID=1233;

DELETE FROM dbo.books WHERE ID=122

SQLServer存儲(chǔ)二進(jìn)制圖片用什么類型

存儲(chǔ)圖片:以二進(jìn)制的形式存儲(chǔ)圖片時(shí)，要把數(shù)據(jù)庫(kù)中的字段設(shè)置為Image數(shù)據(jù)類型(SQL Server),存儲(chǔ)的數(shù)據(jù)是Byte[]

當(dāng)前名稱：sqlserver二進(jìn)制,sqlserver二進(jìn)制數(shù)據(jù)類型
文章分享：http://chinadenli.net/article4/dsegioe.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供虛擬主機(jī)、定制網(wǎng)站、品牌網(wǎng)站建設(shè)、微信公眾號(hào)、App開(kāi)發(fā)、網(wǎng)站收錄

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)