載入Loading Bar
<%@ Page Language="C#" Debug="true"%>
<%@ Import Namespace="System" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.Sql" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button99_Click(object sender, EventArgs e)
{
SqlConnection objConn = new SqlConnection(ConfigurationManager.ConnectionStrings["ProductionConnectionString"].ConnectionString);
string queryString = "select TOP 2000 * from Sales.Customer";
SqlCommand objCmd = new SqlCommand(queryString, objConn);
objConn.Open();
SqlDataReader objRdr = objCmd.ExecuteReader();
string r_CustomerID, r_TerritoryID, r_AccountNumber, r_CustomerType, r_rowguid;
while (objRdr.Read())
{
r_CustomerID = objRdr["CustomerID"].ToString();
r_TerritoryID = objRdr["TerritoryID"].ToString();
r_AccountNumber = objRdr["AccountNumber"].ToString();
r_CustomerType = objRdr["CustomerType"].ToString();
r_rowguid = objRdr["rowguid"].ToString();
Label99.Text += r_CustomerID + " " + r_TerritoryID + " " + r_AccountNumber + " " + r_CustomerType + " " + r_rowguid + "<br>";
}
objConn.Close();
}
</script>
<html>
<head runat="server">
<script type="text/javascript">
function ShowWaitDisplay()
{
document.getElementById('form1').style.display='none';
document.getElementById('loading').style.display='inline';
setTimeout('document.images["WaitImage"].src = "images/pleasewait.gif"', 900); //設定setTimeout是因為IE上的動畫gif無法動
return true;
}
</script>
<style type="text/css">
#loading {
width:100%;
top:0px;
text-align:center;
padding:7px 0 0 0;
font:bold 11px Arial, Helvetica, sans-serif;
}
</style>
</head>
<body>
<div id="loading" style="display:none">
<center>
Loading Data, please wait...<br>
<img id="WaitImage" src="images/pleasewait.gif" alt="loading..." />
</center>
</div>
<form id="form1" runat="server">
<asp:Button ID="Button99" runat="server" OnClick="Button99_Click" OnClientClick="ShowWaitDisplay();" Text="取值" /><BR>
<asp:Label ID="Label99" runat="server" Text="" />
</form>
</body>
</html>
留言列表
