数据的导出与导入（数据库）

数据的导出

 

 class Program
    {
        static void Main(string[] args)
        {
            string sqlserverstr = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;
            SqlConnection conn = new SqlConnection(sqlserverstr);
            SqlCommand cmd = conn.CreateCommand();

            #region sqldataadapter    第一种方法
            //cmd.CommandText = "select * from T_student";
            //SqlDataAdapter adapter = new SqlDataAdapter(cmd);
            //DataTable dt = new DataTable();
            //adapter.Fill(dt);

            //#region 将?数簓据Y导?出?到?记?事?本?
            创洹?建¨文?件t，?并￠建¨立ⅰ?程ì序ò到?文?件t的?流ⅰ?
            //FileStream filestream = File.Open(@"F:\studentinfo.txt", FileMode.OpenOrCreate, FileAccess.Write);
            //StreamWriter writer = new StreamWriter(filestream);
            //string id = "";
            //string name = "";
            //string mobile = "";
            //string address = "";
            //string gender = "";
            //string xibie = "";
            //string grade = "";
            //string award = "";
            //for (int i = 0; i < dt.Rows.Count; i++)
            //{
            //    id = dt.Rows[i]["Stu_Id"].ToString();
            //    name = dt.Rows[i]["Stu_Name"].ToString();
            //    mobile = dt.Rows[i]["Stu_Gender"].ToString();
            //    address = dt.Rows[i]["Stu_Mobile"].ToString();
            //    gender = dt.Rows[i]["Stu_Address"].ToString();
            //    xibie = dt.Rows[i]["Stu_Class"].ToString();
            //    grade = dt.Rows[i]["Stu_Award"].ToString();
            //    award = dt.Rows[i]["Stu_Grade"].ToString();
            //    writer.WriteLine(id + "|" + name + "|" + gender + "|" + mobile + "|" + address + "|" + xibie + "|" + award + "|" + grade + "|");
            //}
            //writer.Close();
            //writer.Dispose();
            //filestream.Close();
            //filestream.Dispose();

            //#endregion
            #endregion        第二种方法

            cmd.CommandText = "select * from T_student";
            conn.Open();
            
            #region 建立流文件
            int k = 0;
            FileStream filestream = File.Open("F:\\studentinfo.txt", FileMode.Append, FileAccess.Write);
            StreamWriter writer = new StreamWriter(filestream, Encoding.Default);
            #endregion
            SqlDataReader dtreader = cmd.ExecuteReader();  //读取数据中的数据

            while (dtreader.Read())
            {
                string id = dtreader["Stu_Id"].ToString();
                string name = dtreader["Stu_Name"].ToString();
                string gender = dtreader["Stu_Gender"].ToString();
                string mobile = dtreader["Stu_Mobile"].ToString();
                string address = dtreader["Stu_Address"].ToString();
                string xibie = dtreader["Stu_Class"].ToString();
                string award = dtreader["Stu_Award"].ToString();
                string grade = dtreader["Stu_Grade"].ToString();
                Console.WriteLine(id + "|" + name + "|" + gender + "|" + mobile + "|" + address + "|" + xibie + "|" + award + "|" + grade);
                writer.WriteLine(id + "|" + name + "|" + gender + "|" + mobile + "|" + address + "|" + xibie + "|" + award + "|" + grade);
                k++;
            }
            Console.WriteLine("导出完成");

            cmd.Dispose();
            conn.Close();
            conn.Dispose();
            writer.Close();
            writer.Dispose();
            filestream.Close();
            filestream.Dispose();
            Console.Read();
        }

 

数据的导入

 

namespace 数据的导入
{
    class Program
    {
        static void Main(string[] args)
        {
            #region 建立读取文件流
            FileStream filestream = File.Open("f:\\studentinfo.txt", FileMode.OpenOrCreate, FileAccess.Read);
            StreamReader reader = new StreamReader(filestream);
            #endregion

            #region 建立连接数据库
            string sqlserverstr = ConfigurationManager.ConnectionStrings["sqlserver"].ConnectionString;
            SqlConnection conn = new SqlConnection(sqlserverstr);
            conn.Open();
            SqlCommand cmd = conn.CreateCommand();
            cmd.CommandText = "insert into T_student values(@id,@name,@gender,@mobile,@address,@class,@award,@grade)";
            string result="";
            while ((result=reader.ReadLine())!=null)
            {
                string[] values = result.Split('|');  
                cmd.Parameters.Clear();    //像@id运行时会存储在parameters中
                cmd.Parameters.AddWithValue("@id", values[0]); 
                cmd.Parameters.AddWithValue("@name", values[1]);
                cmd.Parameters.AddWithValue("@gender", values[2]);
                cmd.Parameters.AddWithValue("@mobile", values[3]);
                cmd.Parameters.AddWithValue("@address", values[4]);
                cmd.Parameters.AddWithValue("@class", values[5]);
                cmd.Parameters.AddWithValue("@award", values[6]);
                cmd.Parameters.AddWithValue("@grade", values[7]);
                cmd.ExecuteNonQuery();
            }
            #endregion

            conn.Close();
            conn.Dispose();
            cmd.Dispose();
            filestream.Close();
            filestream.Dispose();
            Console.WriteLine("导入成功");
            Console.Read();
        }
    }