I have tried multiple solutions and ended up here and blocked.I have to add a data column in to the existing data table.
I need to add one more column and data to that table from a .txt file in to 0th column and from second column i need to keep the DB data. I am not using any grid view and stream reader to my app.Need to use File.ReadAllLines();
my .txt file is like
ClaimID
val1
val3
val5
i tried something and the data table not coming properly..Data table coming like showing in the picture below (datas starting from last row of first column and skipped first rows):

My code
if (tableName == "TestData")
{
var pathC = @"H:\claimdetails\claims\Claims.txt";
string[] result = File.ReadAllLines(pathC);
DataColumn Col = table.Columns.Add("Claim_ID", typeof(String));
Col.SetOrdinal(0); // set column to first position
DataRow row;
for (int i = 0; i < result.Length; i++)
{
row = table.NewRow();
row["Claim_ID"] = result[i];
table.Rows.Add(row);
}
}
adapter.Fill(table);
How can i get a proper data table?