[DevExpress Support Team: CLONED FROM T552585: Data added to GridControl from SQLite database - how can I access columns by name]
So what is best way using your controls for me to achieve what I need then - can you offer an example or post some code?
Basically what I am trying to achieve is this:-
I run a SQL query against my SQLite database and the results are shown in the gridcontrol - only some columns (the important ones) are visible in the gridcontrol
When I click on a row I want to then be able to show in a panel below the contents of some of the "hidden" columns, so basically it will be a summary panel and clicking an item populates this panel
So I need to access the contents of a cell in a specific column and the selected row
If there is a better way for me to do this using any other DevExpress controls then please let me know
Thank you very much
I suggest you use DataLayoutControl to display values from hidden columns. Bind both GridControl and DataLayoutControl to the same data source and call the DataLayoutControl.RetrieveFields method to populate this control with editors. Handle the DataLayoutControl.FieldRetrieving event to cancel creating editors for visible grid columns. I've attached a simple project demonstrating this approach in action.
Drop me a line if you have any further questions.