C# 行中每一列的 KeyValue

Question

我今天在这里试图找出如何做到这一点。我有下面的代码来查看 DataRow 中的每一列，但如何访问键和值？我想将它分配给类中的字典，但我似乎无法同时获取它们，我获取任何内容的唯一方法是调用:

var columnValue = playerDataRow[column];

完整内容如下:

using (var mysqlConnection = Sirius.GetServer().GetDatabaseManager().GetConnection())
{
    mysqlConnection.SetQuery("SELECT * FROM `users` WHERE `auth_ticket` = @authTicket LIMIT 1");
    mysqlConnection.AddParameter("authTicket", authTicket);

    var playerDataTable = mysqlConnection.GetTable();

    foreach (DataRow playerDataRow in playerDataTable.Rows)
    {
        foreach (DataColumn column in playerDataTable.Columns)
        {
            var columnValue = playerDataRow[column];
        }
    }
}

Answer 1

foreach (DataRow playerDataRow in playerDataTable.Rows)
{
    var myDic = new Dictionary<string, object>();

    foreach (DataColumn column in playerDataTable.Columns)
    {
        myDic.Add(column.ColumnName, playerDataRow[column]);
    }
}