查询数据库 生成insert语句

查询数据库 生成insert语句

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;

namespace CreateInsertSql
{
    public partial class FormHelp : Form
    {
        public FormHelp（）
        {
            InitializeComponent（）;
            this.Load += new EventHandler（FormHelp_Load）;
        }

        void FormHelp_Load（object sender EventArgs e）
        {
            this.richTextBox1.Text = @“
    数据库连接字符串写在App.Config文件里。

    由于时间关系，目前的程序仅对SQLite数据库起作用，如果
要使用其它数据库，请对源代码（www.cnblogs.com\zzy0471）进
行修改，这可能只需要3分钟时间：

    步骤0：新建一个类继承于AbsADODotNet并实现
    步骤1：新建一个类继承于AbsADODotNetFactory并实现
    步骤2：修改App.Config文件中Key值为“ADODotNetFactor

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2011-01-27 18:26  CreateInsertSql\
     目录           0  2011-01-27 17:26  CreateInsertSql\CreateInsertSql\
     文件        2590  2011-01-27 16:56  CreateInsertSql\CreateInsertSql.sln
     文件       43520  2011-01-27 18:34  CreateInsertSql\CreateInsertSql.suo
     文件         474  2011-01-27 17:01  CreateInsertSql\CreateInsertSql\App.config
     目录           0  2011-01-27 15:59  CreateInsertSql\CreateInsertSql\bin\
     目录           0  2011-01-27 22:13  CreateInsertSql\CreateInsertSql\bin\Debug\
     文件       11600  2011-01-27 22:11  CreateInsertSql\CreateInsertSql\bin\Debug\CreateInsertSql.vshost.exe
     文件         474  2011-01-27 17:01  CreateInsertSql\CreateInsertSql\bin\Debug\CreateInsertSql.vshost.exe.config
     文件         490  2010-03-17 22:39  CreateInsertSql\CreateInsertSql\bin\Debug\CreateInsertSql.vshost.exe.manifest
     目录           0  2011-01-27 18:28  CreateInsertSql\CreateInsertSql\bin\Debug\TestDb\
     目录           0  2011-01-27 15:59  CreateInsertSql\CreateInsertSql\bin\Release\
     目录           0  2011-01-27 16:07  CreateInsertSql\CreateInsertSql\Business\
     文件        2004  2011-01-27 17:56  CreateInsertSql\CreateInsertSql\Business\CreatingInsertSql.cs
     文件        5271  2011-01-27 17:32  CreateInsertSql\CreateInsertSql\CreateInsertSql.csproj
     文件        1613  2011-01-27 18:15  CreateInsertSql\CreateInsertSql\FormHelp.cs
     文件        2455  2011-01-27 18:15  CreateInsertSql\CreateInsertSql\FormHelp.Designer.cs
     文件        5817  2011-01-27 18:15  CreateInsertSql\CreateInsertSql\FormHelp.resx
     文件        1711  2011-01-27 18:33  CreateInsertSql\CreateInsertSql\FormMain.cs
     文件        5523  2011-01-27 18:33  CreateInsertSql\CreateInsertSql\FormMain.Designer.cs
     文件        6015  2011-01-27 18:33  CreateInsertSql\CreateInsertSql\FormMain.resx
     文件         788  2011-01-27 18:03  CreateInsertSql\CreateInsertSql\FormShowSql.cs
     文件        3727  2011-01-27 18:03  CreateInsertSql\CreateInsertSql\FormShowSql.Designer.cs
     文件        5817  2011-01-27 18:03  CreateInsertSql\CreateInsertSql\FormShowSql.resx
     目录           0  2011-01-27 15:52  CreateInsertSql\CreateInsertSql\obj\
     目录           0  2011-01-27 15:52  CreateInsertSql\CreateInsertSql\obj\x86\
     目录           0  2011-01-27 22:13  CreateInsertSql\CreateInsertSql\obj\x86\Debug\
     文件        4440  2011-01-27 22:08  CreateInsertSql\CreateInsertSql\obj\x86\Debug\DesignTimeResolveAssemblyReferences.cache
     文件        6697  2011-01-27 18:33  CreateInsertSql\CreateInsertSql\obj\x86\Debug\DesignTimeResolveAssemblyReferencesInput.cache
     目录           0  2011-01-27 17:21  CreateInsertSql\CreateInsertSql\obj\x86\Debug\TempPE\
     文件        4608  2011-01-27 17:21  CreateInsertSql\CreateInsertSql\obj\x86\Debug\TempPE\Properties.Resources.Designer.cs.dll
............此处省略31个文件信息