国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

GridView的修改,刪除,查詢

2019-11-14 16:44:46
字體:
來源:轉載
供稿:網友

前臺代碼:

  <div>        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing" OnRowUpdating="GridView1_RowUpdating" DataKeyNames="DepartId">            <Columns>                <asp:TemplateField>                    <HeaderTemplate>                        部門編號                    </HeaderTemplate>                    <EditItemTemplate>                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("DepartId") %>'></asp:TextBox>                    </EditItemTemplate>                    <ItemTemplate>                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("DepartId") %>'></asp:Label>                    </ItemTemplate>                </asp:TemplateField>                <asp:TemplateField>                    <HeaderTemplate>                        部門名稱                    </HeaderTemplate>                    <EditItemTemplate>                        <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DepartName") %>'></asp:TextBox>                    </EditItemTemplate>                    <ItemTemplate>                        <asp:Label ID="Label2" runat="server" Text='<%# Bind("DepartName") %>'></asp:Label>                    </ItemTemplate>                </asp:TemplateField>                <asp:TemplateField HeaderText="操作" ShowHeader="False">                    <EditItemTemplate>                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="更新"></asp:LinkButton>                         <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="取消"></asp:LinkButton>                    </EditItemTemplate>                    <ItemTemplate>                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="編輯"></asp:LinkButton>                        <asp:LinkButton ID="LinkButton2" CausesValidation="false" CommandName="Delete" Text="刪除" runat="server" />                                         </ItemTemplate>                </asp:TemplateField>            </Columns>        </asp:GridView>    </div>

后臺代碼:

public partial class WebForm3 : System.Web.UI.Page    {        DepartmentInfoBLL dbll = new DepartmentInfoBLL();        PRotected void Page_Load(object sender, EventArgs e)        {            if (!IsPostBack)            {                InitGridView();            }        }        private void InitGridView()        {            IList<DepartmentInfo> list = dbll.GetAll();            this.GridView1.DataSource = list;            this.GridView1.DataBind();        }        protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)        {            int departId = int.Parse(e.Keys[0].ToString());            //執行刪除的方法            dbll.DeleteByDepartId(departId);            //重新加載數據            InitGridView();        }        protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)        {            this.GridView1.EditIndex = e.NewEditIndex;            InitGridView();        }        protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)        {            GridViewRow row = this.GridView1.Rows[e.RowIndex];            int departId = int.Parse(e.Keys[0].ToString());            string departName = (row.FindControl("TextBox2") as TextBox).Text;            //執行修改的方法            dbll.Update(new DepartmentInfo()            {                DepartId = departId,                DepartName = departName,                Remark= ""            });            //取消編輯狀態            this.GridView1.EditIndex = -1;            //重新加載一次數據            InitGridView();        }        protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)        {            this.GridView1.EditIndex = -1;            InitGridView();        }    }

  


上一篇:PagedList分頁

下一篇:linqtosql簡單使用

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 额尔古纳市| 祁阳县| 滨州市| 深泽县| 壤塘县| 饶阳县| 财经| 股票| 太仓市| 岳池县| 琼中| 佛学| 永定县| 阳江市| 汶川县| 黑水县| 安阳县| 柳州市| 渝中区| 金昌市| 新宁县| 兖州市| 施甸县| 荥阳市| 达日县| 蚌埠市| 德钦县| 镇远县| 新巴尔虎右旗| 达拉特旗| 清苑县| 中阳县| 阳泉市| 漳浦县| 乡城县| 霞浦县| 枣强县| 弋阳县| 阿巴嘎旗| 大埔县| 二手房|