welcome every body we enjoy programming online help .
drhow
بالمرفقات
Preview of Code
CREATE PROCEDURE CheckUserName( @User_Name VARCHAR(50) ) AS BEGIN IF EXISTS (SELECT * FROM User_Table WHERE [User_Name] = @User_Name ) SELECT '1'; --user name already exist in database ELSE SELECT '0'; --user name does not exist in database END <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Register.aspx.cs" Inherits="_Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head id="Head1" runat="server"> <title></title> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.0/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { $("#<%=txtUserName.UniqueID%>").change(function() { var uname = $("#<%=txtUserName.UniqueID%>"); var msgbox = $("#status"); if (uname.val().length > 5) { $.ajax({ type: "POST", url: "Register.aspx/CheckUserName", data: "{'args': '" + uname.val() + "'}", contentType: "application/json; charset=utf-8", dataType: "json", success: function(msg) { if (msg.d == 'Available') { uname.removeClass("notavailablecss"); uname.addClass("availablecss"); msgbox.html('<img src="Images/a.png"> <font color="Green"> Available </font>'); } else { uname.removeClass("availablecss"); uname.addClass("notavailablecss"); msgbox.html(msg.d); } } }); } else { uname.addClass("notavailablecss"); msgbox.html('<font color="#cc0000">User Name must be more than 5 characters</font>'); } }); }); </script> <style type="text/css"> body { font-family:Arial, Helvetica, sans-serif } #status { font-size:11px; margin:10px; } .availablecss { background-color:#CEFFCE; border:1px solid green; } .notavailablecss { background-color:#FFD9D9; border:1px solid red; } </style> </head> <body> <form id="form1" runat="server"> <br /> <br /> <br /> User Name : <asp:TextBox ID="txtUserName" runat="server"></asp:TextBox> <span id="status"></span> </form> </body> </html> using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Configuration; using System.Data; using System.Data.SqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } [System.Web.Services.WebMethod] public static string CheckUserName(string args) { string returnValue = string.Empty; string conString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString; SqlConnection sqlConn = new SqlConnection(conString); try { SqlCommand sqlCmd = new SqlCommand("CheckUserName", sqlConn); sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@User_Name", args.Trim()); sqlConn.Open(); int success = int.Parse((sqlCmd.ExecuteScalar().ToString())); if (success == 1) // User Name Not Available { returnValue = "<img src='Images/n.png'> <font color='#cc0000'><b>'" + args + "'</b> is already in use.</font></img>"; } else if (success == 0)//User_Name is available { returnValue = "Available"; } } catch { //Handle Error } finally { sqlConn.Close(); } return returnValue; } }