Good/GoodList.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.SqlClient;
using System.Configuration;
using System.Data;

public partial class Good_GoodList : System.Web.UI.Page
{
    /// <summary>
    /// 绑定数据
    /// </summary>
    protected void GridDataBind()
    {
        string sqlConString = ConfigurationManager.ConnectionStrings["LibraryConnectionString"].ToString();
        SqlConnection sqlCon = new SqlConnection(sqlConString);
        string strCmd = "select * from tb_Good";
        SqlDataAdapter sqlDa = new SqlDataAdapter(strCmd, sqlCon);
        DataSet dsBookinfo = new DataSet();

        sqlDa.Fill(dsBookinfo, "tb_Good");

        try
        {
            if (sqlCon.State == ConnectionState.Closed)
            {
                sqlCon.Open();
            }
            if (dsBookinfo.Tables[0].Rows.Count > 0)
            {
                GridViewClient.DataSource = dsBookinfo.Tables["tb_Good"].DefaultView;
                GridViewClient.DataBind();
            }
            else
            {
                GridViewClient.DataSource = null;
                GridViewClient.DataBind();
            }
        }
        catch (SqlException ex)
        {
            Response.Write("<script>alert('" + ex.Message + "')</script>");
        }
        finally
        {
            if (sqlCon.State == ConnectionState.Open)
            {
                sqlCon.Close();
            }
            dsBookinfo.Dispose();
        }
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {