在网络上两个页面之间进行数据传递有很多中办法,这里我用了。net的现成方法,把表格数据传递到另外的页面。
db.table 数据 ——》dataset --》xml--》webrequest--》dataset
以下是发送数据页面代码
string
sql
=
@"
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);
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 = new StreamReader(dataStream);
// Readthecontent.
// stringresponseFromServer=reader.ReadToEnd();
/**/ ////Displaythecontent.
// Console.WriteLine(responseFromServer);
/**/ ////Cleanupthestreamsandtheresponse.
////Response.Write(responseFromServer);
DataSetds = 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;
// Ifrequiredbytheserver,setthecredentials.
request.Credentials = CredentialCache.DefaultCredentials;
// Gettheresponse.
HttpWebResponseresponse = (HttpWebResponse)request.GetResponse();
// Displaythestatus.
Console.WriteLine(response.StatusDescription);
// Getthestreamcontainingcontentreturnedbytheserver.
StreamdataStream = response.GetResponseStream();
// OpenthestreamusingaStreamReaderforeasyaccess.
StreamReaderreader = new StreamReader(dataStream);
// Readthecontent.
// stringresponseFromServer=reader.ReadToEnd();
/**/ ////Displaythecontent.
// Console.WriteLine(responseFromServer);
/**/ ////Cleanupthestreamsandtheresponse.
////Response.Write(responseFromServer);
DataSetds = 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;