GridView初级自定义应用 增删改查

 

using System; 
using System.Data; 
using System.Configuration; 
using System.Collections; 
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 Default5 : System.Web.UI.Page 
{ 
    DataTable dtTemp = new DataTable(); 
    protected void Page_Load(object sender, EventArgs e) 
    { 
        if (!IsPostBack) 
        { 
            databind();//一定要写成一个方法，不然不成功！！！！ 
        } 
    } 
    protected void databind() 
    { 
        DataTable dt = new DataTable(); 
        string constr = "server=.;uid=sa;pwd=huwei;database=Km"; 
        string sql = "select * from km_info "; 
        SqlConnection conn = new SqlConnection(constr); 
        SqlCommand com = new SqlCommand(sql, conn); 
        SqlDataAdapter da = new SqlDataAdapter(com); 
        da.Fill(dt); 
        if (ViewState["dt"] == null)            //判断是内存中是否存在这张表 
        { 
            ViewState["dt"] = dt; 
        } 

        GridView1.DataSource = (DataTable)ViewState["dt"]; //让girdview数据源指定内存中的表，而不是读出来的dt，因为页面每次都要刷新，才能正确显示，所有每次都是原来内容，达不到修改后的效果 
        GridView1.DataBind(); 
        Label1.Text = DateTime.Now.ToString(); 

    } 


//点击编辑 
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) 
    { 
        GridView1.EditIndex = e.NewEditIndex; 
        databind(); 
    } 
//点击更新 
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) 
    { 
//        ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "a", "alert('" + ((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[2].Controls[0]).Text + "');", true); 
        int id = Convert.ToInt32(((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[1].Controls[0]).Text);//获取id行(主键) 
        dtTemp = (DataTable)ViewState["dt"]; 

        dtTemp.PrimaryKey = new DataColumn[] { dtTemp.Columns["km_id"] };//建立一个主键 
        DataRow row = dtTemp.Rows.Find(id);//找到主键等于id的行 
        row[1] = ((TextBox)GridView1.Rows[GridView1.EditIndex].Cells[2].Controls[0]).Text; 
        ViewState["dt"] = dtTemp; 
        GridView1.EditIndex = -1; 

        databind(); 
    } 

//点击取消 
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) 
    { 
        GridView1.EditIndex = -1; 
        databind(); 
    } 
    //删除 

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) 
    { 
        ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "a", "return confirm('确定删除否？');", true); 
        int n = e.RowIndex;//获取但前第几行 

        string id = GridView1.Rows[n].Cells[1].Text;//找到该行第一列（id）列 也就是主键 
        dtTemp = (DataTable)ViewState["dt"]; 

        dtTemp.PrimaryKey = new DataColumn[] { dtTemp.Columns["km_id"] };//建立一个主键 
        DataRow row = dtTemp.Rows.Find(id);//找到主键等于id的行 
        dtTemp.Rows.Remove(row); 
        ViewState["dt"] = dtTemp; 
        databind(); 

    } 

    //绑定数据时，表头显示背景图片 
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
    { 
        if (e.Row.RowType == DataControlRowType.Header) 
        { 
            e.Row.Attributes.Add("style", "background-image:url('App_Themes\\Office2003 Blue\\GridView\\gvGradient.gif')"); 
        } 
    } 
    //分页 
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) 
    { 
        GridView1.PageIndex = e.NewPageIndex; 
        databind(); 
    } 

}