default.aspx.cs

来自「水晶报表详细资料水晶报表详细资料水晶报表详细资料」· CS 代码 · 共 73 行

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page 
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)//首次执行页面时
        {
            GridViewBind();//绑定自定义方法GridViewBind
            if (Request.QueryString["BookID"] != null)//判断，如果可以获取到BookID的值，则执行以下操作
            {
                Label3.Text = Request.QueryString["BookID"];
                SqlConnection con = new SqlConnection("Server=(Local);Uid=sa;pwd=;DataBase=fangdawei");
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter("select * from tb_BookInfo where BookID=" + Request.QueryString["BookID"] + "", con);
                DataSet ds = new DataSet();
                ada.Fill(ds, "tb_BookInfo");
                //DataRowView drv = ds.Tables["tb_BookInfo"].DefaultView[0];
                //TextBox1.Text = drv["BookName"].ToString();
                //TextBox2.Text = drv["BookIntroduce"].ToString();
                //TextBox3.Text = drv["BookIsNew"].ToString();
            }
        }
    }
    public void GridViewBind()//绑定GridIDView控件的自定义方法
    {
        SqlConnection con = new SqlConnection("Server=(Local);Uid=sa;pwd=;DataBase=fangdawei");
        con.Open();
        SqlDataAdapter ada = new SqlDataAdapter("select * from tb_BookInfo order by BookID desc", con);
        DataSet ds = new DataSet();
        ada.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataKeyNames = new string[] { "BookID" };
        GridView1.DataBind();
        con.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
            int id=Convert.ToInt32(Label3.Text);
            SqlConnection con = new SqlConnection("Server=(Local);Uid=sa;pwd=;DataBase=fangdawei");
            con.Open();
            SqlCommand com = new SqlCommand("delete from tb_BookInfo  where BookID="+id, con);
            com.ExecuteNonQuery();
            con.Close();
            GridViewBind();
            Response.Redirect("Default.aspx");
            Response.Write("<script language=javascript>aler('删除成功！')</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>aler('删除失败！')</script>");
        }

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

}
    }