Change Column Value In DataSet
Posted on 2004-08-17
I have a dataset populated by an xml file.
I want to bind more than one column of the dataset to a ListBox DataTextField property.
I cant seem to make that work, so what I am now trying to do is this:
for (int i = 0; i < ds.Tables.Rows.Count; i++)
ds.Tables.Rows[i].ItemArray.SetValue(ds.Tables.Rows[i].ItemArray.GetValue(6).ToString() + " - " + ds.Tables.Rows[i].ItemArray.GetValue(7).ToString(), 7);
Which is trying to set the value of column 7 to the values of column 6 + " - " + column 7.
After this runs I do the following:
The problem is that when the results are displayed, the value of column 7 has not changed.
Any advice would be much appreciated.