Check Username availability (exists) on TextChanged event of TextBox in ASP.Net

simflex

SOLVED CLOSED ACTIVE ANSWERED
User: simflex
Posted: on Dec 10, 2017 10:37 PM
Forum: ASP.Net Web Forms
Answer: 1
Views: 7892
Sample Code: Download

Greetings again,

We use the following code to check whether or not user exists on our database.

Upon the mouse leaving a textbox, if user already exists, a message indicating that user already exists is displayed.

If user does not exist, user gets a "Proceed" message.

This works great.

What we are having problem with right now is that if user exists, we would like the user information (name, title, email, ID) to populate the textboxes upon the mouse leaving the ID textbox.

The code I have so far is not working - it doesn't populate the textboxes after the check.

What am I missing?

We would prefer to NOT create a search box to do this.

Thanks much in advance.

HTML

<td>
	<div class="input text">
		<label id="lblEmpID"><span style="font-weight:bold;font-size:16px;color:#000000;">Your Id</span><span style="color:#ff0000">*</span></label>
		<asp:TextBox ID="txtEmpID" placeholder="Badge ID..." style="width:100px;" class="form-control numeric" runat="server"  AutoPostBack="true" ontextchanged="txtEmpID_TextChanged"></asp:TextBox>
		<asp:RequiredFieldValidator id="RequiredempidValidator1" Font-Bold="true" SetFocusOnError="true" runat="server"
		 ErrorMessage="*" ControlToValidate="txtEmpID" />
		<span class="waitingdiv" id="loadingdiv" style="display:none;"><img src="images/ajax-loader.gif" alt="Loading" />Please wait...</span><br />
	</div>
</td>
<td>
	<div id="checkusername" runat="server"  Visible="false">
		<asp:Image ID="imgstatus" runat="server" Width="17px" Height="17px"/>
		<asp:Label ID="lblStatus" runat="server"></asp:Label>
	</div>
</td>

Code (VB.Net)

Protected Sub txtEmpID_TextChanged(sender As Object, e As EventArgs)
    If Not String.IsNullOrEmpty(txtEmpID.Text) Then
        Dim Conn As SqlConnection
        'Read in connection String
        Conn = New SqlConnection(ConfigurationManager.ConnectionStrings("ppmtest").ConnectionString)
        Conn.Open()
        Dim cmd As New SqlCommand("select * from Employees where EmpID=@empID", Conn)
        cmd.Parameters.AddWithValue("@empID", txtEmpID.Text)
        Dim dr As SqlDataReader = cmd.ExecuteReader()
        If dr.HasRows Then
            checkusername.Visible = True
            imgstatus.ImageUrl = "images/NotAvailable.jpg"
            lblStatus.Text = "You have already signed up"
            lblStatus.ForeColor = System.Drawing.Color.Red
            System.Threading.Thread.Sleep(100)
            'txteName.Text = dr("employeeName").ToString()
            'txttitle.Text = dr("empTitle").ToString()
            'txtemail.Text = dr("email").ToString()
            'txtEmpID.Text = dr("empID").ToString()
        Else
            checkusername.Visible = True
            imgstatus.ImageUrl = "images/Icon_Available.gif"
            lblStatus.Text = "Proceed"
            System.Threading.Thread.Sleep(100)
        End If
    Else
        checkusername.Visible = False
    End If
End Sub

Download FREE API for Word, Excel and PDF in ASP.Net

kalpesh

0 2

Reply
ANSWER
User: kalpesh
Replied: on Dec 11, 2017 03:54 AM
Modified: on Dec 11, 2017 04:04 AM
Report

Refer the below Sample code for your reference and implement it as per your code logic.

HTML

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <table>
            <tr>
                <td>
                    <div class="input text">
                        <label id="lblEmpID">
                            <span style="font-weight: bold; font-size: 16px; color: #000000;">Your Id</span><span
                                style="color: #ff0000">*</span></label>
                        <asp:TextBox ID="txtEmpID" placeholder="Badge ID..." Style="width: 100px;" class="form-control numeric"
                            runat="server" AutoPostBack="true" OnTextChanged="txtUserID_TextChanged"></asp:TextBox>
                        <asp:RequiredFieldValidator ID="RequiredempidValidator1" Font-Bold="true" SetFocusOnError="true"
                            runat="server" ErrorMessage="*" ControlToValidate="txtEmpID" />
                        <span class="waitingdiv" id="loadingdiv" style="display: none;">
                            <img src="images/ajax-loader.gif" alt="Loading" />Please wait...</span><br />
                    </div>
                </td>
                <td>
                    <div id="checkusername" runat="server" visible="false">
                        <asp:Image ID="imgstatus" runat="server" Width="17px" Height="17px" />
                        <asp:Label ID="lblStatus" runat="server"></asp:Label>
                    </div>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <label id="lblUserName">
                        <span style="font-weight: bold; font-size: 16px; color: #000000;">User Name</span>
                    </label>
                    <asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>
                </td>
            </tr>
            <tr>
                <td colspan="2">
                    <label id="lblEmail">
                        <span style="font-weight: bold; font-size: 16px; color: #000000;">Email</span>
                    </label>
                    <asp:TextBox ID="txtemail" runat="server" Width="250px"></asp:TextBox>
                </td>
            </tr>
        </table>
    </div>
    </form>
</body>
</html>

protected void txtUserID_TextChanged(object sender, EventArgs e)
{
    if (!string.IsNullOrEmpty(txtEmpID.Text))
    {
        SqlConnection Conn;
        Conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr4"].ConnectionString);
        Conn.Open();
        SqlCommand cmd = new SqlCommand("SELECT * FROM Users Where UserId = @UserId ", Conn);
        cmd.Parameters.AddWithValue("@UserId", txtEmpID.Text);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.HasRows)
        {
            dr.Read();
            checkusername.Visible = true;
            imgstatus.ImageUrl = "images/NotAvailable.png";
            lblStatus.Text = "You have already signed up";
            lblStatus.ForeColor = System.Drawing.Color.Red;
            System.Threading.Thread.Sleep(100);
            txtUserName.Text = dr["Username"].ToString();
            txtemail.Text = dr["email"].ToString();
            txtEmpID.Text = dr["UserId"].ToString();
        }
        else
        {
            checkusername.Visible = true;
            imgstatus.ImageUrl = "images/Available.png";
            lblStatus.Text = "Proceed";
            System.Threading.Thread.Sleep(100);
            txtUserName.Text = "";
            txtemail.Text = "";

        }
        Conn.Close();
    }
    else
    {
        checkusername.Visible = false;
    }
}

VB.Net

Protected Sub txtUserID_TextChanged(ByVal sender As Object, ByVal e As EventArgs)
    If Not String.IsNullOrEmpty(txtEmpID.Text) Then
        Dim Conn As SqlConnection
        Conn = New SqlConnection(ConfigurationManager.ConnectionStrings("ConStr4").ConnectionString)
        Conn.Open()
        Dim cmd As SqlCommand = New SqlCommand("SELECT * FROM Users Where UserId = @UserId ", Conn)
        cmd.Parameters.AddWithValue("@UserId", txtEmpID.Text)
        Dim dr As SqlDataReader = cmd.ExecuteReader()
        If dr.HasRows Then
            dr.Read()
            checkusername.Visible = True
            imgstatus.ImageUrl = "images/NotAvailable.png"
            lblStatus.Text = "You have already signed up"
            lblStatus.ForeColor = System.Drawing.Color.Red
            System.Threading.Thread.Sleep(100)
            txtUserName.Text = dr("Username").ToString()
            txtemail.Text = dr("email").ToString()
            txtEmpID.Text = dr("UserId").ToString()
        Else
            checkusername.Visible = True
            imgstatus.ImageUrl = "images/Available.png"
            lblStatus.Text = "Proceed"
            System.Threading.Thread.Sleep(100)
            txtUserName.Text = ""
            txtemail.Text = ""
        End If

        Conn.Close()
    Else
        checkusername.Visible = False
    End If
End Sub

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Check Username availability (exists) on TextChanged event of TextBox in ASP.Net

Company

Explore

Follow us

Contact Us