Asp.net mvc bulk upload into database

hi,

  use SqlBulkCopy for bulk insert.


thanks
arjun

Hi Narsimha,

I suggest you using LINQ in this context, it's beautiful.

below is a sample for you:
-----------------------------------------------------
DataTable dt = new DataTable();
// I assume dt to be filled already.

int count=0;
while (count < dt.Rows.Count)
{
var Hundred_Records = dt.Select().Skip(count).Take(100).CopyToDataTable();
foreach (DataRow dr in Hundred_Records.Rows)
{
// Manipulation goes here.
}

count+=100;
}
------------------------------------------------------------

Happy Coding :)

Please mark this as answer if it helps!
Cheers!