ASP.NET數(shù)據(jù)綁定之DataList控件實(shí)戰(zhàn)篇

ItemTemplate> 
 asp:LinkButton ID="lbtnShowDetails" runat="server" CommandName="select" ForeColor="Red">查看/asp:LinkButton> 
 asp:LinkButton ID="lbtnEdit" runat="server" CommandName="edit" ForeColor="Red">編輯/asp:LinkButton> 
 %# DataBinder.Eval(Container.DataItem,"personName") %> 
/ItemTemplate> 

 SelectedItemTemplate> 
 員工編號(hào)： %# DataBinder.Eval(Container.DataItem,"pID") %> 
 br /> 
 員工姓名： %# DataBinder.Eval(Container.DataItem,"personName") %> 
 br /> 
 員工性別： %# DataBinder.Eval(Container.DataItem,"personSex") %> 
/SelectedItemTemplate> 

EditItemTemplate> 
 asp:LinkButton ID="lbtnupdate" runat="server" CommandName="update">保存/asp:LinkButton> 
 asp:LinkButton ID="lbtnCancel" runat="server" CommandName="cancel">取消/asp:LinkButton> br /> 
 員工編號(hào)：%# DataBinder.Eval(Container.DataItem,"pID") %>br />姓名：asp:TextBox ID="txtName" runat="server" span style="color:#FF0000;">Text='%# DataBinder.Eval(Container.DataItem,"personName") %>'/span> Width="50px">/asp:TextBox> 
/EditItemTemplate> 

HeaderTemplate> 
  模板的頁(yè)眉 
 /HeaderTemplate> 
 FooterTemplate> 
  br /> 
  模板的頁(yè)腳 
 /FooterTemplate> 

private void dataBindToDataList() 
  { 
   SqlConnection con = DB.createConnection(); 
   SqlDataAdapter sda = new SqlDataAdapter(); 
   string sql = "select * from person "; 
   sda.SelectCommand = new SqlCommand(sql, con); 
   DataSet ds = new DataSet(); 
   sda.Fill(ds, "per"); 
   DataList1.DataKeyField = "pID"; //將主鍵存入到DataKeys集合當(dāng)中，以便后面對(duì)某一條數(shù)據(jù)進(jìn)行編輯。 
   DataList1.DataSource = ds.Tables["per"]; 
   DataList1.DataBind(); 
  } 

protected void Page_Load(object sender, EventArgs e) 
  { 
   if (!this.IsPostBack) 
   { 
    this.dataBindToDataList(); 
   } 
  } 

protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)// e表示DataList傳遞給該函數(shù)的信息。 
  { 
   if (e.CommandName == "select") 
   { 
    this.DataList1.SelectedIndex = e.Item.ItemIndex; 
    this.dataBindToDataList(); 
   } 
  } 

protected void DataList1_EditCommand(object source, DataListCommandEventArgs e)// e表示DataList傳遞給該函數(shù)的信息。 
  { 
   this.DataList1.EditItemIndex = e.Item.ItemIndex;//e.Item表示DataList中發(fā)生事件的那一項(xiàng) 
   this.dataBindToDataList(); 
 
  } 

protected void DataList1_CancelCommand(object source, DataListCommandEventArgs e)// e表示DataList傳遞給該函數(shù)的信息。 
  { 
   DataList1.EditItemIndex = -1; //當(dāng)EditItemIndex屬性值為-1時(shí)，表示不顯示EditItemTemplate模板 
   dataBindToDataList(); 
  } 
 
  protected void DataList1_UpdateCommand(object source, DataListCommandEventArgs e) 
  { 
    string ID =DataList1.DataKeys[e.Item.ItemIndex].ToString(); 
    string name = ((TextBox)e.Item.FindControl("txtName")).Text ; 
    SqlConnection con = DB.createConnection(); 
    SqlCommand cmd = new SqlCommand("update person set personName='"+name+"'where pID='"+ID+"'",con); 
    cmd.ExecuteNonQuery(); 
    DataList1.EditItemIndex = -1; 
    dataBindToDataList(); 
  } 
  protected void DataList1_DeleteCommand(object source, DataListCommandEventArgs e) 
  { 
   string ID = DataList1.DataKeys[e.Item.ItemIndex].ToString(); 
   SqlConnection con = DB.createConnection(); 
   SqlCommand cmd = new SqlCommand("delete from person where pID='" + ID + "'", con); 
   cmd.ExecuteNonQuery(); 
   DataList1.EditItemIndex = -1; 
   dataBindToDataList(); 
  }