将所有数据从sqlserver导出到excel [英] export all data from sqlserver to excel

问题描述

嗨...我的表包含10列...但是我只用4列绑定了网格视图...现在我需要在Gridview中单击导入链接按钮时将数据从sqlserver导出到excel工作表...可以有人帮我吗?

hi...i have table contains 10 columns...but i bound with grid view with only 4 columns...now i need to export data from sqlserver to excel sheet when clicking import linkbutton in gridview...can anybody help me???

推荐答案

在Button Click Event上尝试此代码将起作用

Hi,

on Button Click Event try this code it will work

sql = "SELECT EmpCode as [Code], FullName as [Employee], Designation where emp_id="+ EMP_ID +"";
    dt = new DataTable();
    dt = cCommon.FillDataTable(sql);
if (dt.Rows.Count > 0)
{
    Response.Clear();
    Response.ContentType = "application/vnd.ms-excel";
    string sep = "";
    foreach (DataColumn dc in dt.Columns)
    {
        Response.Write(sep + dc.ColumnName);
        sep = "\t";
    }
    Response.Write("\n");
    int i;
    foreach (DataRow dr in dt.Rows)
    {
        sep = "";
        for (i = 0; i < dt.Columns.Count; i++)
        {
            if (i == 3)
            {
                string date = cDateFunction.ConvertToDate(Convert.ToInt32(dr[i].ToString()).ToString()).ToString();
                Response.Write(sep + date);
            }
            else
            {
                Response.Write(sep + dr[i].ToString());
            }
            sep = "\t";
        }
        Response.Write("\n");
    }

这篇关于将所有数据从sqlserver导出到excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！