مبتدی: سوال در مورد لاگین [بایگانی]

NeDa Gholami

دوشنبه 28 آذر 1390, 16:46 عصر

سلام
لطفا ایراد این کد رو بهم بگید.. واسه چک کردن نام کاربری و لاگین هست

<%@ Page Language="C#‎" AutoEventWireup="true" CodeBehind="AjaxWebService.asmx" Inherits="WebApplication2.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 runat="server">
<title></title>
<link rel="stylesheet" type="text/css" href="Css/StyleSheet.css" />
<script src="Script/jquery-1.6.2.min.js" type="text/javascript"></script>
<script type="text/javascript">

$(document).ready(function () {
function Login() {

var user=$("#txtuser").val();
var pass=$("#txtpass").val();

$.ajax({
type: "Post",
url: "AjaxWebService.asmx/Login",
data:"{'UserName':'"+user+"','PassWord':'"+pass+"'}" ,
contentType: "application/json; charset=utf-8" ,
datatype: "json";
success: function(msg) {
if(msg.d==0)
{
$("#Result").text="این کاربر وجود ندارد";
}
else{
window.location.href="WebForm1.aspx"
}
},
failure:function(respons){
alert(respons.toString());
};

});
}
});
</script>
</head>
<body>
<form id="form1" runat="server">

<div class="mainDiv">
 Username: 
<input id="txtuser" type="text" />
<input
id="btnCheck" type="button" value="Check" onclick="javascript:Login()" />
</div>
<div id="Result">
Password: 
<asp:TextBox ID="txtpass" runat="server"></asp:TextBox>
</div>
</form>
</body>
</html>

کدهای AjaxWebService.asmx

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Collections;

namespace WebApplication2
{
/// <summary>
/// Summary description for AjaxWebService
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.ComponentModel.ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]
public class AjaxWebService : System.Web.Services.WebService
{
SqlConnection con = new SqlConnection("Data Source=NEDA-PC;Initial Catalog=Mydb;User ID=sa;Password=123");
[WebMethod]
public Boolean Login(string UserName, string PassWord)
{
con.Open();
Boolean b = new Boolean();
SqlCommand com = new SqlCommand("select * from Users where UserName='@UserName' and PassWord='@PassWord'", con);
com.Parameters.AddWithValue("@UserName", UserName);
com.Parameters.AddWithValue("@PassWord", PassWord);
SqlDataReader dr = com.ExecuteReader();
if (dr.HasRows)
{
b = true;
return b;
}
else { b = false;
return b;
}

}
}
}