studentedit.aspx.cs

学生选课管理系统 谁想要的找我qq564633432

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 studentedit : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["userName"] == null)//如果没有登录，转向登录界面
        {
            Response.Redirect("Login.aspx");
        }
        else
        {
            if (!IsPostBack)
                GridViewBind();   //绑定GridView         
        }

    }
    private void GridViewBind()
    {
        string sqlstr = "";
        if(txtstuID.Text.Trim() == "")
        {
            sqlstr = "select * from Student order by Depart";
        }
        else
        {
            sqlstr = "select * from Student where Sno like '%"+txtstuID.Text.Trim()+"%' order by Depart";
        }
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
        DataSet ds = new DataSet();
        try
        {
            if(conn.State.ToString() == "Closed")
                conn.Open();
            SqlDataAdapter da = new SqlDataAdapter(sqlstr,conn);
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataKeyNames = new string[] { "Sno" };//为索引设置主键
            GridView1.DataBind();
        }
        catch(Exception ee)
        {
            Response.Write("出错信息"+ee.Message.ToString());
        }
        finally
        {
            conn.Close();
        }
    }

    protected void Button1_Click(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        GridViewBind();
    }
    protected void GridView1_RowUpdated(object sender, GridViewUpdatedEventArgs e)
    {
       
    }

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string stuid = GridView1.DataKeys[e.RowIndex].Values[0].ToString().Trim();
        //string stuid = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("Sno")).Text;
        string stuName =  ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[1])).Text.ToString().Trim();
        string stuDepart = ((DropDownList)GridView1.Rows[e.RowIndex].Cells[2].Controls[1]).Text.Trim();
        string stuGrade = ((TextBox)GridView1.Rows[e.RowIndex].Cells[3].Controls[1]).Text.Trim();
        string stuClass = ((TextBox)GridView1.Rows[e.RowIndex].Cells[4].Controls[1]).Text.Trim();
        //取出服务器组件的值
        SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
        string sqlstr = "update Student set Name='" + stuName + "' ,Depart='" + stuDepart + "',Grade='" + stuGrade + "',Class='" + stuClass + "' where Sno='" + stuid + "'";
        try
        {
            if(conn.State.ToString() == "Closed");
            conn.Open();
            SqlCommand comm = new SqlCommand(sqlstr,conn);
            comm.ExecuteNonQuery();
            comm.Dispose();
            if(conn.State.ToString() == "Open")
                conn.Close();
            GridView1.EditIndex = -1;
            GridViewBind();
        }
        catch(Exception ee)
        {
            errorbox.Text = ee.Message.ToString();
        }
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        GridViewBind();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string stuid = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        string sqlstr = "delete from Student where Sno='" + stuid + "'";
        try
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["web"]);
            SqlCommand comm = new SqlCommand(sqlstr, conn);
            conn.Open();
            comm.ExecuteNonQuery();
            comm.Dispose();
            GridViewBind();
            conn.Close();
            GridView1.EditIndex = -1;
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message.ToString());
        }


    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridViewBind();
    }
}