数据库导入和筛选工具

数据库导入和筛选工具

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Text.Regularexpressions;
using System.Configuration;
using System.ServiceModel;
using System.ServiceModel.Configuration;

namespace ImportExcel
{

    public class ConfigHelper
    {
        //依据连接串名字connectionName返回数据连接字符串  
        public static string GetConnectionStringsConfig（string connectionName）
        {
            //指定config文件读取
            string file = System.Windows.Forms.Application.ExecutablePath;
            System.Configuration.Configuration config = ConfigurationManager.OpenExeConfiguration（file）;
            string connectionString =
                config.ConnectionStrings.ConnectionStrings[connectionName].ConnectionString.ToString（）;
            ret

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件      29696  2017-03-16 15:08  ImportExcel\ImportExcel\bin\Debug\ImportExcel.exe

     文件        405  2017-03-17 10:15  ImportExcel\ImportExcel\bin\Debug\ImportExcel.EXE.config

     文件      56832  2017-03-16 15:08  ImportExcel\ImportExcel\bin\Debug\ImportExcel.pdb

     文件      11600  2017-03-17 10:14  ImportExcel\ImportExcel\bin\Debug\ImportExcel.vshost.exe

     文件        490  2010-03-17 22:39  ImportExcel\ImportExcel\bin\Debug\ImportExcel.vshost.exe.manifest

     文件      28672  2017-01-05 14:33  ImportExcel\ImportExcel\bin\Release\ImportExcel.exe

     文件        405  2017-03-17 10:15  ImportExcel\ImportExcel\bin\Release\ImportExcel.exe.config

     文件      44544  2017-01-05 14:33  ImportExcel\ImportExcel\bin\Release\ImportExcel.pdb

     文件      11600  2017-01-05 14:39  ImportExcel\ImportExcel\bin\Release\ImportExcel.vshost.exe

     文件        490  2010-03-17 22:39  ImportExcel\ImportExcel\bin\Release\ImportExcel.vshost.exe.manifest

     文件       7553  2016-12-05 13:47  ImportExcel\ImportExcel\ConfigHelper.cs

     文件       6358  2016-12-05 16:10  ImportExcel\ImportExcel\DBHelper.cs

     文件      19402  2017-03-16 15:08  ImportExcel\ImportExcel\Form1.cs

     文件      11634  2016-12-05 19:05  ImportExcel\ImportExcel\Form1.Designer.cs

     文件       5817  2016-12-05 19:05  ImportExcel\ImportExcel\Form1.resx

     文件       3930  2016-12-05 14:52  ImportExcel\ImportExcel\ImportExcel.csproj

     文件       5420  2017-01-06 09:32  ImportExcel\ImportExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache

     文件       6581  2017-03-17 10:14  ImportExcel\ImportExcel\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache

     文件       1390  2017-03-17 10:14  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.csproj.FileListAbsolute.txt

     文件        975  2017-01-05 14:39  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.csproj.GenerateResource.Cache

     文件      10564  2017-01-06 09:33  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.csprojResolveAssemblyReference.cache

     文件      29696  2017-03-16 15:08  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.exe

     文件        180  2016-12-05 19:05  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.Form1.resources

     文件      56832  2017-03-16 15:08  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.pdb

     文件        180  2016-12-05 15:59  ImportExcel\ImportExcel\obj\x86\Debug\ImportExcel.Properties.Resources.resources

     文件       5420  2017-01-05 14:33  ImportExcel\ImportExcel\obj\x86\Release\DesignTimeResolveAssemblyReferences.cache

     文件       6552  2017-01-05 14:33  ImportExcel\ImportExcel\obj\x86\Release\DesignTimeResolveAssemblyReferencesInput.cache

     文件        634  2017-01-05 14:39  ImportExcel\ImportExcel\obj\x86\Release\ImportExcel.csproj.FileListAbsolute.txt

     文件        975  2017-01-05 14:33  ImportExcel\ImportExcel\obj\x86\Release\ImportExcel.csproj.GenerateResource.Cache

     文件      10564  2017-01-05 14:33  ImportExcel\ImportExcel\obj\x86\Release\ImportExcel.csprojResolveAssemblyReference.cache

............此处省略29个文件信息