adminmanage.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data;

public partial class adminmanage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataBind();
        }
    }
    //GridView数据绑定代码
    public void DataBind()
    {
        DataSet ds = new DataSet();
        using(SqlConnection sqlconn=DB.con())
        {
            SqlDataAdapter sqld = new SqlDataAdapter("select * from manage", sqlconn);
            sqld.Fill(ds);
        }
        //SqlConnection con = DB.con();//创建数据连接
        //string sql = "select no as 管理员编号,userid as 用户名,pwd as 密码 from manage";//sql语句
        //SqlCommand cmd = new SqlCommand(sql, con);
        //SqlDataAdapter sda = new SqlDataAdapter(cmd);//数据适配器 select
        //DataSet ds = new DataSet();
        //sda.Fill(ds);//填充数据集
        //指定主键 
        string[] key = { "no" };
        gvguanliyuanshezhi.DataKeyNames = key;
        //GridView绑定数据源
        gvguanliyuanshezhi.DataSource = ds.Tables[0].DefaultView;//指定GridView的数据源
        gvguanliyuanshezhi.DataBind();//实现绑定
    }
    protected void gvguanliyuanshezhi_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvguanliyuanshezhi.EditIndex = e.NewEditIndex;
        DataBind();
    }
    protected void gvguanliyuanshezhi_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        //string sqlconnstr = ConfigurationManager.ConnectionStrings["connstring"].ConnectionString;
        SqlConnection sqlconn = DB.con();
        sqlconn.Open();
        SqlCommand comm = new SqlCommand();
        comm.Connection = sqlconn;
        comm.CommandText = "update manage set userid=@userid,pwd=@pwd where no=@no";
        comm.Parameters.AddWithValue("@no", gvguanliyuanshezhi.DataKeys[e.RowIndex].Value.ToString());
        comm.Parameters.AddWithValue("@userid", ((TextBox)gvguanliyuanshezhi.Rows[e.RowIndex].Cells[0].Controls[0]).Text);
        comm.Parameters.AddWithValue("@pwd", ((TextBox)gvguanliyuanshezhi.Rows[e.RowIndex].Cells[1].Controls[0]).Text);
        comm.ExecuteNonQuery();
        sqlconn.Close();
        sqlconn = null;