資源簡介
根據(jù)DataTable 生成Excel文件。用本例中的導(dǎo)出方法:會輸出標(biāo)準(zhǔn)的Excel格式文件,非常穩(wěn)定,不會死鎖Excel進(jìn)程,支持中文文件名,支持表頭導(dǎo)出,支持大多數(shù)數(shù)據(jù)庫導(dǎo)入。
代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data;
using?System.Data.SqlClient;
namespace?car_sql
{
????public?class?DBHelp
????{
????????///?
????????///?連接字符串
????????///?
????????private?const?string?connectionString?=?@“server=192.168.0.2;database=LanMsg;uid=sa;pwd=dssd“;
????????///?
????????///?連接數(shù)據(jù)庫
????????///?
????????///?SQL語句或者存儲過程名
????????///?傳遞值
????????///?判斷傳遞的是字符串語句還是存儲過程
????????///?
????????public?static?SqlCommand?createCommand(string?order?SqlParameter[]?para?CommandType?type)
????????{
????????????SqlCommand?command?=?new?SqlCommand(order);
????????????command.Parameters.A
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2010-05-27?16:07??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\
?????目錄???????????0??2010-05-22?23:32??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\
?????目錄???????????0??2009-10-23?17:31??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\App_Data\
?????目錄???????????0??2009-10-23?17:31??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Bin\
?????文件????????4608??2003-08-03?10:52??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Bin\Interop.LCC11.dll
?????文件????????1468??2009-10-01?16:51??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\CodePub.Com說明.txt
?????文件????????3058??2009-10-23?17:30??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\DBHelp.cs
?????文件????????2376??2009-10-16?10:09??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Default2.aspx
?????文件????????6576??2009-10-16?12:55??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Default2.aspx.cs
?????文件?????????509??2009-10-16?10:43??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Excel.aspx
?????文件?????????653??2009-10-16?12:55??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\Excel.aspx.cs
?????文件????????8345??2009-10-16?09:14??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\DotnetToExcel\web.config
?????文件??????799232??2010-05-22?23:40??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\Excel.doc
?????目錄???????????0??2006-07-11?19:58??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\
?????文件????????1078??2006-07-11?19:58??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\App.ico
?????文件????????1859??2006-07-11?19:58??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\AssemblyInfo.cs
?????目錄???????????0??2006-07-11?19:58??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\
?????目錄???????????0??2006-07-11?19:58??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\
?????文件???????24576??2006-07-22?12:19??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\1-2006年廣西公務(wù)員工資制度改革信息采集表(一).xls
?????文件???????40960??2007-11-05?16:25??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Auxiliary.dll
?????文件???????75264??2007-11-05?16:25??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Auxiliary.pdb
?????文件????????8931??2007-11-05?16:25??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Auxiliary.xm
?????文件???????69632??2005-09-08?11:09??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\breezecontrol.dll
?????文件???????26624??2006-08-03?14:38??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Code.xls
?????文件???????49152??2007-11-14?15:35??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Databa
?????文件??????163328??2007-11-14?15:35??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Databa
?????文件???????27709??2007-11-14?15:35??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Databa
?????文件???????65536??2007-06-13?15:46??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\DbGridEh.dll
?????文件??????151040??2007-06-13?15:46??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\DbGridEh.pdb
?????文件???????41318??2007-06-13?15:46??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\DbGridEh.xm
?????文件?????????739??2006-07-13?16:22??Excel?NET對EXCEL的操作(導(dǎo)入導(dǎo)出數(shù)據(jù))\ReadExcel\bin\Debug\Dbl
............此處省略47個文件信息
評論
共有 條評論