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

public partial class bookguanli : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            DataBind();
        }
    }
    public void DataBind()
    {
        DataSet ds = new DataSet();
        using (SqlConnection sqlconn = DB.con())
        {
            SqlDataAdapter sqld = new SqlDataAdapter("select * from book order by beijie desc", sqlconn);
            sqld.Fill(ds);
        }

        string[] key = { "no" };
        gvBookguanli.DataKeyNames = key;
        //GridView绑定数据源
        gvBookguanli.DataSource = ds.Tables[0].DefaultView;//指定GridView的数据源
        gvBookguanli.DataBind();
    }
    protected void gvBookguanli_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvBookguanli.EditIndex = e.NewEditIndex;
        DataBind();
    }
    protected void gvBookguanli_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gvBookguanli.EditIndex = -1;
        DataBind();
    }
    //protected void gvBookguanli_RowUpdating(object sender, GridViewUpdateEventArgs e)
    //{
    //    SqlConnection sqlconn = DB.con();
    //    sqlconn.Open();
    //    SqlCommand comm = new SqlCommand();
    //    comm.Connection = sqlconn;
    //    comm.CommandText = "update book set number=@number,name=@name,writer=@writer,address=@address,zhuangtai=@zhuangtai,beijie=@beijie where no=@no";
    //    comm.Parameters.AddWithValue("@no", gvBookguanli.DataKeys[e.RowIndex].Value.ToString());
    //    comm.Parameters.AddWithValue("@number", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[1].Controls[0]).Text);
    //    comm.Parameters.AddWithValue("@name", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[2].Controls[0]).Text);
    //    comm.Parameters.AddWithValue("@writer", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[3].Controls[0]).Text);
    //    comm.Parameters.AddWithValue("@address", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[4].Controls[0]).Text);
    //    comm.Parameters.AddWithValue("@zhuangtai", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[5].Controls[0]).Text);
    //    comm.Parameters.AddWithValue("@beijie", ((TextBox)gvBookguanli.Rows[e.RowIndex].Cells[6].Controls[0]).Text);
    //    comm.ExecuteNonQuery();
    //    sqlconn.Close();
    //    sqlconn = null;