I use this dataset in order to display some data on Interent by using DevExpress Xtra Report. When the page which contains the XtraReport is loaded I have in a session object

the sqlcommand of the data I want to display. Therefore since the Xtra report is based on the dataset all I have to before displying the report is change the select command of the tableadapter of the dataset.

From the page load of the page which contains the Xtra Report I can access the dataset and the datatable but I cannot access the Table Adpater which containe the connections string and the SelectCommand.CommandText.

Any ideas on how to set this SelectCommand.CommandText property?



Best Regards,

Manolis