access转SQL server，SQL server转sqlite3

最新推荐文章于 2025-11-26 15:12:28 发布

原创最新推荐文章于 2025-11-26 15:12:28 发布 · 83 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#c# #数据库

文章展示了如何在C#中使用不同的数据库连接（SQLServer、SQLite）进行数据迁移，通过参数化查询将数据从一个数据库表插入到另一个表的过程。

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 (SqlConnection conn2 = new SqlConnection("server=.;database=hb;user id=sa;password=Abcdefg1"))
            {
                using (SqlCommand cmd2 = new SqlCommand("select juan, pinyin, zhang, jie, jingwen from t_hb", conn2))
                {

                    conn2.Open();
                    using (SqlDataReader sdr = cmd2.ExecuteReader())
                    {
                        SQLiteConnection conn = new SQLiteConnection("Data Source=hb.sqlite3");
                        conn.Open();
                        while (sdr.Read())
                        {
                            using (SQLiteCommand cmd = new SQLiteCommand("insert into t_hb values (@juan, @pinyin, @zhang, @jie, @jingwen)", conn))
                            {
                                cmd.Parameters.AddWithValue("juan", sdr["juan"]);
                                cmd.Parameters.AddWithValue("pinyin", sdr["pinyin"]);
                                cmd.Parameters.AddWithValue("zhang", sdr["zhang"]);
                                cmd.Parameters.AddWithValue("jie", sdr["jie"]);
                                cmd.Parameters.AddWithValue("jingwen", sdr["jingwen"]);

                                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 (juan, suoxie, pinyin, zhang, jie, jingwen) values (@juan, @suoxie, @pinyin, @zhang, @jie, @jingwen)", conn2))
            //                    {
            //                        cmd2.Parameters.AddWithValue("juan", 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());
            //                    }
            //                }
            //            }
            //        }
            //    }
            //}

        }
    }
}