Insert New Column into Datatable

Question

User-2050663300 posted

Here, I am trying to insert New column named "Rank" into the Datatable. It inserts Column name "Rank" and even inserting count numbers but

for i.e. if 10 records are present in datatable then it is inserting Rank value from the 11 number index...
dsCollege is datatable... Count is total number of records...

DataColumn dcRank = new DataColumn();
        dcRank.DataType = typeof(Int32);
        dcRank.ColumnName = "Rank";

        dsCollege.Columns.Add(dcRank);

        for (int i = 0; i <= count; i++)
        {
            DataRow dr = dsCollege.NewRow();
            dr["Rank"] = i.ToString();
            dsCollege.Rows.Add(dr);
        }

Answer 1

User614805505 posted

Hi,

You might want to describe your issue clearly. :)

Answer 2

User223678428 posted

Based solely on your post it sounds like it's working.  You need to have a question. 

Answer 3

User-2050663300 posted

I have one datatable...

like...

Name          Address               Number
Jeeten         Vadodara            123456789
Deep          Vadodara             1236547956

Now, I am adding one more column named "Rank" in this datatable by using code as u can see in main post... Then im getting result,

Name          Address               Number            Rank
Jeeten         Vadodara            123456789
Deep          Vadodara             1236547956
                                                                        1

                                                                        2

But, I want it as,

Name          Address               Number               Rank
Jeeten         Vadodara            123456789               1
Deep          Vadodara             1236547956             2

Answer 4

User614805505 posted

Hi,

According to your requirement, you cannot have "NewRow()" and it must be update to existing row.

DataRow dr = dsCollege.NewRow();

Please try this instead.

dsCollege.Rows[i].SetField("Rank", i.ToString());