Hi, I have a data table having data from DB
I need to add one more column and data to that table from a .txt file.
when i ran my code that new colum not coming as a first colum and and a extra column without any data is added in to the data table.
Please anyone help
my .txt file is like
NAME ---- val1 val3 val5
i need to have NAME column as 0th colum of data table.below is my code
if (tableName == "NewData") {var pathC = @"D:\files\Data\names.txt";var fileContents = File.ReadAllLines(pathC);var splitFileContents = (from f in fileContents select f.Split(':')).ToArray();int maxLength = (from s in splitFileContents select s.Count()).Max();for (int i = 0; i < maxLength; i++) { table.Columns.Add(); }foreach (var line in splitFileContents) { DataRow row = table.NewRow(); row.ItemArray = (object[])line; table.Rows.Add(row); } return table; //NAMES column will be the first column}