来源:http://blog.csdn.net/bayaci/archive/2007/12/19/1953842.aspx
在网络上两个页面之间进行数据传递有很多中办法,这里我用了。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);
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;
// 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;