SqlbulkCopy

来源：互联网发布：java ftp客户端源代码编辑：程序博客网时间：2024/06/16 05:13
    public partial class TelSearchWindow : Window    {        public TelSearchWindow()        {            InitializeComponent();        }        private static string connStr = ConfigurationManager.ConnectionStrings["adConnStr"].ConnectionString;        private void btnImport_Click(object sender, RoutedEventArgs e)        {            OpenFileDialog ofd = new OpenFileDialog();            ofd.Filter = "文本文件 |*.txt";            if (ofd.ShowDialog() == false )            {                return;            }         //IEnumerable <string > lines         //    = File.ReadLines(ofd.FileName, Encoding.Default);            string[] lines = File.ReadLines(ofd.FileName, Encoding.Default).ToArray();            DateTime startTime = DateTime.Now;            DataTable  table = new DataTable ();            table.Columns.Add("StartTelNum");            table.Columns.Add("City");            table.Columns.Add("TelType");               for (int i = 0; i < lines.Count (); i++)                 {                     string line = lines[i];                     string[] strs = line.Split('\t'); //VS里‘\t’为制表符                     string startTelNum = strs[0];                     string city = strs[1];                     city = city.Trim('"');   //去掉两边双引号  “”                     string telType = strs[2];                     telType = telType.Trim('"');                   DataRow  row = table.NewRow(); //  创建一个Data Row                   row ["StartTelNum"] = startTelNum;//一定要在一开始创建  table.Columns.Add("StartTelNum");                    row ["City"] = city;                    row ["TelType"] = telType;                   table.Rows .Add (row);  //datarow只是创建没有插入数据库                 }            using (SqlBulkCopy bulkCopy = new SqlBulkCopy(connStr))            {                bulkCopy.DestinationTableName = "T_TelNum";                //添加datatable中列名和数据库表中列名的映射                bulkCopy.ColumnMappings.Add ("StartTelNum","StartTelNum");                bulkCopy.ColumnMappings.Add ("City","TelArea");                bulkCopy.ColumnMappings.Add ("TelType","TelType");                bulkCopy .WriteToServer(table);            }                         TimeSpan st = DateTime.Now - startTime ;            MessageBox.Show (st.ToString ());                  }    }
0 0