登陆的实现

///<summary>

/// 验证顾客登陆

/// </summary>

/// <param name="SqlStr">查询语句</param>

/// <returns>指定顾客数据集</returns>

public DataSet CustomerLogin(string SqlStr)

{

SqlCommand comm = new SqlCommand(SqlStr,conn);

SqlDataAdapter adapter = newSqlDataAdapter(comm);

DataSet DBSet = new DataSet();

conn.Open();

adapter.Fill(DBSet);

comm.Dispose();

conn.Close();

return DBSet;

}

6、将用户登录功能代码改为：

string Customername = TextBox3.Text;

string Customerpwd =

System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox4.Text,"MD5");

string Sqlstring = "select * from testwhere uname='" + Customername + "'and upwd='" + Customerpwd +"'";

DA mydata=new DA() ;

DataSet ds =mydata.CustomerLogin(Sqlstring);

if (ds.Tables[0].Rows.Count == 0)

{

Response.Write("<scriptlanguage=javascript>alert('用户名或密码

错!');</script>");

}

else

{

//Response.Write("<scriptlanguage=javascript>alert('登录成功!');</script>"); string scriptString=common.RegScript("登录成功!");

Response.Write(scriptString);

}