login.aspx.cs

登陆系统+数据库,实现比较简单,满好用的

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient ;

public partial class _Default : System.Web.UI.Page 
{
    private SqlConnection sqlcon;
    private SqlCommand sqlcom;

    protected void Page_Load(object sender, EventArgs e)
    {
        string strconn = ConfigurationManager.ConnectionStrings["shujuku1"].ToString();
        
        sqlcon = new SqlConnection(strconn );
        
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        sqlcon.Open();

        string strcomm = "select count(*) from shiyan5 where 用户名='" + username.Text.Trim() + "'and 密码='" + TextBox2.Text .Trim ()+"'";
        sqlcom =new SqlCommand(strcomm ,sqlcon );
        int count=Convert .ToInt16 (sqlcom.ExecuteScalar());
        if (count > 0)
        {
            Response.Redirect("main.aspx?username=" + username.Text);
        }
        else
        {
            Label1.Text = "用户名或密码错误，请重新输入～";
        }
    }
}