将一个datatable序列化和压缩
来源:互联网 发布:ug四轴加工编程步骤 编辑:程序博客网 时间:2024/06/05 04:32
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable("Table1");
dt.Columns.Add("a");
dt.Columns.Add("b");
dt.Columns.Add("c");
DataRow dr1 = dt.NewRow();
dr1["a"] = "a";
dr1["b"] = "b";
dr1["c"] = "c";
dt.Rows.Add(dr1);
DataRow dr2 = dt.NewRow();
dr2["a"] = "aa";
dr2["b"] = "bb";
dr2["c"] = "cc";
dt.Rows.Add(dr2);
DataRow dr3 = dt.NewRow();
dr3["a"] = "aaa";
dr3["b"] = "bbb";
dr3["c"] = "ccc";
dt.Rows.Add(dr3);
string data = SerializeDataTableXml(dt);
string dataCompressed = Compress(data);
string dataDecompressed = Decompress(dataCompressed);
this.dataGridView1.DataSource = DeserializeDataTable(dataDecompressed);
}
private static string SerializeDataTableXml(DataTable pDt)
{
StringBuilder sb = new StringBuilder();
XmlWriter writer = XmlWriter.Create(sb);
XmlSerializer serializer = new XmlSerializer(typeof(DataTable));
serializer.Serialize(writer, pDt);
writer.Close();
return sb.ToString();
}
public static DataTable DeserializeDataTable(string pXml)
{
StringReader strReader = new StringReader(pXml);
XmlReader xmlReader = XmlReader.Create(strReader);
XmlSerializer serializer = new XmlSerializer(typeof(DataTable));
DataTable dt = serializer.Deserialize(xmlReader) as DataTable;
return dt;
}
public static string Compress(string text)
{
byte[] buffer = Encoding.Default.GetBytes(text);
MemoryStream ms = new MemoryStream();
using (GZipStream zip = new GZipStream(ms, CompressionMode.Compress, true))
{
zip.Write(buffer, 0, buffer.Length);
}
ms.Position = 0;
MemoryStream outStream = new MemoryStream();
byte[] compressed = new byte[ms.Length];
ms.Read(compressed, 0, compressed.Length);
byte[] gzBuffer = new byte[compressed.Length + 4];
System.Buffer.BlockCopy(compressed, 0, gzBuffer, 4, compressed.Length);
System.Buffer.BlockCopy(BitConverter.GetBytes(buffer.Length), 0, gzBuffer, 0, 4);
return Convert.ToBase64String(gzBuffer);
}
public static string Decompress(string compressedText)
{
byte[] gzBuffer = Convert.FromBase64String(compressedText);
using (MemoryStream ms = new MemoryStream())
{
int msgLength = BitConverter.ToInt32(gzBuffer, 0);
ms.Write(gzBuffer, 4, gzBuffer.Length - 4);
byte[] buffer = new byte[msgLength];
ms.Position = 0;
using (GZipStream zip = new GZipStream(ms, CompressionMode.Decompress))
{
zip.Read(buffer, 0, buffer.Length);
}
return Encoding.Default.GetString(buffer);
}
}
}
- 将一个datatable序列化和压缩
- 将一个dataTable拆成多个
- DataTable序列化和反序列化
- Datatable序列化和反序列化
- DataTable序列化和反序列化
- 将两个DataTable合并成一个Datatable
- 将两个DataTable合并成一个DataTable
- 将两个DataTable合并成一个DataTable
- 将数据表DataTable转为压缩JSON格式
- 序列化问题!Datatable
- 序列化DataTable
- DataTable序列化Json
- 序列化DataTable
- 将DataTable序列化为Json格式
- 将一个集合转换为一个DataTable
- Java-序列化、持久化和压缩
- 压缩解压和二进制序列化DEMO
- {转}python之序列化和压缩
- WAP上传图片代码
- Asp.net页面传递参数的几种方法对比讲解
- 在Eclipse中加入Android源码
- Linux下安装OpenSSL练手文档
- _beginthreadex 实践小结
- 将一个datatable序列化和压缩
- ASP.NET服务器控件使用之GridView
- 软件测试框架——自动化测试框架(专题)
- 12864液晶显示问题
- 不能一辈子打工,程序员未来出路在哪里?
- Spring事务配置的五种方式(一)
- C++类的默认成员函数
- 终于用boost的正则库写完了一个文本转换
- 第一次安装DB2的经验教训