再问textbox中的ontextchanged是怎样写的
原问题请看
http://community.csdn.net/Expert/topic/3198/3198087.xml?temp=.631695
因CSDN系统不让连续三次回复,只好在此再开一个了,续上次内容:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
namespace HTRL
{
/// <summary>
/// inputUser 的摘要说明。
/// </summary>
public class userAdd : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox userID;
protected System.Web.UI.WebControls.DropDownList tollCollectorDLst;
protected System.Web.UI.WebControls.RadioButton separateValveYes;
protected System.Web.UI.WebControls.RadioButton separateValveNo;
protected System.Web.UI.WebControls.RadioButton islargeNo;
protected System.Web.UI.WebControls.TextBox buildingName;
protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
protected System.Web.UI.HtmlControls.HtmlGenericControl DIV1;
protected System.Web.UI.HtmlControls.HtmlGenericControl Message;
protected System.Web.UI.WebControls.RadioButton islargeYes;
/*SqlConnection htrlconn=new SqlConnection("Data Source=localhost;Database=HTRL_2003;UserID=sa;Password=hotnet;ConnetctionTimeout=15");
SqlCommand useridCommand=new SqlCommand("select userID from TB_UseriInfo where userID=15023020102");
useridCommand.Connection.Open();
SqlDateReader useridReader;
useridReader=useridCommand.ExecuteReader();
*/
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.userID.TextChanged += new System.EventHandler(this.userID_TextChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
public string userText
{
get
{
return userID.Text;
}
set
{
userID.Text=value;
}
}
public void userID_TextChanged(object sender, System.EventArgs e)
{
string SQL;
SqlConnection htrlConn=new SqlConnection("Data Source=localhost;Database=HTRL_2003;User ID=sa;Password=hotnet");
SQL="select userID from TB_UserInfo where userID='"+userText+"'";
SqlCommand useridCommand=new SqlCommand(SQL,htrlConn);
useridCommand.Connection.Open();
SqlDataReader useridReader;
useridReader=useridCommand.ExecuteReader();
if(useridReader.Read())
{
Response.Write("<Script>alert('此用户已存在')</Script>");
useridReader.Close();
}
else
{
//我想将下一个文本框设为焦点,实际操作中在前一个Textbox中按TAB键后,焦点没停留在任何地方;
}
}
}
}