C# Sql tables in a DataGrid

Question

Hello, I'm working on a project where I have to search for a table and get all the values and show them in a Datagrid.
The problem that I get is, that the Columns are shown double.. For example a Table with "Id" and "Name" would look like this: Id | Name | Id | Name
What my question, is there a way to show a Different tables with different columns?

I'm using Dapper and to save the values I use IEnumerable<dynamic>... But yeah the Data ist displayed twice

Thanks in Advance for any hints

Answer 1

Try using listview and data binding. I assure you it is much more convenient. I understand that you write this on WPF or UWP? If you want, I can help you. Maybe your SQL query is not yet written?

Answer 2

You were told correctly, the sql adapter is used for reading.

Answer 3

What is your answer? Tell me how is this done?

Answer 4

Thank you a lot, yesterday a collegue told me to use sqlAdapter and Datatable, now its working properly 😁👍

Answer 5

give me answers plllllsllllellelelalalalsssse