asp.net把数据库记录导入成excel文件

时间：2010-09-01 来源：蔚蓝的大海

asp教程.net把数据库教程记录导入成excel文件
这是一个简单的导入excel文件代码，利用exprot.aspx导出指定数据库中的记录成xls文件哦。

protected void button2_click(object sender, eventargs e)
{
response.redirect("export.aspx?search=" + txtsearch.text);
}
%>

export.aspx
获取一个datatable,
在前台的div里直循环datatable:
<div runat="server" id="exceldiv">
<table>
</div>

后台:
<%
if (!ispostback)
{
export("报表");
}

private void export(string filename)
{
response.clear();
response.addheader("content-disposition", "attachment;filename=" + filename + ".xls");
response.charset = "gb2312";
response.contenttype = "application/vnd.xls";
response.contentencoding = system.text.encoding.getencoding("gb2312");
system.io.stringwriter stringwrite = new system.io.stringwriter();
system.web.ui.htmltextwriter htmlwrite = new htmltextwriter(stringwrite);
exceldiv.rendercontrol(htmlwrite);
response.write(stringwrite.tostring());
response.end();
}

Samsung 14P Female SMT USB connector cellphone connector mobile connectorHDMI 19P/F SMT single ear HDMI high definition data plug HDMI connector3.5 mm mono plug to 2*RCA adapter connector stable performance long lifespanStylish Leather 1Gb USB 2.0 Flash Storage DriveUSB LAN Network SERVER Print PRINTER NAS STORAGE BT NEWSee-through USB Bluetooth Wireless PC Adapter DongleNew 90W chager adapter with 8 renewable DC plugs HP series 124*56*37 mmMicro 5P B/F SMT connector cellphone connector LG mobile phone connectorMini 4P B/F SMT USB connector mini usb plug adapter cellphone connectorUSB3.0B Female short body RoHS compliant connector OEM adapter connector8*BNC Female to 25 pin Male HD VGA Video Audio Monitor CableCool Cylindrical Wooden 1Gb USB 2.0 Flash Memory DriveUSB A Male to Mini USB 5 Pin Male Cable whiteOctopus Paul usb flash drive disk well-known for 2010 world cup fashion designUSB series three-in-one short long type connector with long life time OEMUSB A/F 90° DIP buckle outside connector RoHS compliant OEM adapter connectorHDMI19M TO HDMI19M-03 cableUSB 2.0 + Firewire 1394 2.5" IDE Hard Drive EnclosureHD TV Multi-Media Player RMVB AVI 720P SD Card USB HOST8-in-1 Portable Computer USB Kit Bag with Digital keyboard and Multi function adapter16*BNC F to 25 pin M HD VGA Video Audio Monitor CableNOKIA adapter charging head connector with long life time OEM AC-12C2*RCA F + BNC F + 4 pin MD F + 3.5 DC F to 15 pin Male HD VGA Video Audio Monitor CableNew 90W charger with 8 renewable DC plugs ZM-60 series 124*56*41 mmDVI24+5 Female (PCB) 180° connector pin OEM adapter connectorUSB A/M 180° SMT connector RoHS compliant OEM adapter connectorDisplay port Male to HDMI 19F cableBar Shaped 10 Ports USB 2.0 Hub for PC LaptopMini 14P Male wire solder USB connector cellphone connector mini usb port type usb cable connectorUSB A Male to 2 USB A Male Adapter CableCrystal blue fish USB Flash DriveHDMI 19P/F SMT Dual ear HDMI high definition data plug HDMI connector4 pin M to M MD CableUSB to Mini 5pin CableDVI 24+1 Female DIP straight DVI plug DVI connector pin DVI connectorSamsung 14P Male wire solder USB connector cellphone connector mobile connectorUSB A sinking SMT&DIP 180° RoHS compliant connector OEM adapter connector3.5" Hard Drive Disk USB 3.0 HDD Enclosure Case 5GbpsHDMI 19P/F 90° DIP three-row pin HDMI high definition data plug HDMI connectorMini 5P AB/F SMT USB connector cellphone connector mini usb adapter mini usb portUSB A/F 90° DIP short body connector (right angle L=14.1mm) RoHS compliant OEM adapter connectorUSB 54M with antenna wireless lan card packet filtering wireless roaming DSSSLeather Button 2Gb USB 2.0 Flash Storage DriveWired USB Bluetooth wireless pc Wireless PC Adapter DongleRCA head adapter with long life time connector OEMSATA HDD Docking Station External Hard Drive DockingCool Ratatable 512Mb USB 2.0 Flash Storage DriveSurfboard USB Flash DriveUSB 54M wireless lan card packet filtering wireless roaming DSSSDC charging head adapter connector with long life time OEM

Replica lv Hangbags

Replica Hangbags

Hangbags

replica handbags

usb cable

usb flash drives

usb flash drives usb flash drives usb flash drives usb flash drives usb flash drives usb flash drives