C# TXT文件导入SQL

C# TXT文件导入SQL

 

using System;
using System.Data;
using System.Data.SqlClient;
using System.IO;

public class Test
{
    public static void Main()
    {
        StreamReader sr = new StreamReader(new FileStream("custom.txt", FileMode.Open, FileAccess.Read), System.Text.Encoding.Default);

        SqlConnection cn = new SqlConnection("Server=.;uid=sa;pwd=;database=data");;

        string insertCmd = "insert into custom values (@name, @phone, @address)";
       
        char delimChar = ',';
        string [] split = null;

        string strTemp = sr.ReadLine();
        while(strTemp != null)
        {
            split = strTemp.Split(delimChar);
            SqlCommand cmd =  new SqlCommand(insertCmd, cn);

            cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = split[0];
            cmd.Parameters.Add("@phone", SqlDbType.VarChar).Value = split[1];
            cmd.Parameters.Add("@address", SqlDbType.VarChar).Value = split[2];
            cn.Open();
            try
            {
                cmd.ExecuteNonQuery();
            }
            catch(System.Data.SqlClient.SqlException e)
            {
                Console.WriteLine(e.Message);
            }
            cn.Close();
            strTemp = sr.ReadLine();
        }
        sr.Close();
    }
}

转自：http://blog.163.com/tracymcgrady_zwc@126/blog/static/1074415652009830101822450/