国产探花免费观看_亚洲丰满少妇自慰呻吟_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簡單使用

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 潞城市| 广灵县| 青阳县| 三门峡市| 卢龙县| 汉寿县| 本溪市| 房产| 登封市| 黄山市| 杂多县| 康马县| 淮安市| 吴旗县| 荥阳市| 永兴县| 崇州市| 宝清县| 永修县| 镇平县| 新津县| 康保县| 柯坪县| 新安县| 荆州市| 平舆县| 正阳县| 江华| 雷州市| 同江市| 灵璧县| 田林县| 庄河市| 眉山市| 平塘县| 大名县| 东台市| 锡林郭勒盟| 东辽县| 新安县| 琼结县|