页面的dable数据导出或按钮导出更多

  $(document).ready(function () {
            $("#btnExport").bind("click", function () {
                $("#dataTable").tableExport({
                    type: 'excel',
                    escape: 'false',
                    filename: '(2016-02-29_2016-03-06)'
                });
            });
        })








            <input id="btnExport" name="" value="导 出" type="button" class="btn btn-primary btn2" />
                       




    <script src="../Scripts/jquery.base64.js"></script>

    <script src="../Scripts/tableExport.js"></script>



  string filename= HttpUtility.UrlEncode(accounts,System.Text.Encoding.UTF8) +HttpUtility.UrlEncode( "name",System.Text.Encoding.UTF8);
                    HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
                    HttpContext.Current.Response.Charset = "UTF-8";
                    HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
                    HttpContext.Current.Response.ContentType = "application/ms-excel";

                    System.IO.StringWriter tw = new System.IO.StringWriter();
                    System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
                    tw.Write("用户名\t列明     ");
                    if (!string.IsNullOrEmpty(playerid))
                    {

                        string sql = "select * from RecordUserLeave where userid=" + playerid + " order by  LeaveTime desc";
                        DataTable dtex = new DataTable();
                        SqlHelper.FillDataTable(6, sql, dtex); tw.Write("\n");
                        for (int i = 0; i < dtex.Rows.Count; i++)
                        {

                            tw.Write(accounts + "\t" + dtex.Rows[i]["Score"].ToString() + "\t" + dtex.Rows[i]["Revenue"].ToString() + "\t" + getGameNameByID(dtex.Rows[i]["kindid"].ToString()) + "\t" + dtex.Rows[i]["ServerID"].ToString() + "\t" + dtex.Rows[i]["PlayTimeCount"].ToString() + "\t" + dtex.Rows[i]["OnLineTimeCount"].ToString() + "\t" + dtex.Rows[i]["LeaveTime"].ToString() + "\t");
                            tw.Write("\n");
                        }
                    }

                    HttpContext.Current.Response.Write(tw.ToString());
                    HttpContext.Current.Response.End();


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值