SET ANSINULLS ONGOSET QUOTEDIDENTIFIER ONGOCREATE PROCEDURE dboCheckUsername Email VARCHAR255ASBEGIN SET NOCOUNT ON IF NOT EXISTS SELECT FROM TCreateProfile WHERE Email Email SELECT 39true39 ELSE SELECT 39false39ENDGOltSystemWebServicesWebMethodgt Public Shared Function CheckUserNameByVal userName As String As String Dim returnValue As String StringEmpty Try

Hi powerHere i have created complete sample Refer the below codeHTMLlthtml xmlns34httpwwww3org1999xhtml34gtlthead runat34server34gt lttitlegtlttitlegt ltscript type34textjavascript34gt windowonload function Test PageMethodsCheckUserNamedocumentgetElementById34lttxtUsernameClientIDgt34value UsernameOnSuccess function UsernameAvailability PageMethodsCheckUserNamedocumentgetElementById34lttxtUsernameClientIDgt34value UsernameOnSuccess function UsernameOnSuccessresponse var mesg documentgetElementById34UsernameCheck34 if documentgetElementById34lttxtUsernameClientIDgt34valuelength gt 0 switch response case 34true34 mesgstylecolor 34green34 mesginne

Check Username availability in Page Load and keyup based on TextBox value using AJAX PageMethods in ASP.Net

power

SOLVED CLOSED ACTIVE ANSWERED
User: power
Posted: on Aug 10, 2017 09:56 PM
Forum: ASP.Net AJAX
Answer: 2
Views: 6477
Sample Code: Download

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE dbo.CheckUsername
     @Email VARCHAR(255)
AS
BEGIN
      SET NOCOUNT ON;
      IF NOT EXISTS
            (SELECT * FROM T_Create_Profile
             WHERE Email = @Email
            )
            SELECT 'true'
      ELSE
            SELECT 'false'
END
GO


<System.Web.Services.WebMethod()> _
    Public Shared Function CheckUserName(ByVal userName As String) As String
        Dim returnValue As String = String.Empty
        Try
            Dim consString As String = ConfigurationManager.ConnectionStrings("ConString").ConnectionString
            Dim conn As New SqlConnection(consString)
            Dim cmd As New SqlCommand("CheckUsername", conn)
            cmd.CommandType = CommandType.StoredProcedure
            cmd.Parameters.AddWithValue("@Username", userName.Trim())
            conn.Open()
            returnValue = cmd.ExecuteScalar().ToString()
            conn.Close()
        Catch
            returnValue = "error"
        End Try
        Return returnValue
    End Function

<script type="text/javascript">
        function UsernameAvailability() {
            PageMethods.CheckUserName(document.getElementById("<%=txtUsername.ClientID%>").value, Username_OnSuccess);
        }
        function Username_OnSuccess(response) {
            var mesg = document.getElementById("Username_Check");
            
            switch (response) {
                case "true":
                    mesg.style.color = "";
                    mesg.innerHTML = "";
                    break;
                case "false":
                    mesg.style.color = "red";
                    mesg.innerHTML = "Username already taken.";
                    break;
            }
        }
        function Username_OnChange(txt) {
            document.getElementById("Username_Check").innerHTML = "";
        }
    </script>

                            
<span id="Username_Check"></span>

                            
<asp:TextBox ID="txtUsername" runat="server" onkeyup="Username_OnChange(this);UsernameAvailability();" ondrop="return false;" onpaste="return false;"></asp:TextBox>

I created a table called T_Create_Profile and in the table I added a column called Username. Then I added a data under Username called Will. Now After I run the program and typed “Will” into the textbox I was hoping to see the message saying “Username already taken” but I don’t see any message. Am I doing anything wrong?

By the way I tried to follow one of your tutorials titled “Check Username Availability in ASP.Net using AJAX PageMethods” but no luck. Please help.

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

power

0 6

Reply
User: power
Replied: on Aug 14, 2017 05:24 AM
Report

Thank you for catching my mistake. I must have been blinded by something.... The thing is yesterday I caught the mistake I made in the procedure and corrected it to @Username but then I realized that I had other mistake and I want to tell you guys because it might help others from making similar mistake. I tried to use updatepanel with webpages and this two don't work together. Then I removed the updatepanel and it starts to work well. The issue I have now is the page flickers because I removed updatepanel. How do i prevent page flickering when I click submit button without updatepanel? Thanks.

dharmend...

0 7

Reply
User: dharmendr
Replied: on Aug 14, 2017 08:49 AM
Report

I have checked the code by putting the controls inside update panel. Its working. So if you have the error please provide screenshot.

power

0 8

Reply
User: power
Replied: on Aug 14, 2017 11:21 AM
Report

The onkeyup event is what is giving me issue. When the page initialy loads, the stored procedure doesn't detect if the username is already taken. The stored procedure starts to work if I first clicked the submit button. It is confussing me why it is doing that.

I guess my question should be what is the correct way to make the stored procedure work when the page initially loads so the stored procedure detects the useranme textbox even at the initial page load? I amasking this because currently the stored procedure doesn't work when the pages initialy loads.

dharmend...

0 10

Reply
ANSWER
User: dharmendr
Replied: on Aug 16, 2017 03:39 AM
Report

Hi power,

You need to add the below line of code inside the script. So when the palod finish it will check the UserName availability based on the TextBox value.

window.onload = function UsernameAvailability() {
    PageMethods.CheckUserName(document.getElementById("<%=txtUsername.ClientID%>").value, Username_OnSuccess);
}

power

0 11

Reply
User: power
Replied: on Aug 16, 2017 07:38 PM
Report

Hi dharmendr,

Thank you so much for your help. You have been a great help in the past as well. The good news is the solution you provided me actually solved half of my problem. Just like you said I added the code into the script and then whenever the page loads it keeps the txtUsername value and automatically activates the stored procedure. In the past, it never automatically activates the stored procedure on page load/refresh. So that part is solved. However, the issue I still have is I still have to enter value in the txtUsername and then click the submit button. Only then the stored procedure gets activated.

But what I want is the stored procedure to be active even when you first browse and the website opens for the first time. Then you type a name in the txtUsername textbox and if similar name exists in database, the <span id="Username_Check"> automatically displays the message “Username already taken.” without clicking the Submit button. That is the problem I couldn’t solve. I tried to change the onkeyup attribute to oninput but no luck. The only way it works right now is if I enter the name into the textbox and then click the submit button. But I want it to detect without clicking the button. Hope you better understand my issue now. You already solved half the problem!

Thank you in advance for your help

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

Check Username availability in Page Load and keyup based on TextBox value using AJAX PageMethods in ASP.Net

Company

Explore

Follow us

Contact Us