数据库的导出和导入

 class Program
    {
        static void Main(string[] args)
        {
            string name = "Data Source=W-PC;Initial Catalog=csdn-student;Integrated Security=True";
            #region 数据库导出
            #region
            Console.WriteLine("将数据库表中数据全部导出到记事本文件中:\n");


            SqlConnection conn = new SqlConnection(name);
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from StudentInto";
            //cmd.CommandText = "select Stu_Id,Stu_Name,Stu_Gender,Stu_Class,Stu_Address,Stu_Mobile,Stu_Award from StudentInto";
            SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            adapter.Fill(dt);






            #endregion




            FileStream filestream = File.Open(@"c:\studentinfo.txt", FileMode.OpenOrCreate, FileAccess.Write);
            StreamWriter write = new StreamWriter(filestream);
            string s1, s2, s3, s4, s5, s6, s7, s8;
            s1 = s2 = s3 = s4 = s5 = s6 = s7 = s8 = "";
            #region 字段




            for (int i = 0; i < dt.Rows.Count; i++)
            {
                s1 = dt.Rows[i][0].ToString();
                s2 = dt.Rows[i][1].ToString();
                s3 = dt.Rows[i][2].ToString();
                s4 = dt.Rows[i][3].ToString();
                s5 = dt.Rows[i][4].ToString();
                s6 = dt.Rows[i][5].ToString();
                s7 = dt.Rows[i][6].ToString();
                s8 = dt.Rows[i][7].ToString();
                //Console.WriteLine(s1 + " | " + s2 + " | "+s3+"| "+s4+" | "+s5+" | "+s6+" | "+s7+" | "+s8);
                write.WriteLine(s1 + "|" + s2 + "|" + s3 + "|" + s4 + "|" + s5 + "|" + s6 + "|" + s7 + "|" + s8);
            }


            #endregion
            dt.Dispose();
            conn.Close();
            conn.Dispose();
            write.Close();
            write.Dispose();
            filestream.Close();
            filestream.Dispose();
            Console.WriteLine("操作成功");
            #endregion




          #region 将记事本中的数据全部导入到数据库的一张表中
            Console.WriteLine("\n\n\n将记事本中的数据全部导入到数据库的一张表中\n");
            FileStream stream = File.Open(@"c:\studentinfo.txt", FileMode.OpenOrCreate, FileAccess.ReadWrite);
            StreamReader reader = new StreamReader(stream);




            SqlConnection conn1 = new SqlConnection(name);
            conn1.Open();
            SqlCommand cmd1 = new SqlCommand();
            cmd1.Connection = conn1;
            cmd1.CommandText = "insert into StudentInto3(Stu_Id,Stu_Name,Stu_Mobile,Stu_Address,Stu_Gender,Stu_Class,Stu_Grade,Stu_Award) values(@id,@name,@mobnile,@address,@gender,@class,@grade,@award)";
            string result = "";
            while ((result = reader.ReadLine()) != null)
            {
                string[] values = result.Split('|');
                cmd1.Parameters.Clear();
                cmd1.Parameters.AddWithValue("@id", values[0]);
                cmd1.Parameters.AddWithValue("@name", values[1]);
                cmd1.Parameters.AddWithValue("@mobnile", values[2]);
                cmd1.Parameters.AddWithValue("@address", values[3]);
                cmd1.Parameters.AddWithValue("@gender", values[4]);
                cmd1.Parameters.AddWithValue("@class", values[5]);
                cmd1.Parameters.AddWithValue("@grade", values[6]);
                cmd1.Parameters.AddWithValue("@award", values[7]);


                cmd1.ExecuteNonQuery();
            }




            cmd1.Dispose();
            conn1.Close();
            conn1.Dispose();
            reader.Close();
            reader.DiscardBufferedData();
            stream.Close();
            stream.Dispose();
            Console.WriteLine("操作成功");
          #endregion


            #region 数据库导出1
            SqlConnection conn2 = new SqlConnection(name);
            conn2.Open();
            SqlCommand cmd2 = conn2.CreateCommand();
            cmd2.CommandText = "select * from StudentInto";
            string S1, S2, S3, S4, S5, S6, S7, S8;
            S1 = S2 = S3 = S4 = S5 = S6 = S7 = S8 = "";
            FileStream filestream1 = File.Open(@"g:\studentinfo.txt", FileMode.OpenOrCreate, FileAccess.Write);
            StreamWriter writer1 = new StreamWriter(filestream1);
            SqlDataReader reader = cmd2.ExecuteReader();
            while (reader.Read() == true)
            {


                S1 = reader[0].ToString();
                S2 = reader[1].ToString();
                S3 = reader[2].ToString();
                S4 = reader[3].ToString();
                S5 = reader[4].ToString();
                S6 = reader[5].ToString();
                S7 = reader[6].ToString();
                S8 = reader[7].ToString();
                writer1.WriteLine(S1 + "|" + S2 + "|" + S3 + "|" + S4 + "|" + S5 + "|" + S6 + "|" + S7 + "|" + S8);


            }


            cmd2.Dispose();
            conn2.Close();
            conn2.Dispose();
            writer1.Close();
            writer1.Dispose();
            filestream1.Close();
            filestream1.Dispose();
            Console.WriteLine("\n\n\nDataReader操作成功");


           #endregion




            Console.ReadKey();
        }
    }