.aspx:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>無標題頁</title> <script type="text/javascript"> //向服務器傳遞參數 function DoSearch(){ var firstName=document.getElementById("TextBox1").value; CallServer(firstName,""); } //得到服務器的數據 function ReceiveServerData(txtUserInfo){ Results.innerHTML=txtUserInfo; } //設置每1秒執行一次 setInterval("DoSearch()",1000); </script> </head> <body> <form id="form1" runat="server"> <div> 姓名:<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <br /> <span id="Results" style=" width:500px;"></span> </div> </form> </body> </html>[/code].aspx.cs[code]using System; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page, ICallbackEventHandler { protected string txtUserInfo; protected void Page_Load(object sender, EventArgs e) { //獲取一個對客戶端函數的引用 string cbReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "ReceiveServerData", "context"); //動態注冊回調函數 string callbackScript = "function CallServer(arg,context)" + "{" + cbReference + "};"; //引發callbackScript Page.ClientScript.RegisterStartupScript(this.GetType(), "CallServer", callbackScript, true); } //引發Callback事件處理 public void RaiseCallbackEvent(string txtFirstName) { if (txtFirstName != null) { String connString = System.Configuration.ConfigurationManager.ConnectionStrings["sqlserver2008"].ToString(); SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand comm = new SqlCommand("select * from zzx where [name]=@name", conn); comm.Parameters.Add("@name", SqlDbType.VarChar).Value = txtFirstName; SqlDataReader reader = comm.ExecuteReader(CommandBehavior.CloseConnection); if (reader.Read()) { txtUserInfo = "員工編號:" + reader["id"].ToString() + "<br>"; txtUserInfo += "員工姓名:" + reader["name"].ToString() + "<br>"; txtUserInfo += "地址:" + reader["address"].ToString() + "<br>"; txtUserInfo += "服務器查詢時間:" + DateTime.Now.ToString(); } else { if (string.IsNullOrEmpty(txtFirstName)) { txtUserInfo = "請輸入姓名"; } else { txtUserInfo = "查無此人"; } } comm.Dispose(); reader.Dispose(); conn.Dispose(); } } //得到回調的結果,返回給客戶端 public string GetCallbackResult() { return txtUserInfo; } }
新聞熱點
疑難解答
圖片精選
