profnami
دوشنبه 19 مهر 1389, 19:33 عصر
دوستان من میخوام موقع ثبت نام چک کنم نام کاربری تکراریه یا نه . با وب سرویس اینها رو نوشتم
public class CheckUsername : System.Web.Services.WebService {
public CheckUsername () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
//public string HelloWorld() {
// return "Hello World";
//}
public int CheckUser(string Username)
{
string query = "SELECT COUNT(*) FROM Users WHERE UserName=@UserName";
using (SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigur ationManager.ConnectionStrings["myDBCon"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@UserName", Username);
conn.Open();
return (int)cmd.ExecuteScalar();
}
}
}
}
function checkUser() {
$.ajax({
type: "POST",
url: "CheckUsername.asmx/CheckUser",
data: "{username: 'nader'}", //" + $('#UserName').val() + "
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
$("#duplicate").empty();
if (response.d != "0") {
$("#duplicate").html(' That user name has already been taken');
}
}
});
}
[/code]
<asp:TextBox ID="UserName" runat="server" onblur="checkUser();"></asp:TextBox>
دوستان راهنمایی میکنند یا راه بهتری دارند؟
public class CheckUsername : System.Web.Services.WebService {
public CheckUsername () {
//Uncomment the following line if using designed components
//InitializeComponent();
}
[WebMethod]
//public string HelloWorld() {
// return "Hello World";
//}
public int CheckUser(string Username)
{
string query = "SELECT COUNT(*) FROM Users WHERE UserName=@UserName";
using (SqlConnection conn = new SqlConnection(System.Web.Configuration.WebConfigur ationManager.ConnectionStrings["myDBCon"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@UserName", Username);
conn.Open();
return (int)cmd.ExecuteScalar();
}
}
}
}
function checkUser() {
$.ajax({
type: "POST",
url: "CheckUsername.asmx/CheckUser",
data: "{username: 'nader'}", //" + $('#UserName').val() + "
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
$("#duplicate").empty();
if (response.d != "0") {
$("#duplicate").html(' That user name has already been taken');
}
}
});
}
[/code]
<asp:TextBox ID="UserName" runat="server" onblur="checkUser();"></asp:TextBox>
دوستان راهنمایی میکنند یا راه بهتری دارند؟