Stu.aspx.cs

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

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

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 Stu : System.Web.UI.Page
{
    SqlHelper mydata = new SqlHelper();

    protected void Page_Load(object sender, EventArgs e)
    {

        if (!IsPostBack)
        {

            InitData();  //绑定用户信息        
        }
    }
    //初始化用户表格
    protected void InitData()
    {
    
        GridView1.DataSource = mydata.GetDataReader("select * from Stu_info");
        GridView1.DataBind();
    }
    //GridView控件RowDeleting事件
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
     
        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        try
        {
            mydata.RunSql("delete  from Stu_info where  id='" + ID + "'");

            Alert.AlertAndRedirect("删除成功", "Stu.aspx");
            GridView1.EditIndex = -1;
            InitData();
        }
        catch
        {

            Alert.AlertAndRedirect("删除失败", "Stu.aspx");
        }

    }
    //GridView控件RowUpdating事件
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
     
        string ID = GridView1.DataKeys[e.RowIndex].Values[0].ToString();
        try
        {
            mydata.RunSql("update Stu_info set name='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("name")).Text + "' ,pwd='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("pwd")).Text + "' ,num='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("num")).Text + "' ,emal='" + ((TextBox)GridView1.Rows[e.RowIndex].FindControl("emal")).Text + "' where id=" + ID);