查询的结果在sqldatareader中，它可以具有灵活的列数和行数。

string mySQLQuery= "select * from myTable";
SqlCommand myTableCommand = new SqlCommand(mySQLQuery, MyConnection);
SqlDataReader myReader = null;
myReader = myTableCommand.ExecuteReader();

我想做的是在datagrid中显示结果。.xaml部分如下所示：

<DataGrid Name="myDataGrid" SelectionMode="Extended" SelectionUnit="Cell" AutoGenerateColumns="True" AlternatingRowBackground="LightCyan" 
    ItemsSource="{Binding}" IsEnabled="True" IsReadOnly="True" Background="WhiteSmoke" Margin="13,27,8,110" CanUserSortColumns="True">
</DataGrid>

.xaml.cs部分中用于将我的表的值显示到datagrid中的以下代码块完全是假设性的，只是为了澄清我想做什么：

// suppose that I have read the list of headers (column names)
// and suppose a button is clicked and an event is triggered and these codes are fit into that event
List<string> myHeaders = new List<string>() { "ID" , "Name" , "Country" , "City" };
myDataGrid.headers= myHeaders; // no method called "header" in reality
While (myReader.Read())
{
 myDataGrid.RowValues = myReader // no method called "RowValues" in reality
}

我更喜欢没有单独类来管理datagrid的每一列的解决方案，因为这样很难有灵活的列数。显然我希望我的结果是这样的：

ID   |  Name  |  Country  | City
------------------------------------
 123  |  John  |  England  | London
------------------------------------
 456  |  Jane  |  Ireland  | Dublin
 ...     ...        ...       ...

这个链接中没有一个答案有帮助：如何使用wpf在datagrid中显示sql搜索结果