change main query of Table Adapter at runtime

Question

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.

Anuja · Answer

You can pass parametersto your query example ... string parameter1 = x_value; string query = Select  + parameter1 +  from tablename;