利用 HttpRequest 得到 GzipStream ，从而获取远程服务器数据库中的数据

一般远程服务器上放一个导出（Export.aspx）页面，本地服务器上放一个导入（Import.aspx）页面，以实现从远程服务器上获取数据。

直接贴代码了：

Export.aspx

?

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.IO.Compression;

 

namespace WebDownloadGzipStream

{

    public partial class _Export : System.Web.UI.Page

    {

 

        private static readonly string ConnString = ConfigurationManager.ConnectionStrings["exportConnString"].ConnectionString;

 

        private static readonly string ExportPassword = ConfigurationManager.AppSettings["exportPassword"];

 

        protected void Page_Load(object sender, EventArgs e)

        {

            if(!IsPostBack)

            {

                BeginExport();

            }

        }

 

        protected void BeginExport()

        {

            string tableName = Request.QueryString["tableName"];

            //这里要验证表是否为空、是否存在，来一个密码更好

            string password = Request.QueryString["password"];

            if (password != ExportPassword)

            {

                return;

            }

            DataSet ds = new DataSet();

            using (SqlConnection conn = new SqlConnection(ConnString))

            {

                SqlDataAdapter adapter = new SqlDataAdapter("select * from " + tableName, conn);

                adapter.Fill(ds);

            }

            using (MemoryStream memoryStream = new MemoryStream())

            {

                ds.WriteXml(memoryStream,XmlWriteMode.WriteSchema);

                memoryStream.Seek(0,SeekOrigin.Begin);

                using(GZipStream gzip = new GZipStream(Response.OutputStream, CompressionMode.Compress))

                {

                    CopyStream(memoryStream, gzip);

                }

            }

        }

 

        public static void CopyStream(Stream source, Stream target)

        {

            byte[] buffer = new byte[4096];

            int count = source.Read(buffer, 0, 4096);

            while(count > 0)

            {

                target.Write(buffer, 0, count);

                count = source.Read(buffer,0, 4096);

            }

        }

    }

}

 

Import.aspx

?

using System;

using System.Configuration;

using System.Data;

using System.Data.SqlClient;

using System.IO;

using System.IO.Compression;

using System.Net;

 

namespace WebDownloadGzipStream

{

    public partial class Import : System.Web.UI.Page

    {

        private static readonly string ConnString = ConfigurationManager.ConnectionStrings["importConnString"].ConnectionString;

 

        private static readonly string RemoteServerExportUrl = ConfigurationManager.AppSettings["remoteServerExportUrl"];

 

        protected void btnImport_Click(object sender, EventArgs e)

        {

            string[] tableNames = new string[]

            {

                "aaa","bbb"

            };

            foreach (var item in tableNames)

            {

                BeginImport(item);

            }

        }

 

        protected void BeginImport(string tableName)

        {

            DataSet ds = GetDataSetFromRemoteServer(tableName);

            using (SqlConnection conn = new SqlConnection(ConnString))

            {

                conn.Open();

                using(SqlBulkCopy bulkCopy = new SqlBulkCopy(conn))

                {

                    bulkCopy.DestinationTableName = tableName;

                    bulkCopy.WriteToServer(ds.Tables[0], DataRowState.Unchanged);

                }

            }

        }

 

        protected DataSet GetDataSetFromRemoteServer(string tableName)

        {

            HttpWebRequest wr = WebRequest.Create(RemoteServerExportUrl) as HttpWebRequest;

            using(Stream s = (wr.GetResponse() as HttpWebResponse).GetResponseStream())

            {

                using(GZipStream gzip = new GZipStream(s,CompressionMode.Decompress))

                {

                    DataSet ds = new DataSet();

                    ds.ReadXml(gzip);

                    ds.AcceptChanges();

                    return ds;

                }

            }

        }

    }

}