从数据库导出数据到word、excel、.txt 收藏 using System; using System.Data; using System.Drawing; using System.Data.SqlClient; using Excel; using Word; using System.IO; namespace Common { ///
/// 把数据导入到.doc、.txt、.xls 文件中 /// public class Export { private const string DATAWORDPATH = @"C:\folder\doc\datadoc\"; private const string IMAGEWORDPATH = @"C:\folder\doc\imagedoc\"; private const string IMAGEPATH = @"C:\folder\image\"; private const string EXCELPATH = @"C:\folder\excel\"; private const string TXTPATH = @"C:\folder\txt\"; private const string IMAGEPOSTFIX = ".bmp"; private const string WORDPOSTFIX = ".doc"; private const string EXCELPOSTFIX = ".xls"; private const string TXTPOSTFIX = ".txt"; private const int DATADISTANCE = 5; private const int TABDISTANCE = 8; public Export() { // // TODO: 在此处添加构造函数逻辑 // } ///
/// 获得数据集 Dataset--------------------------------用于调试 /// ///
Dataset public DataSet GetData() { try { string sConnectionString; sConnectionString = "workstation id=GUOFU; packet size=4096;user id=sa; data source=GUOFU; persist security info=True; I initial catalog=YC;password=sc"; SqlConnection objConn = new SqlConnection(sConnectionString); objConn.Open(); SqlDataAdapter daPoint = new SqlDataAdapter("Select * From Point", objConn); DataSet dsYC = new DataSet("YC"); daPoint.FillSchema(dsYC,SchemaType.Mapped, "Point"); daPoint.Fill(dsYC,"Point"); daPoint = new SqlDataAdapter("Select * From Employee", objConn); daPoint.FillSchema(dsYC,SchemaType.Mapped, "Employee"); daPoint.Fill(dsYC,"Employee"); return dsYC; } catch(Exception ex) { throw new Exception(ex.Message); } } ///
/// 把数据文件导入到.xls 文件 /// ///
public void Expor...
