[NET][GRID]ASP.NET中如何实现嵌套DataGrid

最新推荐文章于 2018-02-22 16:49:00 发布

逐浪_一生悬命

最新推荐文章于 2018-02-22 16:49:00 发布

阅读量2.3k

点赞数

分类专栏： VS.NET专区文章标签： datagrid asp.net asp textbox delete command

本文链接：https://blog.csdn.net/szwangdf/article/details/1616890

版权

VS.NET专区专栏收录该内容

31 篇文章 0 订阅

订阅专栏

ASP.NET中如何实现嵌套DataGrid

1.Sample1

private void Page_Load( object sender, System.EventArgs e)

{

string SQL=string.Format("seletc * from table1");

SqlConnection conn=new SqlConnection(dsn);

DataSet ds=new DataSet();

SqlDataAdapter da=new SqlDataAdapter(SQL,conn);

da.Fill(ds,"table1");

this.DataGrid1.DataSource=ds.Tables["table1"].DefaultView;

this.DataBind();

for(int i=0;i<this.DataGrid1.Items.Count;i++)

{

DataGrid dg=(DataGrid)this.DataGrid2.Items[i].FindControl("DataGrid2");

string SQL2=string.Format("select * from table2 "); SqlDataAdapter da1=new SqlDataAdapter(SQL2,conn);

da1.Fill(ds,"table2 ");

dg.DataSource=ds.Tables["table2 "].DefaultView;

dg.DataBind();

ds.Tables.Remove("table2 ");

}

2.Sample2

http://www.gagavideo.com/article.asp?id=2592

1.html代码
<HTML>
    <HEAD>
        <title>DataGridNesting</title>
        <meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
        <meta content="C#" name="CODE_LANGUAGE">
        <meta content="JavaScript" name="vs_defaultClientScript">
        <meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
    </HEAD>
    <body MS_POSITIONING="GridLayout">
        <form id="Form1" method="post" runat="server">
            <asp:datagrid id="DataGrid1" runat="server" DataKeyField="ClassID" OnEditCommand="Edit_Grid1"
                OnCancelCommand="Cancel_Grid1" OnUpdateCommand="Update_Grid1" OnDeleteCommand="Delete_Grid1"
                CellPadding="4" BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#CC9966"
                Width="660px" AutoGenerateColumns="False" OnItemCommand="Item_Command">
                <FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
                <SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
                <ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
                <HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
                <Columns>
                    <asp:TemplateColumn HeaderText="序号">
                        <HeaderStyle Width="10px"></HeaderStyle>
                        <ItemTemplate>
                            <%# Container.ItemIndex+1 %>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="序号">
                        <HeaderStyle Width="10px"></HeaderStyle>
                        <ItemTemplate>
                            <asp:ImageButton id="ImageButton1" runat="server" ImageUrl="add.gif"></asp:ImageButton>
                        </ItemTemplate>
                    </asp:TemplateColumn>
                    <asp:BoundColumn Visible="False" DataField="ClassID" HeaderText="ClassID">
                        <HeaderStyle Width="0px"></HeaderStyle>
                    </asp:BoundColumn>
                    <asp:TemplateColumn HeaderText="班级">
                        <HeaderStyle Width="300pt"></HeaderStyle>
                        <ItemTemplate>
                            <%# DataBinder.Eval(Container.DataItem,"ClassName") %>
                            <asp:DataGrid id="DataGrid2" runat="server" DataKeyField="StudentID" OnEditCommand="grid2_EditCommand"
                                OnCancelCommand="grid2_CancelCommand" OnUpdateCommand="grid2_UpdateCommand" OnDeleteCommand="grid2_DeleteCommand"
                                CellPadding="4" BackColor="White" BorderWidth="1px" BorderStyle="None" BorderColor="#3366CC"
                                Width="200px" AutoGenerateColumns="False">
                                <FooterStyle ForeColor="#003399" BackColor="#99CCCC"></FooterStyle>
                                <SelectedItemStyle Font-Bold="True" ForeColor="#CCFF99" BackColor="#009999"></SelectedItemStyle>
                                <ItemStyle ForeColor="#003399" BackColor="White"></ItemStyle>
                                <HeaderStyle Font-Bold="True" ForeColor="#CCCCFF" BackColor="#003399"></HeaderStyle>
                                <Columns>
                                    <asp:TemplateColumn HeaderText="序号">
                                        <HeaderStyle Width="10px"></HeaderStyle>
                                        <ItemTemplate>
                                            <%# Container.ItemIndex+1 %>
                                        </ItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:BoundColumn Visible="False" DataField="StudentID" HeaderText="StudentID">
                                        <HeaderStyle Width="0px"></HeaderStyle>
                                    </asp:BoundColumn>
                                    <asp:TemplateColumn HeaderText="姓名">
                                        <HeaderStyle Width="30px"></HeaderStyle>
                                        <ItemTemplate>
                                            <%# DataBinder.Eval(Container.DataItem,"StudentName") %>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox id="txtStudentName" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"StudentName") %>'>
                                            </asp:TextBox>
                                        </EditItemTemplate>
                                    </asp:TemplateColumn>

http://www.pconcool.com

                                    <asp:TemplateColumn HeaderText="年龄">
                                        <HeaderStyle Width="30px"></HeaderStyle>
                                        <ItemTemplate>
                                            <%# DataBinder.Eval(Container.DataItem,"Age") %>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:TextBox id="txtAge" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Age") %>'>
                                            </asp:TextBox>
                                        </EditItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:TemplateColumn HeaderText="班级">
                                        <HeaderStyle Width="30px"></HeaderStyle>
                                        <ItemTemplate>
                                            <%# DataBinder.Eval(Container.DataItem,"ClassName") %>
                                        </ItemTemplate>
                                        <EditItemTemplate>
                                            <asp:DropDownList id="drpClass" Runat="server">
                                                <asp:ListItem Value="1">一班</asp:ListItem>
                                                <asp:ListItem Value="2">二班</asp:ListItem>
                                                <asp:ListItem Value="3">三班</asp:ListItem>
                                            </asp:DropDownList>
                                        </EditItemTemplate>
                                    </asp:TemplateColumn>
                                    <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" HeaderText="Edit" CancelText="Cancel"
                                        EditText="Edit">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </asp:EditCommandColumn>
                                    <asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete">
                                        <HeaderStyle Width="20px"></HeaderStyle>
                                    </asp:ButtonColumn>
                                </Columns>
                                <PagerStyle HorizontalAlign="Left" ForeColor="#003399" BackColor="#99CCCC" Mode="NumericPages"></PagerStyle>
                            </asp:DataGrid>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id=txtClassName Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"ClassName") %>'>
                            </asp:TextBox>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:TemplateColumn HeaderText="备注">
                        <HeaderStyle Width="300px"></HeaderStyle>
                        <ItemTemplate>
                            <%# DataBinder.Eval(Container.DataItem,"Description") %>
                        </ItemTemplate>
                        <EditItemTemplate>
                            <asp:TextBox id="txtDescription" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Description") %>'>
                            </asp:TextBox>
                        </EditItemTemplate>
                    </asp:TemplateColumn>
                    <asp:EditCommandColumn ButtonType="LinkButton" UpdateText="Update" HeaderText="Edit" CancelText="Cancel"
                        EditText="Edit">
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </asp:EditCommandColumn>
                    <asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete">
                        <HeaderStyle Width="20px"></HeaderStyle>
                    </asp:ButtonColumn>
                </Columns>
                <PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
            </asp:datagrid></form>
    </body>
</HTML>

http://www.pconcool.com

2.cs代码
public class DataGridNesting : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.DataGrid DataGrid1;

        private void Page_Load(object sender, System.EventArgs e)
        {
            if(!Page.IsPostBack)
            {
                BindDataGrid1();
            }
        }

        Web Form Designer generated code#region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
            this.DataGrid1.ItemCreated+=new DataGridItemEventHandler(DataGrid1_ItemCreated);
        }

        /**//**//** <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        GetDataSet#region GetDataSet
        private DataSet GetDataSet(string sql)
        {
            string constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
            SqlDataAdapter    sda =new SqlDataAdapter(sql,constring);
            DataSet ds=new DataSet();
            sda.Fill(ds);
            return ds;
        }
        #endregion

        BindDataGrid1#region BindDataGrid1
        private void BindDataGrid1()
        {
            string sql="select * from Class";
            DataSet ds=GetDataSet(sql);
            this.DataGrid1.DataSource=ds;
            this.DataGrid1.DataBind();
        }
        #endregion

        BindDataGrid2#region BindDataGrid2
        private void BindDataGrid2(DataGrid grid2)
        {
            string sql="select s.ClassID,s.StudentID,s.StudentName,s.Age,c.ClassName from Student s left join Class c on s.ClassID=c.ClassID where s.ClassID='"+DataGrid1.DataKeys[Index].ToString()+"'";
            DataSet ds=GetDataSet(sql);
            grid2.DataSource=ds;
            grid2.DataBind();
        }
        #endregion

http://www.pconcool.com

DataGrid1_ItemDataBound#region DataGrid1_ItemDataBound
        private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
        {
            if (e.Item.ItemType==ListItemType.Header)
　            {
                e.Item.Cells[0].ColumnSpan=2;//合并单元格
                e.Item.Cells[1].Visible=false;
　            }
            if (e.Item.ItemType==ListItemType.Item || e.Item.ItemType==ListItemType.AlternatingItem)
            {
                System.Web.UI.WebControls.ImageButton image = (System.Web.UI.WebControls.ImageButton)e.Item.FindControl("ImageButton1");
                string sql="select s.ClassID,s.StudentID,s.StudentName,s.Age,c.ClassName from Student s left join Class c on s.ClassID=c.ClassID where s.ClassID='"+this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString()+"'";
                DataSet ds=GetDataSet(sql);
                DataGrid grid=(DataGrid)e.Item.FindControl("DataGrid2");
                grid.DataSource=ds;
                grid.DataBind();
                grid.Style.Add("display","none");
            }

        }
        #endregion

        Edit_Grid1#region Edit_Grid1
        protected void Edit_Grid1(object sender,DataGridCommandEventArgs e)
        {
            this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
            BindDataGrid1();
        }
        #endregion

        Cancel_Grid1#region Cancel_Grid1
        protected void Cancel_Grid1(object sender,DataGridCommandEventArgs e)
        {
            this.DataGrid1.EditItemIndex=-1;
            BindDataGrid1();
        }
        #endregion

        Update_Grid1#region Update_Grid1
        protected void Update_Grid1(object sender,DataGridCommandEventArgs e)
        {
            if(e.Item.ItemType==ListItemType.EditItem)
            {
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
                SqlCommand comm=new SqlCommand("update Class set ClassName=@ClassName,Description=@Description where ClassID=@ClassID",conn);
                SqlParameter parm1=new SqlParameter("@ClassName",SqlDbType.NVarChar,50);
                parm1.Value=((TextBox)e.Item.FindControl("txtClassName")).Text;

                SqlParameter parm2=new SqlParameter("@Description",SqlDbType.NVarChar,500);
                parm2.Value=((TextBox)e.Item.FindControl("txtDescription")).Text;

                SqlParameter parm3=new SqlParameter("@ClassID",SqlDbType.NVarChar,50);
                parm3.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];

                comm.Parameters.Add(parm1);
                comm.Parameters.Add(parm2);
                comm.Parameters.Add(parm3);

                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                this.DataGrid1.EditItemIndex=-1;
                BindDataGrid1();
            }
        }
        #endregion

        Delete_Grid1#region Delete_Grid1
        protected void Delete_Grid1(object sender,DataGridCommandEventArgs e)
        {
            deletegrid1(this.DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
        }
        #endregion

http://www.pconcool.com

        deletegrid1#region deletegrid1
        private void deletegrid1(string id)
        {
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
            SqlCommand comm=new SqlCommand("delete from Class where ClassID=@ClassID",conn);
            SqlParameter parm1=new SqlParameter("@ClassID",SqlDbType.NVarChar,50);
            parm1.Value=id;
            comm.Parameters.Add(parm1);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
            BindDataGrid1();
        }
        #endregion

        DataGrid1_ItemCreated#region DataGrid1_ItemCreated
        private void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
        {
            if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem )
            {
                DataGrid grid2 = (DataGrid)e.Item.FindControl( "DataGrid2" );
                grid2.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler( this.grid2_ItemDataBound );
            }
        }
        #endregion

        grid2_ItemDataBound#region grid2_ItemDataBound
        protected void grid2_ItemDataBound(object sender, DataGridItemEventArgs e)
        {
        }
        #endregion

        grid2_EditCommand#region grid2_EditCommand
        protected void grid2_EditCommand(object sender, DataGridCommandEventArgs e)
        {
            DataGrid grid2 = (DataGrid)sender;
            grid2.EditItemIndex = e.Item.ItemIndex;
            BindDataGrid2(grid2);
        }
        #endregion

        grid2_CancelCommand#region grid2_CancelCommand
        protected void grid2_CancelCommand(object sender, DataGridCommandEventArgs e)
        {
            DataGrid grid2 = (DataGrid)sender;
            grid2.EditItemIndex =-1;
            BindDataGrid2(grid2);
        }
        #endregion

        grid2_UpdateCommand#region grid2_UpdateCommand
        protected void grid2_UpdateCommand(object sender, DataGridCommandEventArgs e)
        {
            if(e.Item.ItemType==ListItemType.EditItem)
            {
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
                SqlCommand comm=new SqlCommand("update Student set StudentName=@StudentName,ClassID=@ClassID,Age=@Age where StudentID=@StudentID",conn);
                SqlParameter parm1=new SqlParameter("@StudentName",SqlDbType.NVarChar,50);
                parm1.Value=((TextBox)e.Item.FindControl("txtStudentName")).Text;

                SqlParameter parm2=new SqlParameter("@ClassID",SqlDbType.NVarChar,500);
                parm2.Value=((DropDownList)e.Item.FindControl("drpClass")).SelectedItem.Value;

                SqlParameter parm3=new SqlParameter("@Age",SqlDbType.NVarChar,50);
                parm3.Value=((TextBox)e.Item.FindControl("txtAge")).Text;

                SqlParameter parm4=new SqlParameter("@StudentID",SqlDbType.NVarChar,50);
                parm4.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];

                comm.Parameters.Add(parm1);
                comm.Parameters.Add(parm2);
                comm.Parameters.Add(parm3);
                comm.Parameters.Add(parm4);

                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                DataGrid grid2 = (DataGrid)sender;
                grid2.EditItemIndex =-1;
                BindDataGrid2(grid2);
            }
        }
        #endregion

        grid2_DeleteCommand#region grid2_DeleteCommand
        protected void grid2_DeleteCommand(object sender, DataGridCommandEventArgs e)
        {
            DataGrid grid2 = (DataGrid)sender;
            DeleteGrid2(grid2.DataKeys[e.Item.ItemIndex].ToString());
            grid2.EditItemIndex =-1;
            BindDataGrid2(grid2);
        }

        #endregion