raziee
پنج شنبه 04 تیر 1388, 12:54 عصر
سلام. ببین اینها به دردت میخوره؟
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" %>
<!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>Login Page</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
</head>
<body style="font-family:Tahoma; font-size:8pt; text-align:center; background-color:#EEFFFF" dir="rtl">
<form id="form1" runat="server">
<div style="width:220px;">
<asp:MultiView ID="MultiViewLogin" runat="server" ActiveViewIndex="0">
<asp:View ID="ViewLogin" runat="server">
<fieldset>
<legend>ورود کاربری</legend>
<table>
<tr>
<td>نام کاربری :</td>
<td>
<asp:TextBox ID="txtUserName" runat="server" Font-Names="tahoma"
Font-Size="8pt" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvUserName" runat="server" ErrorMessage="*"
ControlToValidate="txtUserName"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>گذرواژه :</td>
<td>
<asp:TextBox ID="txtPassword" runat="server" Font-Names="tahoma"
Font-Size="8pt" TextMode="Password" Width="120px"></asp:TextBox>
<asp:RequiredFieldValidator ID="rfvPassword" runat="server" ErrorMessage="*"
ControlToValidate="txtPassword"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td colspan="2">
<asp:CheckBox ID="chkMember" runat="server" Text="مرا به خاطر بسپار" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="lblError" runat="server" ForeColor="Red"
Text="نام کاربری و یا گذرواژه صحیح نمیباشد." Visible="False"></asp:Label>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnLogin" runat="server" Font-Names="tahoma" Font-Size="8pt"
Text="ورود" Width="100px" onclick="btnLogin_Click" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:LinkButton ID="lbtnForgetPass" runat="server">فراموش کردن گذرواژه</asp:LinkButton>
</td>
</tr>
</table>
</fieldset>
</asp:View>
<asp:View ID="ViewForgetMe" runat="server">
</asp:View>
</asp:MultiView>
</div>
</form>
</body>
</html>
protected void btnLogin_Click(object sender, EventArgs e)
{
lblError.Visible = false;
string UserName = txtUserName.Text.Trim().ToString();
string Password = txtPassword.Text.Trim().ToString();
MemberMe myMember = new MemberMe();
if (myMember.GetMemberAuthentication(UserName, Password))
FormsAuthentication.RedirectFromLoginPage(UserName , chkMember.Checked);
else
lblError.Visible = true;
}
یه کلاس برای لاگین درست کرده بودم که کد مهمش این بود.
public bool GetMemberAuthentication(string UserName, string Password)
{
using (SqlConnection myCon = new SqlConnection(ConfigurationManager.ConnectionStrin gs["TestDB"].ConnectionString.ToString()))
{
bool RetValue = false;
SqlCommand myCom = new SqlCommand();
myCom.Connection = myCon;
myCom.CommandType = CommandType.StoredProcedure;
myCom.CommandText = "sp_Login";
myCom.Parameters.AddWithValue("@UserName", UserName);
myCom.Parameters.AddWithValue("@Password", Password);
SqlDataAdapter myDA = new SqlDataAdapter();
myDA.SelectCommand = myCom;
DataTable myDT = new DataTable();
myCon.Open();
myCom.ExecuteNonQuery();
myDA.Fill(myDT);
myCon.Close();
DataView myDV = new DataView(myDT);
if (myDV.Count == 1)
RetValue = true;
return RetValue;
}
}