How to add text file to data table column?

Question

I have data table having 5 colom data and which is am fetching from database.Now i have to add a new colom like below that is not from the DB but from my text file path.

NAME
.......
Jhonathan
Tony
Mika
haris
shaju
mathew

How i can add this colom in the first position of my data table?

Jignesh Kumar · Answer

Hi, Please refer this link, https://www.roseindia.net/tutorial/java/io/insertFileData.html

Srinivasan Ramamoorthi · Answer

Retrive the data from txt file as dataset in another method Create another method to merge both the data tables by creating data column in first dataset. Hope you are familiar with adding datacolumns at runtime. If not I can share some links.

Sujeet Raman · Answer

below is my table creation code and i am getting data table with DB values .How i can add my txt file as first column private static DataTable LoadTable(string connectionString, string query, string tableName) { using (var connection = new OdbcConnection(connectionString)) using (var command = new OdbcCommand(query, connection)) using (var adapter = new OdbcDataAdapter(command)) { command.CommandTimeout = 0; var table = new DataTable(tableName); adapter.Fill(table); return table; } }

Srinivasan Ramamoorthi · Answer

You have to fetch the data from text file using OLEDB driver or other options in dataset format (dt1) After you get the dataset (dt2) from database for 5 columns, you need to add data column to datatable (dt2) and add the names from dt1 by iterating dt1.