功能齐全的DataGrid

最新推荐文章于 2019-05-19 00:46:32 发布
最新推荐文章于 2019-05-19 00:46:32 发布
阅读量332 收藏
点赞数
分类专栏： 基础知识 文章标签： datagrid server sql delete button textbox

// 目前功能：编辑、排序、单选项、复选项、合并单元格、产生序列号、联动下拉框、删除、超连接、鼠标移动改变颜色、奇偶项颜色区分、排序、分页

1.html代码
< HTML >
     < HEAD >
         < title > DatagridTest </ 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" >
         < script  language ="javascript" >
            function fun_option(obj)
            {
                document.Form1.hiduserid.value=obj.value;
            }            
            function chkAll_true()
            {
                var chkall= document.all["chkAll"];
                var chkother= document.getElementsByTagName("input");
                for (var i=0;i<chkother.length;i++)
                {
                    if( chkother[i].type=='checkbox')
                    {
                        if(chkother[i].id.indexOf('chkExport')>-1)
                        {
                            if(chkall.checked==true)
                            {
                                chkother[i].checked=true;
                            }
                            else
                            {
                                chkother[i].checked=false;
                            }
                        }
                    }
                }
            }
            
            function Delete()
            {
                var  al = new Array();
                var chkother= document.getElementsByTagName("input");
                for(var i=0,j=0;i<chkother.length;i++)
                {
                    if( chkother[i].type =='checkbox')
                    {
                        if(chkother[i].id.indexOf('chkExport')>-1)
                        {
                            if(chkother[i].checked==true)
                            {
                                al[j] =chkother[i].value;
                                j++;
                            }
                        }
                    }
                }
                if (al == "")
                {
                    alert('You need to select a row in the list before selecting Delete./r/nPlease select a row and try again.');
                }
                else if (window.confirm("Are you sure to delete all these?"))
                {
                    var deleteID='<%=btndelete.ClientID%>';
                    window.document.all(deleteID).click();
                }
                else { return false; }               
            }
         </ script >
     </ HEAD >
     < body >
         < form  id ="Form1"  method ="post"  runat ="server" >
             < TABLE  id ="Table1"  height ="100%"  cellSpacing ="1"  cellPadding ="1"  width ="100%"  border ="1" >
                 < tr >
                     < td >< asp:dropdownlist  id ="DropDownList1"  runat ="server"  AutoPostBack ="True" ></ asp:dropdownlist >< asp:dropdownlist  id ="DropDownList2"  runat ="server"  AutoPostBack ="True" ></ asp:dropdownlist >< asp:dropdownlist  id ="DropDownList3"  runat ="server" ></ asp:dropdownlist >< asp:textbox  id ="TextBox1"  runat ="server" ></ asp:textbox >< asp:checkbox  id ="CheckBox1"  runat ="server"  Text ="可见否" ></ asp:checkbox >< asp:button  id ="Button1"  runat ="server"  Text ="保存" ></ asp:button >< asp:button  id ="Button2"  runat ="server"  Text ="导出Excel" ></ asp:button ></ td >
                 </ tr >
                 < tr  height ="30" >
                     < td >< INPUT  id ="chkAll"  onclick ="chkAll_true()"  type ="checkbox" > 全选/取消 < asp:button  id ="btndelete"  runat ="server"  Text ="删除" ></ asp:button ></ td >
                 </ tr >
                 < TR  vAlign ="top" >
                     < TD  width ="100%"  colSpan ="5" >< asp:datagrid  id ="DataGrid1"  runat ="server"  OnDeleteCommand ="Delete"  ForeColor ="Black"  GridLines ="None"
                            CellPadding ="2"  BackColor ="LightGoldenrodYellow"  BorderWidth ="1px"  BorderColor ="Tan"  AllowSorting ="True"  AutoGenerateColumns ="False"
                            DataKeyField ="UserID"  OnUpdateCommand ="Update"  OnCancelCommand ="Cancel"  OnEditCommand ="Edit"  PageSize ="5"  AllowPaging ="True" >
                             < FooterStyle  BackColor ="Tan" ></ FooterStyle >
                             < SelectedItemStyle  ForeColor ="GhostWhite"  BackColor ="DarkSlateBlue" ></ SelectedItemStyle >
                             < AlternatingItemStyle  BackColor ="PaleGoldenrod" ></ AlternatingItemStyle >
                             < HeaderStyle  Font-Bold ="True"  BackColor ="Tan" ></ HeaderStyle >
                             < Columns >
                                 < asp:TemplateColumn  HeaderText ="序号" >
                                     < HeaderStyle  Width ="10px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         < INPUT  id =radio  onclick =fun_option(this)  type =radio  value ='<%#  DataBinder.Eval(Container.DataItem,"UserID") % > ' name=radio>
                                     </ ItemTemplate >
                                     < FooterTemplate >
                                     </ FooterTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn  HeaderText ="序号" >
                                     < HeaderStyle  Width ="10px" ></ HeaderStyle >
                                     < FooterTemplate >
                                     </ FooterTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn >
                                     < HeaderStyle  Width ="10px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         < asp:CheckBox  id ="chkExport"  Runat ="server" ></ asp:CheckBox >
                                     </ ItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:BoundColumn  DataField ="UserID"  SortExpression ="UserID"  ReadOnly ="True"  HeaderText ="UserID" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                 </ asp:BoundColumn >
                                 < asp:TemplateColumn  SortExpression ="UserName"  HeaderText ="姓名" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         < a  href ='form1.aspx?id=<%#  DataBinder.Eval(Container.DataItem,"UserID") % > &name = <% # DataBinder.Eval(Container.DataItem,"UserName")  %> ' target="_blank">
                                             <% # DataBinder.Eval(Container.DataItem,"UserName")  %>
                                         </ a >
                                     </ ItemTemplate >
                                     < EditItemTemplate >
                                         < asp:TextBox  id =UserName  Text ='<%#  DataBinder.Eval(Container.DataItem,"UserName") % > ' Width="100%" Runat="server">
                                         </ asp:TextBox >
                                     </ EditItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn  SortExpression ="province"  HeaderText ="省市" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         <% # DataBinder.Eval(Container.DataItem,"province")  %>
                                     </ ItemTemplate >
                                     < EditItemTemplate >
                                         < asp:DropDownList  id ="province"  Width ="100%"  Runat ="server"  AutoPostBack ="True"  OnSelectedIndexChanged ="ddlprovince_SelectedIndexChanged" ></ asp:DropDownList >
                                     </ EditItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn  SortExpression ="city"  HeaderText ="县市" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         <% # DataBinder.Eval(Container.DataItem,"city")  %>
                                     </ ItemTemplate >
                                     < EditItemTemplate >
                                         < asp:DropDownList  id ="city"  Runat ="server"  Width ="100%"  AutoPostBack ="True"  OnSelectedIndexChanged ="ddlcity_SelectedIndexChanged" ></ asp:DropDownList >
                                     </ EditItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn  SortExpression ="area"  HeaderText ="乡镇" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         <% # DataBinder.Eval(Container.DataItem,"area")  %>
                                     </ ItemTemplate >
                                     < EditItemTemplate >
                                         < asp:DropDownList  id ="area"  Runat ="server"  Width ="100%" ></ asp:DropDownList >
                                     </ EditItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:TemplateColumn  SortExpression ="Enabled"  HeaderText ="可见否" >
                                     < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     < ItemTemplate >
                                         <% # DataBinder.Eval(Container.DataItem,"Enabled")  %>
                                     </ ItemTemplate >
                                     < EditItemTemplate >
                                         < asp:CheckBox  id =chkenabled  Runat ="server"  Checked ='<%#  DataBinder.Eval(Container.DataItem,"Enabled") % > '>
                                         </ asp:CheckBox >
                                     </ EditItemTemplate >
                                 </ asp:TemplateColumn >
                                 < asp:EditCommandColumn  ButtonType ="PushButton"  UpdateText ="更新"  HeaderText ="编辑"  CancelText ="取消"  EditText ="编辑" ></ asp:EditCommandColumn >
                                 < asp:ButtonColumn  Text ="删除"  ButtonType ="PushButton"  HeaderText ="删除"  CommandName ="Delete" ></ asp:ButtonColumn >
                             </ Columns >
                             < PagerStyle  NextPageText ="下一页"  PrevPageText ="上一页"  HorizontalAlign ="Right"  ForeColor ="DarkSlateBlue"
                                BackColor ="PaleGoldenrod"  Mode ="NumericPages" ></ PagerStyle >
                         </ asp:datagrid ></ TD >
                 </ TR >
                 < tr  height ="30" >
                     < td ></ td >
                 </ tr >
             </ TABLE >
             < INPUT  id ="hiduserid"  type ="hidden"  runat ="server" >
         </ form >
     </ body >
</ HTML >
2.cs代码
using  System.Data.SqlClient;
 using  System.Text;

public   class  DatagridTest : System.Web.UI.Page
     {
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.HtmlControls.HtmlInputHidden hiduserid;
        protected System.Web.UI.WebControls.Button btndelete;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
        protected System.Web.UI.WebControls.DropDownList DropDownList2;
        protected System.Web.UI.WebControls.DropDownList DropDownList3;
        protected System.Web.UI.WebControls.CheckBox CheckBox1;
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.Button Button2;

        private string constring="";        
        
        private void Page_Load(object sender, System.EventArgs e)
        {
            if(!Page.IsPostBack)
            {
                ListProvince();
                ListCity();
                ListArea();

                btndelete.Attributes.Add("onclick","return Delete();");
                SortExpression="";
                sort="desc";
                DataBind();
            }            
        }


        #region DataBind
        private void DataBind()
        {
            string sql="select a.UserID,a.UserName,b.province,c.city,d.area,a.Enabled,b.provinceID,c.cityID,d.areaID from testgrid a ";
            sql+=" left join province b on a.provinceID=b.provinceID";
            sql+=" left join city c on a.cityID=c.cityID";
            sql+=" left join area d on a.areaID=d.areaID";
            DataSet ds=GetDataSet(sql);
            dt=ds.Tables[0];
            dt.DefaultView.Sort="UserID asc";
            dt.AcceptChanges();
            this.DataGrid1.DataSource=dt;
            this.DataGrid1.DataBind();
        }
        #endregion

        #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.ItemDataBound+=new DataGridItemEventHandler(DataGrid1_ItemDataBound);
            this.DataGrid1.SortCommand+=new DataGridSortCommandEventHandler(DataGrid1_SortCommand);
            this.DataGrid1.ItemCreated+=new DataGridItemEventHandler(DataGrid1_ItemCreated);
            this.DataGrid1.PageIndexChanged+=new DataGridPageChangedEventHandler(DataGrid1_PageIndexChanged);
            this.btndelete.Click += new System.EventHandler(this.btndelete_Click);
            this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
            this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.Button2.Click += new System.EventHandler(this.Button2_Click);
        }
        
        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {    
            this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
            this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
            this.Button1.Click += new System.EventHandler(this.Button1_Click);
            this.Button2.Click += new System.EventHandler(this.Button2_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        #region GetDataSet
        private DataSet GetDataSet(string sql)
        {
            constring=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
            SqlDataAdapter    sda =new SqlDataAdapter(sql,constring);
            DataSet ds=new DataSet();
            sda.Fill(ds);
            return ds;
        }
        #endregion
        
        #region DataGrid1_ItemDataBound
        private void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
        {            
            e.Item.Cells[1].Text=Convert.ToString(e.Item.ItemIndex+1);//产生序号
            if(e.Item.ItemType!=ListItemType.Header)
            {
                if(e.Item.ItemIndex%2==0)
                {
                    e.Item.Attributes.Add( "onmouseout","this.style.backgroundColor='PaleGoldenrod'");
                }
                else
                {
                    e.Item.Attributes.Add( "onmouseout","this.style.backgroundColor='LightGoldenrodYellow'");
                }
　　            e.Item.Attributes.Add( "onmouseover","this.style.backgroundColor='#C1D2EE'");
            }
            switch (e.Item.ItemType)
            {
                case ListItemType.Item:
                case ListItemType.AlternatingItem:
                    e.Item.Attributes.Add("ondblclick","alert('"+e.Item.ItemIndex+"');");                    
                    break;
                case ListItemType.Header:
                    e.Item.Cells[0].ColumnSpan=2;//合并单元格
                    e.Item.Cells[1].Visible=false;
                    break;
                case ListItemType.EditItem:
                    for (int i=4; i < DataGrid1.Columns.Count-2; i++)//只调整被编辑的列
                    {
　　                    if(e.Item.ItemType==ListItemType.EditItem)
　　                    {
　　　                        e.Item.Cells[i].Attributes.Add("Width", "70px");
　　                    }
                    }
                    string sqlprovince="select * from province";
                    DataSet dsprovince=GetDataSet(sqlprovince);
                    //一级
                    if(e.Item.ItemType==ListItemType.EditItem)
                    {
                        DropDownList ddlprovince=(DropDownList)e.Item.FindControl("province");
                        ddlprovince.DataSource=dsprovince;
                        ddlprovince.DataTextField="province";
                        ddlprovince.DataValueField="provinceID";
                        ddlprovince.DataBind();
                        ddlprovince.Items.FindByValue(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"provinceID"))).Selected=true;
                        //二级
                        if(e.Item.ItemType==ListItemType.EditItem)
                        {
                            if(ddlprovince.SelectedIndex!=-1)
                            {
                                string sqlcity="select * from city where father='"+ddlprovince.SelectedValue+"'";
                                DropDownList ddlcity=(DropDownList)e.Item.FindControl("city");
                                DataSet dscity=GetDataSet(sqlcity);                
                                ddlcity.DataSource=dscity;
                                ddlcity.DataTextField="city";
                                ddlcity.DataValueField="cityID";
                                ddlcity.DataBind();
                                ddlcity.Items.FindByValue(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"cityID"))).Selected=true;
                                //三级
                                if(e.Item.ItemType==ListItemType.EditItem)
                                {
                                    if(ddlcity.SelectedIndex!=-1)
                                    {
                                        string sqlarea="select * from area where father='"+ddlcity.SelectedValue+"'";
                                        DropDownList ddlarea=(DropDownList)e.Item.FindControl("area");
                                        DataSet dsarea=GetDataSet(sqlarea);                
                                        ddlarea.DataSource=dsarea;
                                        ddlarea.DataTextField="area";
                                        ddlarea.DataValueField="areaID";
                                        ddlarea.DataBind();
                                        ddlarea.Items.FindByValue(Convert.ToString(DataBinder.Eval(e.Item.DataItem,"areaID"))).Selected=true;
                                    }
                                }
                            }
                        }
                    }
                    break;
                default:
                    break;
            }            
        }
        #endregion

        #region DataGrid1_SortCommand
        private void DataGrid1_SortCommand(object source, DataGridSortCommandEventArgs e)
        {
            if(SortExpression==e.SortExpression.ToString())
            {
                if(sort=="asc")
                {
                    sort="desc";
                }
                else
                {
                    sort="asc";
                }
            }
            else
            {
                if(sort=="asc")
                {
                    sort="desc";
                }
                else
                {
                    sort="asc";
                }
            }
            SortExpression=e.SortExpression;
            dt.DefaultView.Sort=e.SortExpression+" "+sort;
            DataGrid1.DataSource=dt;
            DataGrid1.DataBind();
        }
        #endregion

        #region DataGrid1_ItemCreated
        private void DataGrid1_ItemCreated(object sender, DataGridItemEventArgs e)
        {
            for (int i=3; i < DataGrid1.Columns.Count-2; i++)//-2的意思是两个button列不用排序
            {
                if (i == 0) continue;
                if(e.Item.ItemIndex==-1)
                {
                    if (DataGrid1.Columns[i].SortExpression == SortExpression)
                    {
                        try
                        {
                            TableCell tableCell = e.Item.Cells[i];
                            Label label = new Label();
                            label.Font.Name = "webdings";
                            if(sort=="asc")
                            {
                                label.Text="6";
                            }
                            else
                            {
                                label.Text="5";
                            }
                            label.Width =20;
                            tableCell.Controls.Add(label);
                        }
                        catch{}
                    }
                }
            }
            foreach(DataGridItem di in this.DataGrid1.Items) 
　            {
                if(di.ItemType==ListItemType.Item||di.ItemType==ListItemType.AlternatingItem) 
　　            { 
　　　                ((Button)di.Cells[10].Controls[0]).Attributes.Add("onclick","return confirm('确认删除此项吗?');"); 
　　            } 
            }
        }


        #endregion

        #region property
        private DataTable dt
        {
            get
            {
                if(ViewState["dt"]!=null)
                {
                    return (DataTable)ViewState["dt"];
                }
                else
                {
                    return null;
                }
            }
            set
            {
                ViewState["dt"]=value;
            }
        }
        private string SortExpression
        {
            get
            {
                if(ViewState["SortExpression"]!=null && ViewState["SortExpression"].ToString()!=string.Empty)
                {
                    return ViewState["SortExpression"].ToString();
                }
                else
                {
                    return "";
                }
            }
            set
            {
                ViewState["SortExpression"]=value;
            }
        }
        private string sort
        {
            get
            {
                if(ViewState["sort"]!=null && ViewState["sort"].ToString()!=string.Empty)
                {
                    return ViewState["sort"].ToString();
                }
                else
                {
                    return "";
                }
            }
            set
            {
                ViewState["sort"]=value;
            }
        }
        #endregion

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

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

        #region Update
        protected void Update(object sender,DataGridCommandEventArgs e)
        {
            if(e.Item.ItemType==ListItemType.EditItem)
            {
                SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
                SqlCommand comm=new SqlCommand("update testgrid set UserName=@UserName,provinceID=@province,cityID=@city,areaID=@area,Enabled=@Enabled where UserID=@UserID",conn);
                SqlParameter parm1=new SqlParameter("@UserName",SqlDbType.NVarChar,50);
                parm1.Value=((TextBox)e.Item.FindControl("UserName")).Text;

                SqlParameter parm2=new SqlParameter("@province",SqlDbType.NVarChar,50);
                parm2.Value=((DropDownList)e.Item.FindControl("province")).SelectedValue;

                SqlParameter parm3=new SqlParameter("@city",SqlDbType.NVarChar,50);
                parm3.Value=((DropDownList)e.Item.FindControl("city")).SelectedValue;    
            
                SqlParameter parm4=new SqlParameter("@area",SqlDbType.NVarChar,50);
                parm4.Value=((DropDownList)e.Item.FindControl("area")).SelectedValue;

                SqlParameter parm5=new SqlParameter("@Enabled",SqlDbType.Bit);
                parm5.Value=((CheckBox)e.Item.FindControl("chkenabled")).Checked;


                SqlParameter parm6=new SqlParameter("@UserID",SqlDbType.Int);
                parm6.Value=this.DataGrid1.DataKeys[e.Item.ItemIndex];

                comm.Parameters.Add(parm1);
                comm.Parameters.Add(parm2);
                comm.Parameters.Add(parm3);
                comm.Parameters.Add(parm4);
                comm.Parameters.Add(parm5);
                comm.Parameters.Add(parm6);
                conn.Open();
                comm.ExecuteNonQuery();
                conn.Close();
                this.DataGrid1.EditItemIndex=-1;
                DataBind();
            }
        }
        #endregion

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

        #region ddlprovince_SelectedIndexChanged
        public void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)
        {
            DropDownList ddlprovince = sender as DropDownList;
            if(ddlprovince.SelectedIndex!=-1)
            {
                DropDownList ddlcity = ((Control)(((Control)sender)).Parent).FindControl("city") as DropDownList;
                string sqlcity="select * from city where father='"+ddlprovince.SelectedValue+"'";
                DataSet dscity=GetDataSet(sqlcity);
                ddlcity.DataSource=dscity;
                ddlcity.DataTextField="city";
                ddlcity.DataValueField="cityID";
                ddlcity.DataBind();
            }
        }
        #endregion

        #region ddlcity_SelectedIndexChanged
        public void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
        {
            DropDownList ddlcity = sender as DropDownList;
            if(ddlcity.SelectedIndex!=-1)
            {
                DropDownList ddlarea = ((Control)(((Control)sender)).Parent).FindControl("city") as DropDownList;
                string sqlarea="select * from area where father='"+ddlcity.SelectedValue+"'";
                DataSet dsarea=GetDataSet(sqlarea);
                ddlarea.DataSource=dsarea;
                ddlarea.DataTextField="area";
                ddlarea.DataValueField="areaID";
                ddlarea.DataBind();
            }
        }
        #endregion

        #region btndelete_Click
        private void btndelete_Click(object sender, System.EventArgs e)
        {
            StringBuilder s=new StringBuilder();
            foreach(DataGridItem di in DataGrid1.Items) 
            { 
　                if(((CheckBox)(di.FindControl("chkExport"))).Checked==true) 
　                { 
　　                s.Append(",").Append(DataGrid1.DataKeys[di.ItemIndex].ToString());
　                } 
            } 
            if(s.ToString().StartsWith(",")==true)
            {
                delete(s.ToString().Substring(1,s.ToString().Length-1));
            }
        }
        #endregion

        #region delete
        private void delete(string id)
        {
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
            string sql=@"declare @sql nvarchar(400)
                        set @sql = 'delete from testgrid where UserID in('+@UserID+')'
                        exec( @sql)";
            SqlCommand comm=new SqlCommand(sql,conn);
            SqlParameter parm1=new SqlParameter("@UserID",SqlDbType.VarChar,200);
            parm1.Value=id;
            comm.Parameters.Add(parm1);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
            DataBind();
        }
        #endregion

        #region ListProvince
        private void ListProvince()
        {
            string sql="select * from province";
            DataSet ds=GetDataSet(sql);
            DropDownList1.DataSource=ds;
            DropDownList1.DataTextField="province";
            DropDownList1.DataValueField="provinceID";
            DropDownList1.DataBind();
        }
        #endregion

        #region ListCity
        private void ListCity()
        {
            if(DropDownList1.SelectedIndex!=-1)
            {
                string sql="select * from city where father='"+DropDownList1.SelectedValue+"'";
                DataSet ds=GetDataSet(sql);
                DropDownList2.DataSource=ds;
                DropDownList2.DataTextField="city";
                DropDownList2.DataValueField="cityID";
                DropDownList2.DataBind();
            }
        }
        #endregion

        #region ListArea
        private void ListArea()
        {
            if(DropDownList2.SelectedIndex!=-1)
            {
                string sql="select * from area where father='"+DropDownList2.SelectedValue+"'";
                DataSet ds=GetDataSet(sql);            
                DropDownList3.DataSource=ds;
                DropDownList3.DataTextField="area";
                DropDownList3.DataValueField="areaID";
                DropDownList3.DataBind();
            }
        }
        #endregion

        #region save
        private void Button1_Click(object sender, System.EventArgs e)
        {
            SqlConnection conn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
            SqlCommand comm=new SqlCommand("insert into testgrid (UserName,provinceID,cityID,areaID,Enabled) values(@UserName,@provinceID,@cityID,@areaID,@Enabled)",conn);
            SqlParameter parm1=new SqlParameter("@UserName",SqlDbType.NVarChar,50);
            parm1.Value=this.TextBox1.Text;

            SqlParameter parm2=new SqlParameter("@provinceID",SqlDbType.NVarChar,50);
            parm2.Value=this.DropDownList1.SelectedValue;

            SqlParameter parm3=new SqlParameter("@cityID",SqlDbType.NVarChar,50);
            parm3.Value=this.DropDownList2.SelectedValue;    
            
            SqlParameter parm4=new SqlParameter("@areaID",SqlDbType.NVarChar,50);
            parm4.Value=this.DropDownList3.SelectedValue;

            SqlParameter parm5=new SqlParameter("@Enabled",SqlDbType.Bit);
            parm5.Value=this.CheckBox1.Checked;

            comm.Parameters.Add(parm1);
            comm.Parameters.Add(parm2);
            comm.Parameters.Add(parm3);
            comm.Parameters.Add(parm4);
            comm.Parameters.Add(parm5);
            conn.Open();
            comm.ExecuteNonQuery();
            conn.Close();
            DataBind();
        }
        #endregion

        private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            ListCity();
        }

        private void DropDownList2_SelectedIndexChanged(object sender, System.EventArgs e)
        {
            ListArea();
        }

        private void Button2_Click(object sender, System.EventArgs e)
        {
            ToExcel(this.DataGrid1,"meng");
        }

        #region ToExcel
        public static void ToExcel(System.Web.UI.Control ctl,string FileName)
        {
            HttpContext.Current.Response.Charset ="UTF-8";
            HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.Default;
            HttpContext.Current.Response.ContentType ="application/ms-excel";
            HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename="+""+FileName+".xls");
            ctl.Page.EnableViewState =false;
            System.IO.StringWriter  tw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
            ctl.RenderControl(hw);
            HttpContext.Current.Response.Write(tw.ToString());
            HttpContext.Current.Response.End();
        }        
        #endregion
        
        private void DataGrid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
        {
            this.DataGrid1.CurrentPageIndex=e.NewPageIndex;
            DataBind();
        }
    }

3. 数据库教本(或下载真实数据 /Files/singlepine/area.rar)
if   exists  ( select   *   from  dbo.sysobjects  where  id  =   object_id (N ' [dbo].[TestGrid] ' )  and   OBJECTPROPERTY (id, N ' IsUserTable ' )  =   1 )
 drop   table   [ dbo ] . [ TestGrid ]
GO

if   exists  ( select   *   from  dbo.sysobjects  where  id  =   object_id (N ' [dbo].[province] ' )  and   OBJECTPROPERTY (id, N ' IsUserTable ' )  =   1 )
 drop   table   [ dbo ] . [ province ]
GO

if   exists  ( select   *   from  dbo.sysobjects  where  id  =   object_id (N ' [dbo].[city] ' )  and   OBJECTPROPERTY (id, N ' IsUserTable ' )  =   1 )
 drop   table   [ dbo ] . [ city ]
GO

if   exists  ( select   *   from  dbo.sysobjects  where  id  =   object_id (N ' [dbo].[area] ' )  and   OBJECTPROPERTY (id, N ' IsUserTable ' )  =   1 )
 drop   table   [ dbo ] . [ area ]
GO

CREATE   TABLE   [ dbo ] . [ TestGrid ]  (
     [ UserID ]   [ int ]   IDENTITY  ( 1 ,  1 )  NOT   NULL  ,
     [ UserName ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ provinceID ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ cityID ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ areaID ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ Enabled ]   [ bit ]   NULL  
)  ON   [ PRIMARY ]
GO

CREATE   TABLE   [ dbo ] . [ province ]  (
     [ id ]   [ int ]   NOT   NULL  ,
     [ provinceID ]   [ nvarchar ]  ( 6 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ province ]   [ nvarchar ]  ( 40 ) COLLATE Chinese_PRC_CI_AS  NULL  
)  ON   [ PRIMARY ]
GO

CREATE   TABLE   [ dbo ] . [ city ]  (
     [ id ]   [ int ]   NOT   NULL  ,
     [ cityID ]   [ nvarchar ]  ( 6 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ city ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ father ]   [ nvarchar ]  ( 6 ) COLLATE Chinese_PRC_CI_AS  NULL  
)  ON   [ PRIMARY ]
GO

CREATE   TABLE   [ dbo ] . [ area ]  (
     [ id ]   [ int ]   NOT   NULL  ,
     [ areaID ]   [ nvarchar ]  ( 50 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ area ]   [ nvarchar ]  ( 60 ) COLLATE Chinese_PRC_CI_AS  NULL  ,
     [ father ]   [ nvarchar ]  ( 6 ) COLLATE Chinese_PRC_CI_AS  NULL  
)  ON   [ PRIMARY ]
GO
4.源代码下载 /Files/singlepine/datagrid.rar
jiang_ideal
关注
专栏目录
VC DataGrid控件使用总结
bcbobo21cn的专栏
04-01 3884
MS CDataGrid控件用法详解 本文示例源代码或素材下载 。DataGrid控件是VC方便地用来显示数据的一个极好的网格控件，我不否认网上还有期它不少优秀的网格控件，但我总喜欢使用微软自已的东西 。除非它满足不了我的需要。不是我太依赖Microsoft，你想想，如果你最常用的开发工具是VC，VC是微软的主打开发工具，它与Ｗindows系统的兼容性极好，连它的控件也不例外，你为何不
xptable，功能齐全的表单控件
04-09
XP风格的强大表单控件，使用时请先添加项目引用
一个功能齐全的DataGrid分页例子
技术资料收集站
07-30 325
C#版本 例子 DataGridPaging.aspx  AutoEventWireup="false" Inherits="eMeng.Exam.DataGridPaging.DataGridPaging" %> HorizontalAlign="Center" AlternatingItemStyle-BackColor="#e
VC++2005中用到的DataGrid控件的CDataGrid类成员
K.Mong的学习笔记
02-01 2011
成员就这么多，至于每个的用法，慢慢补充吧 CDataGrid::CaptureImage CDataGrid::ClearFields CDataGrid::ClearSelCols CDataGrid::ColContaining CDataGrid::Create CDataGrid::Create CDataGrid::DECLARE_DYNCREATE CDat
功能齐全的DataGrid分页例子
07-29
这个"功能齐全的DataGrid分页例子"着重展示了如何有效地实现DataGrid的分页功能，以提高用户体验并优化服务器性能。 首先，DataGrid的分页涉及到数据绑定和用户交互两部分。在ASP.NET中，DataGrid可以通过两种方式...
功能齐全的datagrid.rar
04-03
这个名为"功能齐全的datagrid.rar"的压缩包文件很可能包含了一款具有丰富特性和功能的数据网格控件，用于高效地展示、操作和管理大量结构化数据。 首先，我们来了解一下什么是DataGrid。DataGrid通常是一个表格形式...
datagrid的功能齐全的分页范例
01-18
这个"datagrid的功能齐全的分页范例"是针对如何高效地处理大量数据并提供良好的用户体验的一个实例。分页是大数据量显示时的关键功能，它能够避免一次性加载所有数据导致的性能问题和用户界面卡顿。 `Ajax`...
datagrid:Nette 框架的 Nextras Datagrid 组件
05-29
这个组件提供了一种高效的方式来显示和操作大量数据，它具有丰富的功能和高度可定制性，使得在 Web 应用程序中创建美观且功能齐全的数据表格变得简单易行。 首先，我们来了解一下 `Nextras Datagrid` 的核心概念和...
C1DataGridDemo完整解决-.zip
06-04
使用DataGrid控件，在实时测试过程中，动态添加列，刷新数据功能
DataGrid使用技巧
12-09
DataGrid使用技巧vDataGrid使用技巧DataGrid使用技巧
DataGridView绑定源码下载
weixin_33918114的博客
05-20 107
效果图：     源码下载：http://hovertree.com/h/bjaf/bbot18bj.htm 上面源码不包含数据库的查询，需要获取数据库数据的话，请看这个的源码： http://hovertree.com/h/bjaf/scjyuanma.htm 参考：http://hovertree.com/h/bjaf/feao233c.htm   base 64 编码：htt...
ASP.NET——实现两个下拉框动态联动
weixin_30311605的博客
08-11 1396
引入： 在网页中，我们经常会遇到下图中的情况。首先在下拉框中选择所在的省，选择之后，第二个下拉框会自动加载出该省中的市。这样设计极大的方便了用户的查找。那这是如何实现的呢？ 1、建立数据库 “省”表 “市”表 2、添加控件 3、两个下拉框分别绑定数据源 protected void Page_Load...
easyui datagrid 列隐藏和显示
热门推荐
代码笔记
10-23 4万+
easyui datagrid 列隐藏和显示
分享个很漂亮，功能模块又齐全的后台管理模板
qq_24247249的博客
12-08 2829
http://ruoyi.vip/
easyui datagrid hidden 和hideColumn 的区别
bluefish_flying的博客
03-22 5132
查看easyui.js  源码 根据源码hidden 再后面会覆盖上面的设置，应该是设置了，设置 hidden 后再设置hideColumn会报错hideColumnhiddenhidden设置的时候td 添加了style='display:none;width:0;'  可以直接使td元素隐藏  但是 hideColumn 只是添加了style='width:0;' 但是td里面的div有宽度也...
【开发工具】IntelliJ DataGrip 的使用
Yuu
05-19 1712
配置 设置数据源 选择 MySQL 驱动版本（若你的电脑安装的是 MySQL8，就选择 MySQL，若是 5.x 版本，则选择 MySQL for 5.1） 填写数据库的用户名密码（Database 可以指定连接数据库，不写就查出所有数据库） 测试连接（提示没有连接驱动，选择下载驱动文件） 驱动下载完成后，测试连接 点击数字，查询出所有数据库 配置完成 ...
DataGrid实现信息提示功能详解
在本文档中，我们将探讨如何在DataGrid组件中实现tooltip功能，以提供更丰富的用户交互体验。DataGrid通常用于展示表格数据，而tooltip是一种常用的交互式元素，当鼠标悬停在特定单元格上时，会显示包含额外信息的...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值