SqlBulkCopy从记事簿批量复制数据4

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());            }          }