default.aspx.cs

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

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的值，则执行以下操作
            {
                Label5.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["BookPrice"].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", con);
        DataSet ds = new DataSet();
        ada.Fill(ds);
        GridView1.DataSource = ds;
        GridView1.DataBind();
        con.Close();
    }
    protected void Button1_Click(object sender, EventArgs e)//更新按钮
    {
        SqlConnection con = new SqlConnection("Server=(Local);Uid=sa;pwd=;DataBase=fangdawei");
        con.Open();
        SqlCommand com = new SqlCommand("update tb_BookInfo set BookName='" + TextBox1.Text + "',BookIntroduce='" + TextBox2.Text + "', BookPrice=" + Convert.ToDecimal(TextBox3.Text) + " where BookID=" + Request["BookID"], con);
        com.ExecuteNonQuery();
        GridViewBind();
        con.Close();
        Response.Redirect("Default.aspx");
        Response.Write("<script>alert'成功！！！！'</script>");
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridViewBind();

        
    }
}