页面之间dataset数据传递方法

在网络上两个页面之间进行数据传递有很多中办法，这里我用了。net的现成方法，把表格数据传递到另外的页面。

 

 db.table 数据 ——》dataset －－》xml－－》webrequest－－》dataset

以下是发送数据页面代码

 

        string sql = @"select *,
                    DateAdd(minute,[RefreshIntervalTime],[LashRefreshTime]) VLastRefreshTime from WaitingRefresh  
         where getdate()<starttime and endtime<getdate()";

        DataSet ds = DataRepository.Provider.ExecuteDataSet(CommandType.Text, sql);

        //Response.Write(ds.Tables[0].Rows.Count.ToString());
        Response.Clear();
        Response.ContentType = "text/xml";
        Response.Charset = "UTF-8"; 


        ds.WriteXml(Response.OutputStream, XmlWriteMode.IgnoreSchema);

以下是获取根据上面的页面，把数据还原到dataset的过程：

 

WebRequest request = WebRequest.Create(url);
            // If required by the server, set the credentials.
            request.Credentials = CredentialCache.DefaultCredentials;
            // Get the response.
            HttpWebResponse response = (HttpWebResponse)request.GetResponse();
            // Display the status.
            Console.WriteLine(response.StatusDescription);
            // Get the stream containing content returned by the server.
            Stream dataStream = response.GetResponseStream();
            // Open the stream using a StreamReader for easy access.
            StreamReader reader = new StreamReader(dataStream);
            // Read the content.
            //string responseFromServer = reader.ReadToEnd();
            /**///// Display the content.
            //Console.WriteLine(responseFromServer);
            /**///// Cleanup the streams and the response.


            ////Response.Write(responseFromServer);

            DataSet ds = new DataSet();


            ds.ReadXml(reader);

            // ds.WriteXml(Response.OutputStream, XmlWriteMode.IgnoreSchema);

            //Response.Write(ds.Tables[0].Rows[0][0].ToString());

            reader.Close();
            dataStream.Close();
            response.Close();

            return ds;