gridview

idview css 设定

<RowStyle cssClass="rowStyle" />

 <FooterStyle cssClass="footerStyle" />

 <SelectedRowStyle cssClass="selectrowStyle" />

 <HeaderStyle cssClass="headerStyle" />

 <AlternatingRowStyle cssClass="alternatingrowStyle" />

 

数据绑定

 1     private void dataBind1(int id)
 2     {
 3        StringBuilder sql = new StringBuilder();
 4        sql.Append(" SELECT colName from TableName ");
 5 
 6        DataSet ds = new DataSet();
 7 
 8        ds = SqlHelper.ExecuteDataset(DBconn.conn, CommandType.Text, sql.ToString());
 9 
10         this.GridView1 .DataSource =ds.Tables[0].DefaultView;
11         this.GridView1.DataBind();   
12     }

 

 数据操作

事件操作   RowCommand  e.CommandName  选择 Select  编辑 Edit   更新 Update  删除  Delete  保留字

A直接操作

 

B代码操作 

 

GridView 必知

记录从0,0 开始  header 算是 第 0 行 

this.GridView1.Rows[this.GridView1.SelectedIndex].Cells[1].Text.ToString())  取得选择行的第1列记录 

 

多页编辑

 

 <asp:HyperLinkField DataNavigateUrlFields="emp_id" DataNavigateUrlFormatString="edit.aspx?id={0}"  

 1 public string conn = ConfigurationManager.ConnectionStrings["connString"].ToString();
 2         protected void Page_Load(object sender, EventArgs e)
 3         {
 4                 this.GridViewBind();
 5         }
 6         private void GridViewBind()  //绑定
 7         {
 8             StringBuilder sql = new StringBuilder();
 9 
10 
11             sql.Append(" SELECT emp_id, fname, minit, lname, job_id");
12             sql.Append(" FROM employee");
13             sql.Append(" WHERE (1=1)");
14  
15             if (this.txtfname.Text.Trim()!="")
16             {
17                sql.Append ("and (fname = '"+this.txtfname.Text.Trim() +"')");
18             }
19 
20 
21             DataSet ds = new DataSet();
22             ds = SqlHelper.ExecuteDataset(conn, CommandType.Text, sql.ToString());
23             this.GridView1.DataSource = ds.Tables[0].DefaultView;
24             this.GridView1.DataBind();
25            
26         }
27 
28         protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)  //分页
29         {
30             this.GridView1.PageIndex = e.NewPageIndex;//获得新页的索引。
31             GridViewBind();
32         }

 

 

edit.aspx

 1 public string conn = ConfigurationManager.ConnectionStrings["connString"].ToString();
 2 
 3     protected void Page_Load(object sender, EventArgs e)
 4     {
 5         if (!IsPostBack)
 6         {
 7             if (Request.UrlReferrer != null)
 8                 ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
 9         }
10     }
11     protected void Button2_Click(object sender, EventArgs e)
12     {
13         string id = Request.QueryString["id"].ToString();
14 
15         StringBuilder sql = new StringBuilder();
16 
17         sql.Append("UPDATE employee set fname = 'abc' WHERE (emp_id = '"+ id +"') ");
18 
19         SqlHelper.ExecuteNonQuery(conn, CommandType.Text,sql.ToString());
20 
21         Response.Redirect(ViewState["UrlReferrer"].ToString());  //返回刷新
22     }

 

 

                    Text=" Edit " />