donet学习笔记8(ADO基础B:DataGird控件)

1.界面:

员工编号	员工编号	员工生日	标题	名	姓			删除
1	1	1948年12月8日	Sales Representative	Nancy	Davolio	删除	编辑
2	2	1952年2月19日	Vice President, Sales	Andrew	Fuller	删除	编辑
3	3	1963年8月30日	Sales Representative	Janet	Leverling	删除	编辑
上一页 下一页

2.数据库还是用的微软提供的本身NORTHWIND库.本界面用datagird控件实现了 分页,按照用户定制要求 排序,.对某个栏位的 隐藏,删除,编辑功能.遍历控件cell实现批量删除
可以用手动的配置或则是数据库的自动的配置.其实一般都没有在代码上写,都是通过可视话界面进行改动
ASP代码如下:

  < asp:DataGrid  ID ="DataGrid1"  runat ="server"  Style ="z-index: 100; left: 26px; position: absolute;
            top: 28px"  BackColor ="LightGoldenrodYellow"  BorderColor ="Tan"  BorderWidth ="1px"  CellPadding ="2"  ForeColor ="Black"  GridLines ="None"  AllowPaging ="True"  AutoGenerateColumns ="False"  OnPageIndexChanged ="DataGrid1_PageIndexChanged"  PageSize ="3"  ShowFooter ="True"  OnItemDataBound ="DataGrid1_ItemDataBound"  AllowSorting ="True"  OnDeleteCommand ="DataGrid1_DeleteCommand"  OnSortCommand ="DataGrid1_SortCommand"  OnCancelCommand ="DataGrid1_CancelCommand"  OnEditCommand ="DataGrid1_EditCommand"  OnUpdateCommand ="DataGrid1_UpdateCommand" >
             < FooterStyle  BackColor ="Tan"   />
             < SelectedItemStyle  BackColor ="DarkSlateBlue"  ForeColor ="GhostWhite"   />
             < PagerStyle  BackColor ="PaleGoldenrod"  ForeColor ="DarkSlateBlue"  HorizontalAlign ="Center"  NextPageText ="下一页"  PrevPageText ="上一页"   />
             < AlternatingItemStyle  BackColor ="PaleGoldenrod"   />
             < HeaderStyle  BackColor ="Tan"  Font-Bold ="True"   />
             < Columns >
                 < asp:HyperLinkColumn  DataNavigateUrlField ="employeeID"  DataNavigateUrlFormatString ="showDetails.aspx?empID={0}"
                    DataTextField ="employeeID"  HeaderText ="员工编号"  Target ="_blank" ></ asp:HyperLinkColumn >
                 < asp:BoundColumn  DataField ="employeeID"  HeaderText ="员工编号"  ReadOnly ="True" ></ asp:BoundColumn >
                 < asp:TemplateColumn  HeaderText ="员工生日" >
                     < ItemTemplate >
                         < asp:Label  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.BirthDate", "{0:D}") % > '> </ asp:Label >
                    </ ItemTemplate >
                     < EditItemTemplate >
                         < asp:TextBox  ID ="TextBox1"  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.BirthDate", "{0:D}") % > '> </ asp:TextBox >
                         < asp:CompareValidator  ID ="CompareValidator1"  runat ="server"  Display ="Dynamic"  ErrorMessage ="日期不合法"
                             Type ="Date"  ControlToValidate ="TextBox1"  Operator ="DataTypeCheck" ></ asp:CompareValidator >
                     </ EditItemTemplate >
                 </ asp:TemplateColumn >
                 < asp:BoundColumn  DataField ="Title"  HeaderText ="标题" ></ asp:BoundColumn >
                 < asp:BoundColumn  DataField ="FirstName"  HeaderText ="名" ></ asp:BoundColumn >
                 < asp:BoundColumn  DataField ="LastName"  HeaderText ="姓" ></ asp:BoundColumn >
                 < asp:ButtonColumn  CommandName ="Delete"  Text ="删除" ></ asp:ButtonColumn >
                 < asp:TemplateColumn >
                     < ItemTemplate >
                         < asp:LinkButton  runat ="server"  CausesValidation ="false"  CommandName ="Edit"    ID ="Edit"   Text ="编辑" ></ asp:LinkButton >
                     </ ItemTemplate >
                     < EditItemTemplate >
                         < asp:LinkButton  runat ="server"  CommandName ="Update"  Text ="更新" ></ asp:LinkButton >
                         < asp:LinkButton  runat ="server"  CausesValidation ="false"  CommandName ="Cancel"  Text ="取消" ></ asp:LinkButton >
                     </ EditItemTemplate >
                 </ asp:TemplateColumn >
                 < asp:TemplateColumn  HeaderText ="删除" >
                     < ItemTemplate >
                         < asp:CheckBox  ID ="CheckBoxSelect"  runat ="server"    />
                     </ ItemTemplate >
                 </ asp:TemplateColumn >
             </ Columns >
         </ asp:DataGrid >

3.后台代码:

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  DataGridTest : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindToDataGird();
        }
        
    }
    private void BindToDataGird()
    {
        SqlConnection conn = DB.getConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from employees", conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "emp");
        DataGrid1.DataKeyField = "employeeID";

        DataGrid1.DataSource = ds.Tables["emp"];
        DataGrid1.DataBind();
       
    }
    protected void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindToDataGird();
    }

    protected void ButtonHide_Click(object sender, EventArgs e)
    {
        //直接把第二项的可见性设置为ＦＡＬＳＥ
        DataGrid1.Columns[1].Visible = false;
        BindToDataGird();
    }
    //当数据每一项绑定的时候
    protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
        {
            //小技巧，实际上是本地ＪＳ脚本事件
            e.Item.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#559944'");
            e.Item.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
            //Cell表示是单元格Controls表示里边的控件
            ((LinkButton)(e.Item.Cells[6].Controls[0])).Attributes.Add("onclick","return confirm('你确认删除???');");
        }
        

    }
    protected void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
    {
        //ViewState存储在客户端.
        if (ViewState["Order"] == null)
        {
            ViewState["Order"] ="ASC";
        }
        else
        {
            if (ViewState["Order"].ToString() == "ASC")
            {
                ViewState["Order"] = "DESC";
            }
            else
            {
                ViewState["Order"] = "ASC";
            }
        }
        
        //数据绑定显示
        SqlConnection conn = DB.getConnection();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from employees", conn);
        DataSet ds = new DataSet();
        sda.Fill(ds, "emp");
        ds.Tables["emp"].DefaultView.Sort = e.SortExpression+" " +ViewState["Order"].ToString();
        DataGrid1.DataSource = ds.Tables["emp"].DefaultView;
        DataGrid1.DataBind();
        
    }
    protected void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
    {
        string empID = DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
        SqlConnection conn = DB.getConnection();
        SqlCommand cmd = new SqlCommand("delete from employees where employeeID = '" + empID + "'", conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        BindToDataGird();
    }
    protected void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = e.Item.ItemIndex;
        BindToDataGird();
    }
    protected void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = -1;
        BindToDataGird();
    }
    protected void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
    {
        string empID = DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
      //这个就是取的值的方法.
          string lastName = ((TextBox)(e.Item.Cells[2].Controls[0])).Text;
      //之后连接数据库之后UPDATE就可以了!不再写了!
        
    }
    protected void ButtonDel_Click(object sender, EventArgs e)
    {
        //遍历DataGrid1所有行
        foreach (System.Web.UI.WebControls.DataGridItem dll in DataGrid1.Items)
        {
            //找到名为"CheckBoxSelect"的控件
            CheckBox chk = (CheckBox)dll.FindControl("CheckBoxSelect");
            if (chk.Checked)
            {
                Response.Write(dll.Cells[1].Text);
            }
        }
    }
}

转载于:https://www.cnblogs.com/sorry208/articles/930482.html