# using System;

# using System.Text;

# using System.Data;

# using Finisar.sqlite;

#

# namespace sqliteConvert

# {

# /// <summary>

# /// Class1 的摘要说明。

# /// </summary>

# class Class1

# {

# /// <summary>

# /// 应用程序的主入口点。

# /// </summary>

# [STAThread]

# static void Main( string[] args)

# {

# //

# // TODO: 在此处添加代码以启动应用程序

# //

#

#

# //打开以前的库

# sqliteConnection sqliteConn = new sqliteConnection( @"Data Source=d:projectDrEye.db;New=False;Compress=True;Version=3;");

# sqliteConn.Open();

# sqliteDataAdapter sqliteDa = new sqliteDataAdapter( "select * from DrEye",sqliteConn);

# DataSet sqliteDs = new DataSet();

# sqliteDa.Fill(sqliteDs);

#

#

# //创建新库

# sqliteConnection sqliteConnNew = new sqliteConnection( @"Data Source=d:projectDrEye.new1.db;New=True;Compress=True;Version=3");

# sqliteConnNew.Open();

#

# //建表

# sqliteCommand sqliteCmdNew = sqliteConnNew.CreateCommand();

# sqliteCmdNew.CommandText = "CREATE table DrEye (word TEXT Primary Key,explanation BLOB,InflectedForm BLOB)";

# sqliteCmdNew.ExecuteNonQuery();

#

# //插入数据

# sqliteDataAdapter sqliteDaNew = new sqliteDataAdapter( "select * from DrEye",sqliteConnNew);

# sqliteCommandBuilder sqliteCbNew = new sqliteCommandBuilder(sqliteDaNew);

#

# DataSet sqliteDsNew = new DataSet();

# sqliteDaNew.Fill(sqliteDsNew);

#

# Console.WriteLine(sqliteDs.Tables[0].Rows.Count);

# Console.WriteLine(sqliteDsNew.Tables[0].Rows.Count);

#

# foreach(DataRow dr in sqliteDs.Tables[0].Rows)

# {

#

#

# DataRow sqliteDrNew = sqliteDsNew.Tables[0].NewRow();

# sqliteDrNew[0] = dr[0];

# sqliteDrNew[1] = EncodingConvert(dr[1].ToString());

# if (dr[2].ToString() != "")

# {

# sqliteDrNew[2] = EncodingConvert(dr[2].ToString());

# }

# sqliteDsNew.Tables[0].Rows.Add(sqliteDrNew);

# break;

# }

# sqliteDaNew.Update(sqliteDsNew);

#

#

# Console.WriteLine( "Game over!");

# Console.ReadLine();

# }

#

# //将字符串转换成字节

# static byte[] EncodingConvert( string utf8String)

# {

#

# byte[] ansiCode;

# ansiCode = Encoding.Default.GetBytes(utf8String);

# return ansiCode;

# }

# }

# }