bulk insert

  1. A

    Question perform bulk insert

    Hi, currently I have text file showing as this Class_ID, USER_ID, SOURCE_NO 10001:A01:AAA01 10002:A02:AAA01 10003:A03:AAA01 10004:A04:AAA01 10005:A05:AAA02 <-- this is wrong, I need to compare within text file as well. Did anyone know how to bulk insert the data I read from text file? it many...
  2. C

    Question Is it possible to return all items in a List/Queue without Iterating over them?

    Ok, I have a very specific situation that this would be useful for. I have a DataTable with a large number of columns(200+) that I am doing a bulk insert for in SQLite, since it does not support Update Table like SQL Server does. I want to know if there is a way after I iterate over all the...