default2.aspx.cs

这是asp.net^和Visual C++Sharp编写的串并口通讯的书籍 源代码

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 Default2 : 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=mrdb");
                con.Open();
                SqlDataAdapter ada = new SqlDataAdapter("select * from tb_Book where BookID=" + Request.QueryString["BookID"] + "", con);
                DataSet ds = new DataSet();
                ada.Fill(ds, "tb_Book");
            }
        }
    }
    public void GridViewBind()//绑定GridIDView控件的自定义方法
    {
        SqlConnection con = new SqlConnection("Server=(Local);Uid=sa;pwd=;DataBase=mrdb");
        con.Open();
        SqlDataAdapter ada = new SqlDataAdapter("select * from tb_Book 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=mrdb");
            con.Open();
            SqlCommand com = new SqlCommand("delete from tb_Book  where BookID=" + id, con);
            com.ExecuteNonQuery();
            con.Close();
            GridViewBind();
            //Response.Redirect("Default2.aspx");
            Response.Write("<script language=javascript>alert('删除成功！')</script>");
        }
        catch
        {
            Response.Write("<script language=javascript>alert('删除失败！')</script>");
        }

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

    }
}