change main query of Table Adapter at runtime

Hi,

I am using a datset to populate a chart. Now, I want to programmatically change the Main Sql Statement of Table Adapter.

For example: select col1 as x , col2 as y from table1 is the query for the dataset.

Now I want to change that query during runtime on button click like "select col1 as y, col2 as x from table1".

The main purpose of this is to change the X-axis and Y-axis of the chart at runtime.