How to change dataset QUERY connection string at runtime in
                            
                         
                        
                     
                 
                
                    Hi,
I've a dataset called MyDataSet.XSD. I want to access this in code behind and assign different connection strings based on user logs in.
I've TableAdapters and Queries configured to it.
I access Adapters like below:
objDa.Connection.ConnectionString="myConString";
How assign to Query in dataset dynamically in asp.net?