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.