main.aspx.cs

学籍管理系统能够完成对学生信息的填加,删除,修改等功能.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 Default2 : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Database=xueji; Integrated Security=SSPI";
        conn.Open();
        string sql = "select * from xueji";
        SqlCommand com = new SqlCommand();
        com.Connection = conn;
        com.CommandText = sql;
        conn.Close();
    }


    protected void Button1_Click1(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=.;Database=xueji; Integrated Security=SSPI";
        conn.Open();
        String stri = "select count(*) from mima where username='" + TextBox1.Text + "' and password='" +TextBox2.Text+ "';";
        SqlCommand comm = new SqlCommand(stri, conn);
        int d = (int)comm.ExecuteScalar();
        if (d > 0)
        {
            Session["username"] = TextBox1.Text;
            Response.Redirect("chaxun.aspx");
        }
        else
            Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('用户不存在或密码错误！')</script>");
        conn.Close();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("zhuce.aspx");
    }
   
}