How to set a data table column as a first column of a Data Table

Sujeet Raman

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}

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
use this instead
var array= File.ReadAllText(path).Split('\n');
Sujeet Raman4y ago
Hi but i am getting index out of array exception.How we will fix?

this is what i have tried

if (tableName == "TestData")
{
var pathC = @"H:\files\Data\names.txt";
string[] result = File.ReadAllLines(pathC);
// string[] result = strResult.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
DataColumn Col = table.Columns.Add("Name", typeof(String));
Col.SetOrdinal(0); // set column to first position
int i = 0;
foreach (DataRow row in table.Rows)
{
//need to set value to NewColumn column
row["Name"] = result[i]; // INDEX OUT OF EXCEPTION HERE
i++;
}
}
Sachin Singh4y ago
yes will work.
Sujeet Raman4y ago
if am not using stream reader (its a console app attached to main project) how can i change

string[] strResult = File.ReadAllLines(@"C:\\file.txt"); this will work?
using (StreamReader sr = new StreamReader(@"D:\files\Data\names.txt"))
{
string strResult = sr.ReadToEnd();
string[] result = strResult.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
Sachin Singh4y ago
according to your file structure your code should be
using (StreamReader sr = new StreamReader(@"D:\files\Data\names.txt"))
  {
string strResult = sr.ReadToEnd();
string[] result = strResult.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);


DataColumn Col=dt.Columns.Add("Name", typeof(String));
  Col.SetOrdinal(0); // set column to first position
int i=0;
foreach(DataRow row in dt.Rows)
{
    //need to set value to NewColumn column
    row["Name"] = result[i];   // or set it to csv values
  i++;
}
Sujeet Raman4y ago
in my D folder i have a .txt file having data in following format

NAME
hari
shiju
sam
ram
Sachin Singh4y ago
show me your csv file. Then i will be able to give you correct csv parser code.
Sachin Singh4y ago
follow this
var contents = File.ReadAllText(filename).Split('\n');
var csv = from line in contents
          select line.Split(':').ToArray();

DataColumn Col=dt.Columns.Add("Name", typeof(String));
  Col.SetOrdinal(0); // set column to first position
int i=0;
foreach(DataRow row in dt.Rows)
{
    //need to set value to NewColumn column
    row["Name"] = csv[i];   // or set it to csv values
  i++;
}
Nitin Sontakke4y ago
I believe that the example you have shown is bit misleading.

Please try to give the data in the question closest to the reality.

For example, one would ask why are you spliting the line with : when there is no colon in the line.

While adding columns, you are not giving names.

First I thought that you wanted to add a column which is NOT available in the source. But I don't think that is the case.

Please provie maximum information, closest to the reality. If we make any assumptions, our answers will obviously be wrong.

You can even send a meeting request on nitin.n.sontakke at gmail dot com and we can discuss on Google Meet.
Sujeet Raman4y ago
i am not using gridview.I have to convert that data table to XL file .
Srinivasan Ramamoorthi4y ago
The column can be added at any position, when you bind to gridview use column name to bind that will take care of the column position
Nitin Sontakke4y ago
Why not add a column to the table JUST BEFORE the for loop in which you are adding all other columns?
table.Columns.Add("Name");
for (int i = 0; i < maxLength; i++)
{
table.Columns.Add();
}