将一个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);
            }
        }

    }

原创粉丝点击