学生模块/Default7.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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 Default7 : System.Web.UI.Page
{
    public SqlCommandBuilder scb;
    string student;
    protected void Page_Load(object sender, EventArgs e)
    {
        student = this.Session["name"].ToString();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DateTime date;
        if (Button1.Text == "修改")
        {
            Button1.Text = "保存";
            DropDownList1.Enabled = true;
            TextBox2.Enabled = true;
            TextBox3.Enabled = true;
            TextBox4.Enabled = true;
        }
        else if (Button1.Text == "保存")
        {
            if (!(DropDownList1.Text == "" && TextBox2.Text == "" && TextBox3.Text == "" && TextBox4.Text == ""))
            {
                Button1.Text = "修改";
                DropDownList1.Enabled = false;
                TextBox2.Enabled = false;
                TextBox3.Enabled = false;
                TextBox4.Enabled = false;
                string myConnstr = "data source=.;database=学生成绩智能管理系统;Integrated Security=True;";
                SqlConnection myConn = new SqlConnection(myConnstr);
                string sql = "select 学号,政治面貌,出生日期,家庭住址,备注 from 学生表 where 学号='" + student + "'";
                SqlCommand myComm = new SqlCommand(sql, myConn);
                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)
                {
                    myDataTable.PrimaryKey = new DataColumn[] { myDataTable.Columns["学号"] };
                    DataRow myEditDataRow = myDataTable.Rows.Find(student);
                    scb = new SqlCommandBuilder(myDataAdapter);
                    if (DropDownList1.Text != "")
                        myDataSet.Tables["学生表"].Rows[0]["政治面貌"] = DropDownList1.Text;
                    if (TextBox2.Text != "")
                    {
                        date = DateTime.Parse(TextBox2.Text);