Question

asp.net做登陆页面(用sql数据库)的全部代码

Answer 1

public static void Checkname(string name,string pwd,string returnUrl)
{
SqlConnection conn=new SqlConnection(ConnStr);
conn.Open();
SqlCommand comm=new SqlCommand("select * from [User] where uname=@name and pwd=@password",conn);
comm.Parameters.Add("@name",SqlDbType.NVarChar).Value=name;
comm.Parameters.Add("@password",SqlDbType.NVarChar).Value=pwd;
SqlDataReader sdr=comm.ExecuteReader();

if(sdr.Read())
{
Response.Write("登陆成功");
}
else
{
Response.Write("登陆失败");
}
comm.Dispose();
conn.Close();

}
public static string ConnStr
{
get
{
NameValueCollection configSettings=(NameValueCollection)ConfigurationSettings.GetConfig("WebSettings");
return configSettings["ConnStr"];
}
}