页面之间dataset数据传递方法

桃扇骨 2022-08-25 08:07 191阅读 0赞

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

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

以下是发送数据页面代码

![None.gif][]          string  sql  =   @" select \*,  
![None.gif][]                    DateAdd(minute,\[RefreshIntervalTime\],\[LashRefreshTime\]) VLastRefreshTime from WaitingRefresh    
![None.gif][]         where getdate()<starttime and endtime<getdate() " ;  
![None.gif][]  
![None.gif][]        DataSet ds  =  DataRepository.Provider.ExecuteDataSet(CommandType.Text, sql);  
![None.gif][]  
![None.gif][]         // Response.Write(ds.Tables\[0\].Rows.Count.ToString());   
![None.gif][]         Response.Clear();  
![None.gif][]        Response.ContentType  =   " text/xml " ;  
![None.gif][]        Response.Charset  =   " UTF-8 " ;   
![None.gif][]  
![None.gif][]  
![None.gif][]        ds.WriteXml(Response.OutputStream, XmlWriteMode.IgnoreSchema);

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

![None.gif][] WebRequest request  =  WebRequest.Create(url);  
![None.gif][]             //  If required by the server, set the credentials.   
![None.gif][]             request.Credentials  =  CredentialCache.DefaultCredentials;  
![None.gif][]             //  Get the response.   
![None.gif][]             HttpWebResponse response  =  (HttpWebResponse)request.GetResponse();  
![None.gif][]             //  Display the status.   
![None.gif][]             Console.WriteLine(response.StatusDescription);  
![None.gif][]             //  Get the stream containing content returned by the server.   
![None.gif][]             Stream dataStream  =  response.GetResponseStream();  
![None.gif][]             //  Open the stream using a StreamReader for easy access.   
![None.gif][]             StreamReader reader  =   new  StreamReader(dataStream);  
![None.gif][]             //  Read the content.  
![None.gif][]             // string responseFromServer = reader.ReadToEnd();   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]              /\*\*/ //// Display the content.  
![None.gif][]              // Console.WriteLine(responseFromServer);   
![ExpandedBlockStart.gif][]![ContractedBlock.gif][]              /\*\*/ //// Cleanup the streams and the response.  
![InBlock.gif][]  
![InBlock.gif][]  
![ExpandedBlockEnd.gif][]            ////Response.Write(responseFromServer);  
![None.gif][]   
![None.gif][]            DataSet ds  =   new  DataSet();  
![None.gif][]  
![None.gif][]  
![None.gif][]            ds.ReadXml(reader);  
![None.gif][]  
![None.gif][]             //  ds.WriteXml(Response.OutputStream, XmlWriteMode.IgnoreSchema);  
![None.gif][]  
![None.gif][]             // Response.Write(ds.Tables\[0\].Rows\[0\]\[0\].ToString());   
![None.gif][]   
![None.gif][]            reader.Close();  
![None.gif][]            dataStream.Close();  
![None.gif][]            response.Close();  
![None.gif][]  
![None.gif][]             return  ds;

[None.gif]: /images/20220824/1bf0b038b444479ea539e42898d9f15c.png
[ExpandedBlockStart.gif]: http://images.csdn.net/syntaxhighlighting/OutliningIndicators/ExpandedBlockStart.gif
[ContractedBlock.gif]: /images/20220824/e7f3b4ed929c41f6a56a2c3a5d551755.png
[InBlock.gif]: /images/20220824/50a5c33f92cc452c8f7984e5411bacf0.png
[ExpandedBlockEnd.gif]: /images/20220824/d70d15a685144d5cb055eafa4664b043.png