SQL server迁移sqlite3经文

最新推荐文章于 2024-08-05 17:34:36 发布

甲骨文数据库

最新推荐文章于 2024-08-05 17:34:36 发布

阅读量127

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/www_oracle_com/article/details/134222756

版权

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Data.SQLite;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            //using (SQLiteConnection conn = new SQLiteConnection("Data Source=hb.sqlite3"))
            //{
            //    using (SQLiteCommand cmd = new SQLiteCommand("create table t_hb (juanming text not null default '', zhang integer not null default 0, jie integer not null default 0, jingwen text not null default '');", conn))
            //    {
                   
            //        conn.Open();
            //        cmd.ExecuteNonQuery();
            //    }
            //}
            using (SqlConnection conn2 = new SqlConnection("server=.;database=hb;user id=sa;password=a"))
            {
                using (SqlCommand cmd2 = new SqlCommand("select juanming, zhang, jie, jingwen from t_hb", conn2))
                {
                    //cmd2.Parameters.AddWithValue("juanming", odr["fullname"]);
                    //cmd2.Parameters.AddWithValue("suoxie", odr["shortname"]);
                    //cmd2.Parameters.AddWithValue("pinyin", odr["py"]);
                    //cmd2.Parameters.AddWithValue("zhang", odr["chaptersn"]);
                    //cmd2.Parameters.AddWithValue("jie", odr["versesn"]);
                    //cmd2.Parameters.AddWithValue("jingwen", odr["strjw"]);
                    conn2.Open();
                    using (SqlDataReader sdr = cmd2.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            using (SQLiteConnection conn = new SQLiteConnection("Data Source=hb.sqlite3"))
                            {
                                using (SQLiteCommand cmd = new SQLiteCommand("insert into t_hb values (@juanming, @zhang, @jie, @jingwen)", conn))
                                {
                                    cmd.Parameters.AddWithValue("juanming", sdr["juanming"]);
                                    cmd.Parameters.AddWithValue("zhang", sdr["zhang"]);
                                    cmd.Parameters.AddWithValue("jie", sdr["jie"]);
                                    cmd.Parameters.AddWithValue("jingwen", sdr["jingwen"]);
                                    conn.Open();
                                    cmd.ExecuteNonQuery();
                                }
                            }
                        }
                    }

                }
            }
            //using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=bibleNosound.mdb;"))
            //{
            //    using (OleDbCommand cmd = new OleDbCommand("SELECT fullname, shortname, py, chaptersn, versesn, strjw from bibleid,bible where bibleid.sn = bible.Volumesn", conn))
            //    {
            //        conn.Open();
            //        using (OleDbDataReader odr = cmd.ExecuteReader())
            //        {
            //            while (odr.Read())
            //            {
            //                using (SqlConnection conn2 = new SqlConnection("server=.;database=hb;user id=sa;password=Abcdefg1"))
            //                {
            //                    using (SqlCommand cmd2 = new SqlCommand("insert into t_hb (juanming, suoxie, pinyin, zhang, jie, jingwen) values (@juanming, @suoxie, @pinyin, @zhang, @jie, @jingwen)", conn2))
            //                    {
            //                        cmd2.Parameters.AddWithValue("juanming", odr["fullname"]);
            //                        cmd2.Parameters.AddWithValue("suoxie", odr["shortname"]);
            //                        cmd2.Parameters.AddWithValue("pinyin", odr["py"]);
            //                        cmd2.Parameters.AddWithValue("zhang", odr["chaptersn"]);
            //                        cmd2.Parameters.AddWithValue("jie", odr["versesn"]);
            //                        cmd2.Parameters.AddWithValue("jingwen", odr["strjw"]);
            //                        conn2.Open();
            //                        cmd2.ExecuteNonQuery();
            //                        Console.WriteLine(odr["fullname"].ToString());
            //                    }
            //                }
            //            }
            //        }
            //    }
            //}
        }
    }
}