SqlBulkCopy从记事本批量复制数据4
1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950static void Main(string[] args) { try { stringfilepath = @"TXT文件地址"; StreamReader file =new StreamReader(filepath, System.Text.Encoding.Default); stringusername; stringpassword; stringacout; Stopwatch stopwatch =new Stopwatch(); stopwatch.Start(); DataTable dataTable = GetTableSchema(); while(true) { //从TXT读取数据部分 DataRow dataRow = dataTable.NewRow(); dataRow["username"] = username; dataRow["password"] = password; dataRow["account"] = acout; dataTable.Rows.Add(dataRow); } stringconnectionString = "MSSQL连接字符串"; SqlBulkCopy sqlBulkCopy =new SqlBulkCopy(connectionString); sqlBulkCopy.DestinationTableName ="表名"; sqlBulkCopy.BatchSize = dataTable.Rows.Count; SqlConnection sqlConnection =new SqlConnection(connectionString); sqlConnection.Open(); if(dataTable != null&& dataTable.Rows.Count != 0) { sqlBulkCopy.WriteToServer(dataTable); } sqlBulkCopy.Close(); sqlConnection.Close(); dataTable.Clear(); stopwatch.Stop(); file.Close(); } catch(IOException e) { Console.WriteLine(e.ToString()); } }