<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="gvData" runat="server">
</asp:GridView>
</div>
</form>
</body>
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace AdoAsyncDB
{
/// <summary>
/// Poll方式
/// </summary>
public partial class PollMethod : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
UsePollMethod();
}
private void UsePollMethod()
{
SqlConnection connection;
SqlCommand sqlcommand = new SqlCommand();
SqlDataReader dataReader;
IAsyncResult asyncResult;
Response.Write("程序已启动……<br/>");
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["NorthWindDB"].ConnectionString);
sqlcommand.CommandText = "select companyName,contactName,city,postalCode from dbo.Customers";
sqlcommand.CommandType = CommandType.Text;
sqlcommand.Connection = connection;
connection.Open();
DateTime startDatetime = DateTime.Now;
asyncResult = sqlcommand.BeginExecuteReader(CommandBehavior.CloseConnection);
while (!asyncResult.IsCompleted)
{
Response.Write("正在取资料……<br/>");
Response.Flush();
System.Threading.Thread.Sleep(3000);
}
dataReader = sqlcommand.EndExecuteReader(asyncResult);
DateTime endDatetime = DateTime.Now;
TimeSpan timeSpan = endDatetime.Subtract(startDatetime);
Response.Write("资料取出完成,总其用时" + timeSpan.Milliseconds + "毫秒");
Response.Flush();
gvData.DataSource = dataReader;
gvData.DataBind();
connection.Close();
}
}
}