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);
}
jeeten.parma...
Member
74 Points
94 Posts
Insert New Column into Datatable
Jan 25, 2013 11:32 AM|LINK
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); }CruzerB
Contributor
5399 Points
1098 Posts
Re: Insert New Column into Datatable
Jan 25, 2013 11:55 AM|LINK
Hi,
You might want to describe your issue clearly. :)
My Technical Blog
speshulk926
Participant
884 Points
204 Posts
Re: Insert New Column into Datatable
Jan 25, 2013 05:44 PM|LINK
Based solely on your post it sounds like it's working. You need to have a question.
jeeten.parma...
Member
74 Points
94 Posts
Re: Insert New Column into Datatable
Jan 26, 2013 02:56 AM|LINK
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
CruzerB
Contributor
5399 Points
1098 Posts
Re: Insert New Column into Datatable
Jan 26, 2013 09:03 AM|LINK
Hi,
According to your requirement, you cannot have "NewRow()" and it must be update to existing row.
Please try this instead.
dsCollege.Rows[i].SetField("Rank", i.ToString());
My Technical Blog