dynamic columns in datasets

[mohit]

Hi,

Can anyone suggest a way to create columns programatically in a dataset.The values of the new columns will be retrieved from a differant table in the dataset based on some values. Basically I am importing a excel file in the dataset.The excel file does not have a Rate field. The rate field for the datatable is to be set from the "rates table" based on the phone nos. in the excel file.

 

I am using the jet oledb provider for accesing the excel file. Any suggestions are most welcome. As you might have guessed I am a little new in asp.net

[Robby]

You can create a new Datatable at runtime the add it to the dataset.

[Robby]

this may help, check out page 3 of the article... http://www.aspalliance.com/articleViewer.aspx?aId=102&pId=1

[mohit]

Thanks robby,

I went throught the article. One thing is that they are adding the new columns with pre-determined values. I want to retrieve the new column values from another table.

 

I have a dataset with phone numbers and country codes. I want to another column to this dataset which indicates rates for countries(these rates are in "RATES table ). I am now trying to use Relations class for the dataset. Any suggestions are welcome

 

Thanks

Mohit