Sub CheckAccount(sender As Object, e As ServerValidateEventArgs ) Dim objConn As New sqlConnection() objConn.ConnectionString = "Data Source=localhost;" & _ "Initial Catalog=sms2cn;User ID=sa;Password=807713" objConn.Open() Dim objCmd As New sqlCommand() objCmd.Connection = objConn objCmd.CommandText = "Select distinct * From S_usr_jp Where C_login_id='" & C_login_id.Text & "'" Dim objReader As sqlDataReader = objCmd.ExecuteReader() e.IsValid = Not(objReader.Read()) objReader.Close() objConn.Close() end sub<Asp:textbox Runat="Server" id="C_login_id" readonly="true" /> <Asp:CustomValidator Runat="Server" OnServerValidate="CheckAccount" ErrorMessage="您的用户名已存在" ControlToValidate="C_login_id" id="yanzheng" />
也不知道这样的方法行不行,我刚学.net刚好在做自定义服务器端验证的例子。
objConn.ConnectionString = "Data Source=localhost;" & _
"Initial Catalog=sms2cn;User ID=sa;Password=807713"
objConn.Open()
Dim objCmd As New sqlCommand()
objCmd.Connection = objConn
objCmd.CommandText = "Select distinct * From S_usr_jp Where C_login_id='" & C_login_id.Text & "'"
Dim objReader As sqlDataReader = objCmd.ExecuteReader()
e.IsValid = Not(objReader.Read())
objReader.Close()
objConn.Close()
end sub<Asp:textbox Runat="Server" id="C_login_id" readonly="true" />
<Asp:CustomValidator Runat="Server" OnServerValidate="CheckAccount" ErrorMessage="您的用户名已存在" ControlToValidate="C_login_id" id="yanzheng" />