页面之间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;