Add datacolumn to the datatable at a specified index RRS feed

  • Question

  • Hello,
     I have a dataset that gets its data from an olap server database.
    the columns I get is Description, 2002, 2003.

    however I have my criteria for selection as 2001, thru 2003. the database restricts the columns that have all 0's in it. hence i have the missing 2001. This is for faster processing time.

    Now I am trying to add the columns 2001(in between description and 2002) with all 0's in its rows.

    I see that there is Table.columns.Add, but none for AddAt. How do i Achieve this. I need to add a new column at a specified index. in this case i need to add column at index 1.

    I do not want to add it to the end of the collection, as my next logic depends on this format.

    Any Ideas are welcome.

    Tuesday, May 30, 2006 4:33 PM


All replies