DataGrid嵌套DataGrid

来源：互联网发布：网络语言bbs是什么意思编辑：程序博客网时间：2024/05/02 00:21

1.html代码

<HTML>

<HEAD>

<title>DataGridNesting</title>

</HEAD>

<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">

<asp:TemplateColumn HeaderText="序号">

<%# Container.ItemIndex+1 %>

</ItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="序号">

<asp:ImageButton id="ImageButton1" runat="server" ImageUrl="add.gif"></asp:ImageButton>

</ItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn Visible="False" DataField="ClassID" HeaderText="ClassID">

</asp:BoundColumn>

<asp:TemplateColumn HeaderText="班级">

<%# 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">

<asp:TemplateColumn HeaderText="序号">

<%# Container.ItemIndex+1 %>

</ItemTemplate>

</asp:TemplateColumn>

<asp:BoundColumn Visible="False" DataField="StudentID" HeaderText="StudentID">

</asp:BoundColumn>

<asp:TemplateColumn HeaderText="姓名">

<%# DataBinder.Eval(Container.DataItem,"StudentName") %>

</ItemTemplate>

<asp:TextBox id="txtStudentName" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"StudentName") %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="年龄">

<%# DataBinder.Eval(Container.DataItem,"Age") %>

</ItemTemplate>

<asp:TextBox id="txtAge" Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"Age") %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="班级">

<%# DataBinder.Eval(Container.DataItem,"ClassName") %>

</ItemTemplate>

<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">

</asp:EditCommandColumn>

<asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete">

</asp:ButtonColumn>

</Columns>

</asp:DataGrid>

</ItemTemplate>

<asp:TextBox id=txtClassName Runat="server" Text='<%# DataBinder.Eval(Container.DataItem,"ClassName") %>'>

</asp:TextBox>

</EditItemTemplate>

</asp:TemplateColumn>

<asp:TemplateColumn HeaderText="备注">

<%# DataBinder.Eval(Container.DataItem,"Description") %>

</ItemTemplate>

<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">

</asp:EditCommandColumn>

<asp:ButtonColumn Text="Delete" HeaderText="Delete" CommandName="Delete">

</asp:ButtonColumn>

</Columns>

</asp:datagrid></form>

</body>

</HTML>

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();
            }
        }

        #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

        #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

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

        #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

        #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

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

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

        #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

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

        #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

        #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

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

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

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

        #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

        #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

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

        #region property
        private int Index
        {
            get
            {
                if(ViewState["Index"]!=null && ViewState["Index"].ToString()!="")
                {
                    return Convert.ToInt32(ViewState["Index"]);
                }
                else
                {
                    return -1;
                }
            }
            set
            {
                ViewState["Index"]=value;
            }
        }
        #endregion

        #region Item_Command
        protected void Item_Command(object sender,DataGridCommandEventArgs e)
        {
            Index=e.Item.ItemIndex;
            System.Web.UI.WebControls.ImageButton image = (System.Web.UI.WebControls.ImageButton)e.Item.FindControl("ImageButton1");
            DataGrid grid=(DataGrid)e.Item.FindControl("DataGrid2");
            if(image.ImageUrl=="add.gif")
            {
                image.ImageUrl="sub.gif";
                grid.Style.Add("display","block");
            }
            else
            {
                image.ImageUrl="add.gif";
                grid.Style.Add("display","none");
            }
        }
        #endregion

    }