F6 Team

"用心" by puma

點部落 :: Home :: Syndication :: 我的收藏 ::

:: Login

文章數 - 162, 回應數 - 119, 引用數 - 0

News

About Me

用BloggerAds 替自已加薪

用BlogAD 替自已加薪

文章標籤

全部標籤

每月文章

文章分類

最新回應

re: 解決Visual Studio開發網頁,在瀏覽器中檢視,出現通訊埠編號與瀏覽器不一樣的問題:
這裡還有一些解決方法..http://www.wahooga.com/archive/2008/02....
by puma
re: ASP.Net FTP 的使用方式,使用FtpWebRequest,FtpWebResponse:
如果我打ftp://網路磁碟機/資料夾是出現無法顯示網頁,而不是要求輸入帳密,是不是不適用此範例?不....
by 瑤
re: ASP.Net FTP 的使用方式,使用FtpWebRequest,FtpWebResponse:
補上兩個上傳的範例...FtpWebRequesthttp://wiki.asp.net/page.....
by puma
re: ASP.Net FTP 的使用方式,使用FtpWebRequest,FtpWebResponse:
請問怎麼上傳??可以提供上傳的語法嗎??謝謝大大
by 瑤
re: ASP.NET傳遞參數給Crystal Report做Export或Print的動作:
請問閣下,依照你的做好, 設定參數欄位, 利用setparametervalue給值, 把參數拉到報....
by 求助者
re: ASP.NET利用SqlDataAdapter的Fill來取得多個SQL Query的DataTable:
感謝cloudio提供此方法呀...謝謝..
by puma
re: ASP.NET利用SqlDataAdapter的Fill來取得多個SQL Query的DataTable:
不錯^^但是如果只是要撈資料小弟覺得用datareader也蠻快的像這樣 protecte....
by cloudio
re: [C#]WinForm解決ComboBox在下拉選單Width的AutoSize:
可以呀..在我的blog裡所有文章..都可以轉貼..複製..都沒問題的...
by puma
re: [C#]WinForm解決ComboBox在下拉選單Width的AutoSize:
真好用...我也可以在我的Blog留記錄嗎??
by Jenny_Ming
re: MS SQL與Oracle判斷欄位是否為NULL的方法比較,COALESCE()、ISNULL()、NVL():
空值判斷可以試試下面這個方式...where length(欄位)=0
by Jerry

ASP.NET將物件(Object)序列化(Serialize)成Binary儲存至DB or File

最近有人在討論這個問題..小弟很少玩這個東西..就到網路上找了一些資源..
教大家如何將物件序列化成Binary Data..然後儲存到資料庫或檔案裡..
當然可以序列化..就一定可以反序列化了...
其實序列化格式不一定要是Binary Data..也可以是XML or SOAP Data的...

首先準備一個DB,結構如下：

接下來就是程式碼了

asp.net(c#)

SerializingObjects.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SerializingObjects.aspx.cs" Inherits="SerializingObjects" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Serializing Objects</title> </head> <body> <form id="form1" runat="server"> <div> <asp:DropDownList ID="ddlType" runat="server"> <asp:ListItem Value="0">資料庫</asp:ListItem> <asp:ListItem Value="1">檔案</asp:ListItem> </asp:DropDownList> <asp:Button ID="btnLoad" runat="server" OnClick="btnLoad_Click" Text="讀取" /><br /> <asp:Label ID="Label1" runat="server" Text="編號："></asp:Label> <asp:TextBox ID="txbId" runat="server"></asp:TextBox> <br /> <asp:Label ID="Label2" runat="server" Text="名稱："></asp:Label> <asp:TextBox ID="txbName" runat="server"></asp:TextBox> <br /> <asp:Label ID="Label3" runat="server" Text="電話："></asp:Label> <asp:TextBox ID="txbTel" runat="server"></asp:TextBox><br /> <asp:Label ID="Label4" runat="server" Text="地址："></asp:Label> <asp:TextBox ID="txbAddress" runat="server"></asp:TextBox> <asp:Button ID="btnAdd" runat="server" OnClick="btnAdd_Click" Text="新增" /></div> </form> </body> </html>

SerializingObjects.aspx.cs

using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient; using System.IO; using System.Runtime.Serialization.Formatters.Binary; public partial class SerializingObjects : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void btnAdd_Click(object sender, EventArgs e) { if (this.ddlType.SelectedIndex == 0) { SaveToDB(); } else { SaveToFile(); } } //存至資料庫(Binary Serialization) protected void SaveToDB() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { using (MemoryStream ms = new MemoryStream()) { conn.Open(); Member mem = new Member(); mem.Id = this.txbId.Text; mem.Name = this.txbName.Text; mem.Tel = this.txbTel.Text; mem.Address = this.txbAddress.Text; BinaryFormatter b = new BinaryFormatter(); b.Serialize(ms, mem); ms.Seek(0, 0); string sql = "insert into member values(@data)"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.Add("@data", SqlDbType.Binary).Value = ms.ToArray(); cmd.ExecuteNonQuery(); } } } //由資料庫讀取(Binary Serialization) protected void LoadFromDB() { using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { using (MemoryStream ms = new MemoryStream()) { conn.Open(); string sql = "select data from member"; SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); if (dt.Rows.Count > 0) { byte[] buffer = (byte[])dt.Rows[dt.Rows.Count-1][0]; ms.Write(buffer, 0, buffer.Length); ms.Seek(0, 0); BinaryFormatter b = new BinaryFormatter(); Member mem = new Member(); mem = (Member)b.Deserialize(ms); this.txbId.Text = mem.Id; this.txbName.Text = mem.Name; this.txbTel.Text = mem.Tel; this.txbAddress.Text = mem.Address; } } } } //存至檔案(Binary Serialization) protected void SaveToFile() { string path = Server.MapPath("member.dat"); using (Stream s = File.Open(path, FileMode.Create)) { Member mem = new Member(); mem.Id = this.txbId.Text; mem.Name = this.txbName.Text; mem.Tel = this.txbTel.Text; mem.Address = this.txbAddress.Text; BinaryFormatter b = new BinaryFormatter(); b.Serialize(s, mem); } } //由檔案讀取(Binary Serialization) protected void LoadFromFile() { string path = Server.MapPath("member.dat"); if (File.Exists(path)) { using (Stream s = File.Open(path, FileMode.Open)) { BinaryFormatter b = new BinaryFormatter(); Member mem = new Member(); mem = (Member)b.Deserialize(s); this.txbId.Text = mem.Id; this.txbName.Text = mem.Name; this.txbTel.Text = mem.Tel; this.txbAddress.Text = mem.Address; } } } protected void btnLoad_Click(object sender, EventArgs e) { if (this.ddlType.SelectedIndex == 0) { LoadFromDB(); } else { LoadFromFile(); } } } [Serializable] public class Member { private string _id = string.Empty; private string _name = string.Empty; private string _tel = string.Empty; private string _address = string.Empty; public Member() { } public Member(string id, string name,string tel,string address) { _id = id; _name = name; _tel = tel; _address = address; } public string Id { get { return _id; } set { _id = value; } } public string Name { get { return _name; } set { _name = value; } } public string Tel { get { return _tel; } set { _tel = value; } } public string Address { get { return _address; } set { _address = value; } } }

執行結果：

參考網址：

http://www.blueshop.com.tw/board/show.asp?subcde=BRD20080701133923V04
http://www.c-sharpcorner.com/UploadFile/bipinjoshi/serializingObjectsinCS11102005234746PM/serializingObjectsinCS.aspx
http://www.eggheadcafe.com/articles/20020929.asp

DotBlogs Tags: ASP.NET Binary DB File Object Serialize SOAP XML
posted on 2008/7/5 16:46 | 我要推薦 | 閱讀數 : 734 | 文章分類 [ ASP.NET ] 訂閱

Feedback

# re: ASP.NET將物件(Object)序列化(Serialize)成Binary儲存至DB or File 2008/7/6 上午 10:49 James Wu 回覆

不錯的文章，除序列化反序列化還包含一些好的物件導向設計概念。

回應

標題:
姓名:
電子郵件:(將不會被顯示)
個人網頁:
內容: 登入後使用進階評論

Please add 2 and 3 and type the answer here: 請輸入驗證碼: 記住我?