Bulk Insert in datatable from textfile

 yes you can, using SQLBulkCopy. Before implementing read on all the comments given.

Hi Jagan 
                Is there any posibilities to directly insert into datatable because however finally i need to insert records into datatable so that i am asking.


Thanks in advance

Hi,

Yes. you can

The limit of the string length depends only on the amount of memory available.

I tried to create a string with 2.147.483.647 characters, but around
50.000.000 characters my system can't handle it anymore. That's only 2% of
it...

So if you have memory capacity to read that much data at a time [ Bulk ] this code will work

Hai Jagan
                I need to insert into datatable because i have more than 1000 rows in text file..kindly let me know.



thanks in advance

Hi,

You can.

Use StreamReader class.

string bulkData=string.Empty;

using(StreamReader sr = new StreamReader("path to text file"))
{
        
        bulkData = sr.ReadToEnd();
}

update the bulkData value in DB now.