在网络上两个页面之间进行数据传递有很多中办法,这里我用了。net的现成方法,把表格数据传递到另外的页面。
db.table 数据 ——》dataset --》xml--》webrequest--》dataset
以下是发送数据页面代码
stringsql=@"select*,
DateAdd(minute,[RefreshIntervalTime],[LashRefreshTime])VLastRefreshTimefromWaitingRefresh
wheregetdate()<starttimeandendtime<getdate()";
DataSetds=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的过程:
WebRequestrequest=WebRequest.Create(url);
//Ifrequiredbytheserver,setthecredentials.
request.Credentials=CredentialCache.DefaultCredentials;
//Gettheresponse.
HttpWebResponseresponse=(HttpWebResponse)request.GetResponse();
//Displaythestatus.
Console.WriteLine(response.StatusDescription);
//Getthestreamcontainingcontentreturnedbytheserver.
StreamdataStream=response.GetResponseStream();
//OpenthestreamusingaStreamReaderforeasyaccess.
StreamReaderreader=newStreamReader(dataStream);
//Readthecontent.
//stringresponseFromServer=reader.ReadToEnd();
/**/////Displaythecontent.
//Console.WriteLine(responseFromServer);
/**/////Cleanupthestreamsandtheresponse.

////Response.Write(responseFromServer);
DataSetds=newDataSet();

ds.ReadXml(reader);
//ds.WriteXml(Response.OutputStream,XmlWriteMode.IgnoreSchema);
//Response.Write(ds.Tables[0].Rows[0][0].ToString());
reader.Close();
dataStream.Close();
response.Close();
returnds;
7324

被折叠的 条评论
为什么被折叠?



