将所有数据从sqlserver导出到excel

本文介绍了将所有数据从sqlserver导出到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"); }