we have many databases same tables in all of them and those tables have similar columns but data is different. I have a text box to enter a query and Checklistbox to select the connection string to the databases.
Now, i have to give a query from textbox and selecting the connection strings from the listbox that particular table from the database given on listbox should show dynamically.
i did it but when i click on header to sort the datagrid is disappearing
You have a complex scenario and we'll have to investigate it. In order to do so we would need an working sample application demonstrating the problem.