我想要3层架构中的此示例

我想要3层架构中的此示例

本文介绍了我想要3层架构中的此示例的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    <table align="center"><tr><td>
        <asp:GridView ID="gv1" runat="server"

            AutoGenerateColumns="False" AutoGenerateDeleteButton="True" BackColor="LightGoldenrodYellow"

            BorderColor="Tan" BorderWidth="1px" CellPadding="2"

            GridLines="None" onrowdeleting="gv1_RowDeleting" ForeColor="Black"

            AutoGenerateEditButton="True" onrowcancelingedit="gv1_RowCancelingEdit"

            onrowediting="gv1_RowEditing" onrowupdating="gv1_RowUpdating">
    <Columns>
    <asp:BoundField HeaderText="Dept Id" DataField="DeptId"/>
        <asp:BoundField HeaderText="Dept Name" DataField="DepartmentName"/>


    </Columns>
        <FooterStyle BackColor="Tan" />
        <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"

                HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
        <HeaderStyle BackColor="Tan" Font-Bold="True" />
        <AlternatingRowStyle BackColor="PaleGoldenrod" />
    </asp:GridView></td></tr></table>
    <table align="center" bgcolor="#ff9900"><tr><td><asp:Label ID="lblDEptId" Text="Dept Id" runat="server"></asp:Label> </td>
    <td><asp:TextBox ID="txtlblDEptId" runat="server"></asp:TextBox></td></tr>
    <tr><td><asp:Label ID="LblDeptName" Text="Dept Name" runat="server"></asp:Label> </td>
    <td><asp:TextBox ID="TxtDeptName" runat="server"></asp:TextBox></td></tr>
   </table>
        <table align="center"><tr><td><asp:Button ID="btnsave" Text="Save" runat="server"

                onclick="btnsave_Click" /></td>
        <td><asp:Button ID="Btncancel" Text="Cancel" runat="server"

                onclick="Btncancel_Click" /></td></tr></table>

    </div>
    </form>
</body>
</html>





protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            GetData();
        }
    }
    private void GetData()
    {
        SqlDataAdapter da = new SqlDataAdapter("select * from Department", con);
        DataSet ds = new DataSet();
        da.Fill(ds, "Department");
        gv1.DataSource = ds.Tables[0];
        gv1.DataBind();
    }
    protected void btnsave_Click(object sender, EventArgs e)
    {
        string s = "insert into Department values(''" + txtlblDEptId.Text + "'',''" + TxtDeptName.Text + "'')";
        SqlCommand cmd = new SqlCommand(s, con);
        cmd.CommandType = CommandType.Text;
        con.Open();
        int i = cmd.ExecuteNonQuery();
        con.Close();
        GetData();
    }
    protected void gv1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        Response.Write(e.RowIndex);
        string s = gv1.Rows[e.RowIndex].Cells[1].Text;
        Response.Write(s);
        da = new SqlDataAdapter("delete from Department where DeptId=" + s, con);
        ds = new DataSet();
        da.Fill(ds, "Department");
        GetData();
    }
    protected void Btncancel_Click(object sender, EventArgs e)
    {
        txtlblDEptId.Text = "";
        TxtDeptName.Text = "";

    }
    protected void gv1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gv1.EditIndex = e.NewEditIndex;
        GetData();
    }
    protected void gv1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gv1.EditIndex = -1;
        GetData();
    }
    protected void gv1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        GridViewRow r = gv1.Rows[e.RowIndex];
        int mdeptid;
        string mdeptname;

        TextBox t1 = (TextBox)r.Cells[1].Controls[0];
        mdeptid = Convert.ToInt32(t1.Text);
        t1 = (TextBox)r.Cells[2].Controls[0];
        mdeptname = (t1.Text);

        string s = "update Department set DepartmentName=''" + mdeptname + "'' where DeptId=" + mdeptid;
        SqlCommand cmd = new SqlCommand(s, con);
        cmd.CommandType = CommandType.Text;
        con.Open();
        int i = cmd.ExecuteNonQuery();
        con.Close();
        gv1.EditIndex = -1;
        GetData();
    }
}

推荐答案


这篇关于我想要3层架构中的此示例的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-10 20:35