功能齐全的DataGrid （根据小山老师的例子修改的）

最新推荐文章于 2018-06-14 11:43:28 发布
最新推荐文章于 2018-06-14 11:43:28 发布
阅读量1.6k 收藏
点赞数
文章标签： datagrid asp webform server object string
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zhaoxiaoyang5156/article/details/1627177
版权
这个例子是才对初学的人才看的，如果你是高手，你不要看。因为那样会浪费您宝贵的时间。。  
下面的是WebForm1.aspx文件        源文件下载                       数据库文件下载           
<% @ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="DatagridTest1.WebForm1"  %>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"  >
< HTML >
     < HEAD >
         < title > WebForm1 </ 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" >
         < LINK  href ="http://www.jxecstac.com/web/160/image/style.css"  type ="text/css"  rel ="stylesheet" >
         < style  type ="text/css" > .a1 {
    BORDER-RIGHT: #ff0000 1px solid; BORDER-TOP: #ff0000 1px solid; BORDER-LEFT: #ff0000 1px solid; BORDER-BOTTOM: #ff0000 1px solid
}
         </ style >
     </ HEAD >
     < body  MS_POSITIONING ="GridLayout" >
         < form  id ="Form1"  method ="post"  runat ="server" >
             < FONT  id ="FONT1" >
                 < TABLE  class ="a1"  id ="Table1"  style ="Z-INDEX: 101; LEFT: 8px; WIDTH: 832px; POSITION: absolute; TOP: 8px; HEIGHT: 307px"
                    cellSpacing ="0"  cellPadding ="0"  width ="832"  border ="1" >
                     < TR >
                         < TD  class ="a1"  style ="HEIGHT: 52px" >< 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 >
                         < TD  class ="a1"  style ="HEIGHT: 6px" >< asp:checkbox  id ="CheckBox2"  runat ="server"  AutoPostBack ="True"  Text ="全部选择" ></ asp:checkbox >< asp:button  id ="btndelete"  runat ="server"  Text ="删除" ></ asp:button ></ TD >
                     </ TR >
                     < TR >
                         < TD >< asp:datagrid  id ="DataGrid1"  runat ="server"  DataKeyField ="UserID"  AllowPaging ="True"  PageSize ="5"
                                AllowSorting ="True"  CellPadding ="3"  BackColor ="White"  BorderWidth ="1px"  BorderColor ="#CCCCCC"
                                AutoGenerateColumns ="False"  BorderStyle ="None"  Height ="168px" >
                                 < SelectedItemStyle  Font-Bold ="True"  ForeColor ="White"  BackColor ="#669999" ></ SelectedItemStyle >
                                 < ItemStyle  ForeColor ="#000066" ></ ItemStyle >
                                 < HeaderStyle  Font-Bold ="True"  ForeColor ="White"  BackColor ="#006699" ></ HeaderStyle >
                                 < FooterStyle  ForeColor ="#000066"  BackColor ="White" ></ FooterStyle >
                                 < Columns >
                                     < asp:TemplateColumn  HeaderText ="序号" >
                                         < HeaderStyle  Width ="35px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < INPUT  id ="radio"  type ="radio"  name ="radio" >
                                         </ ItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  HeaderText ="序号" >
                                         < HeaderStyle  Width ="35px" ></ HeaderStyle >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  HeaderText ="模板" >
                                         < HeaderStyle  Width ="35px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:CheckBox  id ="chkExport"  Width ="100%"  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 >
                                             < asp:Label  id =Label1  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.UserName") % > ' Width="100%">
                                             </ asp:Label >
                                         </ ItemTemplate >
                                         < EditItemTemplate >
                                             < asp:TextBox  id =UserName  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.UserName") % > ' Width="100%">
                                             </ asp:TextBox >
                                         </ EditItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  SortExpression ="province"  HeaderText ="省市" >
                                         < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:Label  id =Label2  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.province") % > ' Width="100%">
                                             </ asp:Label >
                                         </ ItemTemplate >
                                         < EditItemTemplate >
                                             < asp:DropDownList  id ="province"  runat ="server"  AutoPostBack ="True"  Width ="100%"  OnSelectedIndexChanged ="ddlprovince_SelectedIndexChanged" ></ asp:DropDownList >
                                         </ EditItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  SortExpression ="city"  HeaderText ="县市" >
                                         < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:Label  id =Label3  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.city") % > ' Width="100%">
                                             </ asp:Label >
                                         </ ItemTemplate >
                                         < EditItemTemplate >
                                             < asp:DropDownList  id ="city"  runat ="server"  AutoPostBack ="True"  Width ="100%"  OnSelectedIndexChanged ="ddlcity_SelectedIndexChanged" ></ asp:DropDownList >
                                         </ EditItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  SortExpression ="area"  HeaderText ="乡镇" >
                                         < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:Label  id =Label4  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.area") % > ' Width="100%">
                                             </ asp:Label >
                                         </ 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 >
                                             < asp:Label  id =Label5  runat ="server"  Text ='<%#  DataBinder.Eval(Container, "DataItem.Enabled") % > ' Width="100%">
                                             </ asp:Label >
                                         </ ItemTemplate >
                                         < EditItemTemplate >
                                             < asp:CheckBox  id =chkenabled  runat ="server"  Width ="100%"  Checked ='<%#  DataBinder.Eval(Container.DataItem,"Enabled") % > '>
                                             </ asp:CheckBox >
                                         </ EditItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:EditCommandColumn  ButtonType ="LinkButton"  UpdateText ="更新"  HeaderText ="编辑"  CancelText ="取消"  EditText ="编辑" >
                                         < HeaderStyle  Width ="70px" ></ HeaderStyle >
                                     </ asp:EditCommandColumn >
                                     < asp:TemplateColumn  HeaderText ="删除" >
                                         < HeaderStyle  Width ="35px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:Button  id ="btnDelete1"  runat ="server"  Text ="删除"  Width ="60px"  CommandName ="UserDelete" ></ asp:Button >
                                         </ ItemTemplate >
                                     </ asp:TemplateColumn >
                                     < asp:TemplateColumn  HeaderText ="详细信息" >
                                         < HeaderStyle  Width ="90px" ></ HeaderStyle >
                                         < ItemTemplate >
                                             < asp:HyperLink  id ="HyperLink1"  runat ="server"  Text =""  Width ="100%"  Target ="_blank"  NavigateUrl ="http://www.guwenlvshi.com/" > 详细信息 </ asp:HyperLink >
                                         </ ItemTemplate >
                                     </ asp:TemplateColumn >
                                 </ Columns >
                                 < PagerStyle  NextPageText ="下一页"  PrevPageText ="上一页"  HorizontalAlign ="Left"  ForeColor ="#000066"
                                    BackColor ="White" ></ PagerStyle >
                             </ asp:datagrid ></ TD >
                     </ TR >
                 </ TABLE >
             </ FONT >
         </ form >
     </ body >
</ HTML >
下面是WebForm1.aspx.cs文件                           
using  System;
 using  System.Collections;
 using  System.ComponentModel;
 using  System.Data;
 using  System.Drawing;
 using  System.Web;
 using  System.Web.SessionState;
 using  System.Web.UI;
 using  System.Web.UI.WebControls;
 using  System.Web.UI.HtmlControls;
 using  System.Data.SqlClient;
 using  System.Text;

 namespace  DatagridTest1
 {
    /// <summary>
    /// 
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Button Button2;
        protected System.Web.UI.WebControls.Button Button1;
        protected System.Web.UI.WebControls.CheckBox CheckBox1;
        protected System.Web.UI.WebControls.TextBox TextBox1;
        protected System.Web.UI.WebControls.DropDownList DropDownList3;
        protected System.Web.UI.WebControls.DropDownList DropDownList2;
        protected System.Web.UI.WebControls.DropDownList DropDownList1;
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.WebControls.Button btndelete;
        protected System.Web.UI.WebControls.CheckBox CheckBox2;
        private string constring="";  
    
        private void Page_Load(object sender, System.EventArgs e)
        {
            if(!Page.IsPostBack)
            {
                if(DataGrid1.Attributes["SortExpression"] == null)
                {
                    DataGrid1.Attributes["SortExpression"] = "UserID";
                    DataGrid1.Attributes["SortDirection"] = "ASC";
                }
                ListProvince();
                ListCity();
                ListArea();
                BindData();
            }
        }
        private void BindData()
        {
            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];
            string SortExpression = DataGrid1.Attributes["SortExpression"];
            string SortDirection = DataGrid1.Attributes["SortDirection"];
            dt.DefaultView.Sort = SortExpression + " " + SortDirection; 
//            dt.DefaultView.Sort="UserID asc";
            dt.AcceptChanges();
            this.DataGrid1.DataSource=dt;
            this.DataGrid1.DataBind();
        }
        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;
        }
        private DataTable dt
        {
            get
            {
                if(ViewState["dt"]!=null)
                {
                    return (DataTable)ViewState["dt"];
                }
                else
                {
                    return null;
                }
            }
            set
            {
                ViewState["dt"]=value;
            }
        }
        private void ListProvince()
        {
            string sql="select * from province";
            DataSet ds=GetDataSet(sql);
            DropDownList1.DataSource=ds;
            DropDownList1.DataTextField="province";
            DropDownList1.DataValueField="provinceID";
            DropDownList1.DataBind();
        }

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

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

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

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

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

        private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
//            this.DataGrid1.Columns[2].Visible=false;
//            e.Item.Cells[2].Visible=false;
            if(e.Item.ItemIndex!=-1)
            {
                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='#bbaa99'");
                }
                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++)
//                    {
//                       e.Item.Cells[i].Attributes.Add("Width", "70px");
//                    }
                    string sqlprovince="select * from province";
                    DataSet dsprovince=GetDataSet(sqlprovince);
                    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(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(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;
            }
        }

        private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
            this.BindData();

        }

        private void DataGrid1_CancelCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            this.DataGrid1.EditItemIndex=-1;
            this.BindData();

        }
        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();
                if(ddlcity.SelectedIndex!=-1)
                {
                    DropDownList ddlarea = ((Control)(((Control)sender)).Parent).FindControl("area") 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();
                }
            }
        }

        public void ddlcity_SelectedIndexChanged(object sender, EventArgs e)
        {
            DropDownList ddlcity = sender as DropDownList;
            if(ddlcity.SelectedIndex!=-1)
            {
                DropDownList ddlarea = ((Control)(((Control)sender)).Parent).FindControl("area") 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();
            }
        }

        private void DataGrid1_UpdateCommand(object source, System.Web.UI.WebControls.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;
                this.BindData();
            }
        }

        private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
        {
            switch(e.Item.ItemType)
            {
                case ListItemType.Item:
                case ListItemType.EditItem:
                case ListItemType.AlternatingItem:
                    Button     myDeleteButton = (Button)e.Item.FindControl("btnDelete1");
                    myDeleteButton.Text = "删除";
                    myDeleteButton.Attributes.Add("onclick", "return confirm('你确认删除此项吗？');");
                     break;
            }

        }

        private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            if(DataGrid1.Items.Count==1)
            {
                if(DataGrid1.CurrentPageIndex!=0)
                    DataGrid1.CurrentPageIndex = DataGrid1.CurrentPageIndex-1;
            }
            string strSql = "delete from testgrid where UserID='"+e.Item.Cells[3].Text+"'";
            try
            {
                string strconn = System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];//
                SqlConnection conn =new SqlConnection(strconn);
                SqlCommand com = new SqlCommand(strSql,conn);
                conn.Open();
                com.ExecuteNonQuery();
                conn.Close();
            } 
            catch(Exception e1)
            {
                Response.Write("<script language = 'javascript'> alert('"+e1.Message+"');</script>") ;
                            
            }
            BindData();
        }

        private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            if(e.CommandName=="UserDelete")
                DataGrid1_DeleteCommand(source,e);
        
        }

        private void DataGrid1_SortCommand(object source, System.Web.UI.WebControls.DataGridSortCommandEventArgs e)
        {
            string SortExpression = e.SortExpression.ToString();
            string SortDirection = "ASC";
            if(SortExpression == DataGrid1.Attributes["SortExpression"])
            {
                SortDirection = (DataGrid1.Attributes["SortDirection"].ToString() == SortDirection ? "DESC" : "ASC");
            }
            DataGrid1.Attributes["SortExpression"] = SortExpression;
            DataGrid1.Attributes["SortDirection"] = SortDirection;
            BindData();
        }

        private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
        {
            DataGrid1.CurrentPageIndex = e.NewPageIndex;
            this.BindData();
        }

        private void Button4_Click(object sender, System.EventArgs e)
        {
        
        }

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

        private void CheckBox2_CheckedChanged(object sender, System.EventArgs e)
        {
            for (int i = 0; i <= this.DataGrid1.Items.Count-1;i++)
            {
                CheckBox cbox = (CheckBox)this.DataGrid1.Items[i].FindControl("chkExport");
                if (CheckBox2.Checked == true)
                {
                    cbox.Checked = true;
                    this.CheckBox2.Text = "取消全选";
                }
                else
                {
                    cbox.Checked = false;
                    this.CheckBox2.Text = "全部选择";
                }
            }

        }

        private void Button2_Click(object sender, System.EventArgs e)
        {
//            HttpContext.Current.Response.Charset ="UTF-8";GB18030
//            HttpContext.Current.Response.Charset ="GB18030";
            Response.ContentEncoding=System.Text.Encoding.Default;
            Response.ContentType = "application/vnd.ms-excel";
            Response.AppendHeader("Content-Disposition","attachment;filename=1.xls");   
            this.EnableViewState = false;
            System.IO.StringWriter sw = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
            int nCur = DataGrid1.CurrentPageIndex;
            int nSize = DataGrid1.PageSize;            
            DataGrid1.AllowPaging = false;
            DataGrid1.AllowSorting=false;
            BindData();                
            DataGrid1.Columns[0].Visible =false;
            DataGrid1.Columns[1].Visible =false;
            DataGrid1.Columns[2].Visible =false;
            DataGrid1.Columns[9].Visible =false;
            DataGrid1.Columns[10].Visible =false;
            DataGrid1.RenderControl(hw);
            DataGrid1.Columns[0].Visible =true;
            DataGrid1.Columns[1].Visible =true;
            DataGrid1.Columns[2].Visible =true;
            DataGrid1.Columns[9].Visible =true;
            DataGrid1.Columns[10].Visible =true;
            DataGrid1.AllowSorting=true;
            DataGrid1.AllowPaging = true;
            DataGrid1.CurrentPageIndex = nCur;
            DataGrid1.PageSize = nSize;
            this.EnableViewState = true;
            BindData();
            Response.Write(sw.ToString());
            Response.End();
        }
    }
}
zhaoxiaoyang5156
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
DataGridView批量修改完整示例包含数据库sql
06-10
完整示例主要是涉及批量修改的参数设置等内容，有兴趣可以下载学习一下啊
easyUI——datagrid表格批量操作
YQAG
01-31 3263
对datagrid表格进行批量的操作，是每个系统都会遇到的，通过一下小实例总结一下。其实 原理很简单：获取选中的数据的主键，传值到后台，对数据进行操作。
android layout小例子-山寨QQ (转)
04-04
源码 博文链接：https://410063005.iteye.com/blog/1487121
易语言极品山寨影音系统源码.zip易语言项目例子源码下载
03-23
易语言极品山寨影音系统源码.zip易语言项目例子源码下载易语言极品山寨影音系统源码.zip易语言项目例子源码下载 1.合个人学习技术做项目参考 2.适合学生做毕业设计参考 3.适合小团队开发项目参考
山外多功能调试助手V1.1.4.rar
07-07
山外多功能串口调试助手，包含串口调试功能，智能车CMOS摄像头，线性CCD摄像头图像调试功能，虚拟示波器功能，GSM调试功能，GPS定位功能，网络调试助手等，甩sscom之类的串口调试软件几条街，非常的简洁好用
山外多功能调试助手（大分辨率版）.exe
02-07
作为调试智能车非常方便，可以实时查看电感采集数据，连接摄像头观察图像等均可，配合无线串口使用更加方便！
山外多功能调试助手资源包
11-02
调试更快捷，更方便
EasyUI 的 datagrid 批量数据插入、批量数据更新的性能问题解决方法
hwjmyz的博客
06-14 3119
转载请保留本地址，谢谢在我们的LIMS系统开发中，发现对 datagrid 中批量插入500行以上数据，或者用 updateRow 进行批量的更新时，性能特别慢（500条需要10秒左右）。用的版本是 EasyUI 1.5使用 autoRowHeight:false 、nowrap:true、fitColumns:false、每列设置宽度等方法，仍然解决不了问题。经过js的分析，发现是其每次会调用 ...
一个功能齐全的DataGrid分页例子
Teng_s2000的专栏
10-17 727
C#版本DataGridPaging.aspx AutoEventWireup="false" Inherits="eMeng.Exam.DataGridPaging.DataGridPaging" %>http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema"> HorizontalAlign="Center" Al
如何在DataGrid中进行添加、删除和修改操作
javabeanzhang的专栏
04-07 847
见于好多人在CSDN上问如何在DataGrid中进行添加、删除和修改操作，我最近作了如下一个例子。 首先，例子所用的数据库是SQL Server2000，数据库表格如下： 字段名 类型 备注 EmployeeID Int 自增字段 EmployeeName Varchar(20) Salary Int CellPhone Varchar(20) EmailAddress Varchar(20) 程
easyui-editing datagrid 批量保存数据 一
王勇霞 信息技术提高班九期
04-26 9766
这篇博客是分享给大家使用easyUI 框架从界面向后台传值的两种方法。使用easyui 已经有一段时间，没有很深入的学习过，只是停留在可以简单使用的层面上，这次由于项目需要，前台界面的需求比较多，所以对easyui的使用，在这段时间，从量上，使用的深度上有了一个大的跨越，特别是datagrid 。然后回顾以前使用的一些经验，整理了这篇博客。         先看效果图：我需要将表格中数据如红色框
(原创)方便的使用单击和双击更新DataGrid中的数据的例子
05-15 359
可能大家在使用DataGrid编辑数据的时候会觉得要点击最后的编辑列的按钮来修改数据不是很方便，在今天的例子中给出一种比较方便的操作方法：要修改数据点击这一行－》鼠标放在哪个文本框就会选中哪个文本框的内容，直接可以进行修改－》修改完毕以后双击这一行（也可以直接双击文本框）进行保存。这次使用sqlserver数据库中的northwind数据库中的Employees表作为例子。前台：
实现对easyui-datagrid的数据行批量修改（包括修改内容和删除）
Sano_pan的博客
09-06 3727
先上一个easyui-datagrid的数据。 而我们要实现的功能是1.对三条记录进行批量的删除和批量的修改状态。 1.批量的删除 我们选择传入三条记录的id值，并利用service层的deleteByid方法进行删除。 具体代码如下所示。 先上service层代码： public interface OaSuitService { public String deleteBy
【EasyUi DataGrid】批量修改提交
Cherie
07-31 7856
在实际操作中，批量修改的例子有很多，最常用的一种便是“假批量修改”，即修改一行后，当点击其它行时就把这行修改后的数据提交，拥有保存功能的“保存”按钮，说到底就是为我们修改的最后一行准备的（例如：Navicat对数据库表的操作），这样的用户体验度不错，因为感觉上像是点击了保存按钮才让它们都提交似的，同时也避免了因为刷新网页断网等等意外引起的数据丢失。这样的做法等同于把要修改的一行重新装载到一个弹出页
easyui-datagrid 编辑单元格
热门推荐
03-30 2万+
在做itoo成绩的时候，有个需求是教师判分，学生成绩有两部分组成：平时成绩和期末成绩，然后根据两种成绩比例算出总成绩。现在是有了平时成绩和成绩比例，输入期末成绩，计算出总成绩，并且把输入的期末成绩和计算的总成绩更新到数据库中。主要应用了单击单元格进行编辑，编辑完成之后，失去焦点则保存数据。如果数据没有变化，失去焦点则不更新数据库。          页面效果是这样的： 期末成绩的单元格
方便的使用单击和双击更新DataGrid中的数据的例子
嗨！您好！Welcome my blog
10-17 571
 可能大家在使用DataGrid编辑数据的时候会觉得要点击最后的编辑列的按钮来修改数据不是很方便，在今天的例子中给出一种比较方便的操作方法：要修改数据点击这一行－》鼠标放在哪个文本框就会选中哪个文本框的内容，直接可以进行修改－》修改完毕以后双击这一行（也可以直接双击文本框）进行保存。这次使用sqlserver数据库中的northwind数据库中的Employees表作为例子。前台：@ Page l
屎山代码例子python
最新发布
11-09
很抱歉，根据提供的引用内容，没有提到屎山代码例子Python。但是，屎山代码是一种普遍存在于各种编程语言中的现象，包括Python。下面是一个Python的屎山代码例子： ```python if a == 1: print("a is 1") else: ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值