default6.aspx.cs

学生管理系统 功能不是很强大 但是很实用

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class Default6 : System.Web.UI.Page
{
    string student;
    public SqlCommandBuilder scb;
    protected void Page_Load(object sender, EventArgs e)
    {
        student = this.Session["name"].ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string myConnstr = "data source=localhost;database=学生成绩智能管理系统;user id=sa;password=sa;";
        SqlConnection myConn = new SqlConnection(myConnstr);
        //string stunum = TextBox1.Text;
        if (TextBox1.Text != "")
        {
            string sql = "select 学号,密码,姓名 from 学生表 where 学号=" + TextBox1.Text;
            SqlCommand myComm = new SqlCommand(sql, myConn);
            //SqlDataReader mySqlDataReader = myComm.ExecuteReader();
            SqlDataAdapter myDataAdapter = new SqlDataAdapter();
            myDataAdapter.SelectCommand = myComm;
            DataSet myDataSet = new DataSet();
            myConn.Open();
            myDataAdapter.Fill(myDataSet, "学生表");
            DataTable myDataTable = myDataSet.Tables["学生表"];
            foreach (DataRow myDataRow in myDataTable.Rows)
            {
                string x1, x2;
                x1 = (string)myDataRow["学号"];
                x2 = (string)myDataRow["密码"];
                x1 = x1.Trim();
                x2 = x2.Trim();
                if (x1 == TextBox1.Text && x2 == TextBox2.Text)
                {
                    if (TextBox3.Text == TextBox4.Text)
                    {
                        if (TextBox3.Text == "")
                        {
                            Response.Write("<script>alert('密码不能为空!');</script>");
                        }
                        else
                        {
                            myDataTable.PrimaryKey = new DataColumn[] { myDataTable.Columns["学号"] };
                            DataRow myEditDataRow = myDataTable.Rows.Find(TextBox1.Text);
                            scb = new SqlCommandBuilder(myDataAdapter);
                            myDataSet.Tables["学生表"].Rows[0]["密码"] = TextBox3.Text;
                            myDataAdapter.Update(myDataSet.Tables["学生表"]);
                            Response.Write("<script>alert('密码修改完成!');</script>");
                        }
                    }
                    else
                        Response.Write("<script>alert('新密码输入错误!');</script>");
                }
                else
                    Response.Write("<script>alert('学号或密码错误!请从新输入!');</script>");
            }
            myConn.Close();
        }
        else
            Response.Write("<script>alert('请输入用户名和密码!');</script>");
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        TextBox1.Text = "";
        TextBox2.Text = "";
        TextBox3.Text = "";
        TextBox4.Text = "";
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("登陆页面.aspx");
    }
}