01 using System; 02 using System.Data; 03 using System.Configuration; 04 using System.Collections; 05 using System.Web; 06 using System.Web.Security; 07 using System.Web.UI; 08 using System.Web.UI.WebControls; 09 using System.Web.UI.WebControls.WebParts; 10 using System.Web.UI.HtmlControls; 11 using System.Data.SqlClient;
12 public partial class ClientCallbacksSimple : System.Web.UI.Page, 13 13 System.Web.UI.ICallbackEventHandler 14 { 15 protected string strUserInfo; //保存读取的用户信息 16 //引发回调事件 17 public void RaiseCallbackEvent(string txtFirstName) 18 { 19 if (txtFirstName != null) 20 { 21 SqlConnection conn = new SqlConnection("data source=localhost;initial 22 catalog=Northwind;integrated security=SSPI"); 23 conn.Open();
24 SqlCommand cmd = new SqlCommand("select EmployeeID,FirstName,City,Address 25 25 from Employees where FirstName=@FirstName", conn); 26 cmd.Parameters.Add("@FirstName", SqlDbType.NVarChar, 10).Value = txtFirstName; 27 SqlDataReader dr = cmd.ExecuteReader();