选择部分记录输出到Excel

ToExcel.aspx

< asp:datagrid id = " DataGrid1 "  runat = " server "  Width = " 595px "  AutoGenerateColumns = " False "  PageSize = " 30 "                                 AllowPaging = " True "  BorderWidth = " 1px "  BorderColor = " SeaGreen "  Font - Size = " 12px " >                                  < ItemStyle HorizontalAlign = " Left " ></ ItemStyle >                                  < HeaderStyle HorizontalAlign = " Center " ></ HeaderStyle >                                  < Columns >                                      < asp:TemplateColumn >                                          < HeaderStyle Width = " 40px " ></ HeaderStyle >                                          < ItemStyle HorizontalAlign = " Center " ></ ItemStyle >                                          < ItemTemplate >                                              < asp:CheckBox id = " myselect "  Runat = " server " ></ asp:CheckBox >                                          </ ItemTemplate >                                          < EditItemTemplate >                                              < asp:TextBox id = TextBox1 runat = " server "  Text = ' <%# DataBinder.Eval(Container, "DataItem.id") %> ' >                                              </ asp:TextBox >                                          </ EditItemTemplate >                                      </ asp:TemplateColumn >                                      < asp:ButtonColumn DataTextField = " 公司名称 "  HeaderText = " 公司名称 "  CommandName = " Select " ></ asp:ButtonColumn >                                      < asp:BoundColumn Visible = " False "  DataField = " id " ></ asp:BoundColumn >                                  </ Columns >                                  < PagerStyle HorizontalAlign = " Right "  Position = " Top "  Mode = " NumericPages " ></ PagerStyle >                              </ asp:datagrid >

Toexcel.aspx.cs

a.数据绑定

void  Bind()         ... {            string CS=this.Application.Get("kehuConnectionString").ToString();                        string myQuery="";                                        myQuery= "SELECT  * from [data] where (id<>null)  ";                    if(Label1.Text.Trim()!="")                 myQuery+=Label1.Text.Trim();                            OleDbConnection myConnection = new OleDbConnection(CS);            myConnection.Open();                        OleDbDataAdapter objDataAdapter=new OleDbDataAdapter(myQuery,myConnection);                    DataSet ds = new DataSet();            objDataAdapter.Fill(ds,"data");            /**////            DataTable dt=ds.Tables["data"];                             /**///            this.DataGrid1.DataSource=dt.DefaultView;            DataGrid1.DataBind();            if(Session["userlist"]!=null)            ...{                Hashtable ht =(Hashtable)Session["userlist"];                if(ht!=null)                ...{                    for(int i = 0 ;i<DataGrid1.Items.Count ;i++)                    ...{                        if (ht.ContainsKey(DataGrid1.Items[i].Cells[2].Text.ToString().Trim()))                            (DataGrid1.Items[i].Cells[0].FindControl("myselect") as CheckBox).Checked = true;                    }                }            }            ds.Clear();            if(myConnection!=null)myConnection.Close();        }

b.选择

private   void  check()         ... {            Hashtable ht = new Hashtable();            if(Session["userlist"]!=null)            ...{                ht =(Hashtable) Session["userlist"];                if(ht!=null)                ...{                    for(int i = 0 ;i<DataGrid1.Items.Count ;i++)                    ...{                        if ( (DataGrid1.Items[i].Cells[0].FindControl("myselect") as CheckBox).Checked)                        ...{                            if (! ht.ContainsKey(DataGrid1.Items[i].Cells[2].Text.ToString().Trim()))                            ...{                                ht.Add(DataGrid1.Items[i].Cells[2].Text.ToString().Trim(),DataGrid1.Items[i].Cells[2].Text.ToString().Trim());                            }                        }                        else                        ...{                            if ( ht.ContainsKey(DataGrid1.Items[i].Cells[2].Text.ToString().Trim()))                            ...{                                ht.Remove(DataGrid1.Items[i].Cells[2].Text.ToString().Trim());                            }                        }                    }                }            }            else            ...{                for(int i = 0 ;i<DataGrid1.Items.Count ;i++)                ...{                    if ( (DataGrid1.Items[i].Cells[0].FindControl("myselect") as CheckBox).Checked)                    ...{                        ht.Add(DataGrid1.Items[i].Cells[2].Text.ToString().Trim(),DataGrid1.Items[i].Cells[2].Text.ToString().Trim());                    }                }            }            Session["userlist"] = ht;        }

c.输出到excel

private   void  LinkButton2_Click( object  sender, System.EventArgs e)         ... {            /**//*            Hashtable ht = new Hashtable();            if(Session["userlist"]!=null)            {                ht =(Hashtable) Session["userlist"];                if(ht!=null)                {                    ht.Clear();                }            }            */            check();            Hashtable ht =(Hashtable) Session["userlist"];            /**////            StringWriter sw=new StringWriter();             string myhead="";                                myhead="联系人 买卖家 部门 职务 公司名称 公司中文名 地址 国别 电话 手机 传真 电子邮件 网址 主营商品类 主营商品 收集日期 收集来源 ";                     sw.WriteLine(myhead);             string mycol="";//int myint=0;            /**////            string CS=Application.Get("kehuConnectionString").ToString();            string myQuery="";            OleDbConnection myConnection = new OleDbConnection(CS);            myConnection.Open();            foreach (DictionaryEntry objDE in ht)            ...{                string myid=objDE.Value.ToString();                      myQuery= "SELECT  联系人,买卖家,部门,职务,公司名称,公司中文名,地址,国别,电话,手机,传真,电子邮件,企业网址,主营商品类,主营商品,收集日期,收集来源 from [data] where id="+myid;                OleDbCommand myCommand= new OleDbCommand(myQuery,myConnection);                OleDbDataReader objDataReader=myCommand.ExecuteReader();                            mycol="";                if(objDataReader.Read())                ...{                                    for(int j=0;j<17;j++)                        if(!objDataReader.IsDBNull(j))                        ...{                            if(j==15)                                mycol+=objDataReader.GetDateTime(j).ToShortDateString().Trim() + " ";                             else                                mycol+=objDataReader.GetString(j).Trim() + " ";                         }                        else...{                                                    mycol+= " ";                         }                                                sw.WriteLine(mycol);                     }                    objDataReader.Close();                        }                if(myConnection!=null)myConnection.Close();            Response.AddHeader("Content-Disposition", "attachment; filename=RESULT.XLS");             Response.ContentType = "application/ms-excel";             Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");             Response.Write(sw);             Response.End();             sw.Close();        }             }}