比较两个数据行

发布于 2024-12-28 21:03:50 字数 569 浏览 1 评论 0原文

我有一个数据表，其中包含多行。我还有 1 行，我想检查该行是否与数据表中现有行重复。所以我尝试了这样的操作：

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dt.Rows.Contains(dataRow) && dt.Rows.Count != 0)  // Giving error
            continue;
        dt.ImportRow(dataRow);
        return dataRow;
    }
}

在这里，我的 dataTable 也第一次可以为 null/空。

但其给出的错误为：

表没有主键。

任何人都可以帮助我吗？如果需要额外的代码，只需注释即可。

原文

I have a datatable with multiple rows inside it. I have got 1 more row and I want to check if this row is a duplicate of the existing rows in the datatable. So I tried like:

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dt.Rows.Contains(dataRow) && dt.Rows.Count != 0)  // Giving error
            continue;
        dt.ImportRow(dataRow);
        return dataRow;
    }
}

Here, my dataTable can also be null/empty for the first time.

But its giving error as:

Table doesn't have a primary key.

Can anyone help me please. If additional code is required, just comment.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

丑丑阿 2025-01-04 21:03:50

您不能在 DataTable 对象上添加 PK 吗？

我认为代码会是这样的：

dataTable.PrimaryKey = new DataColumn[] { dataTable.Columns["Id"] };

Can't you add the PK on your DataTable object?

I think the code would be something like this:

dataTable.PrimaryKey = new DataColumn[] { dataTable.Columns["Id"] };

回复收藏 0 原文

孤君无依 2025-01-04 21:03:50

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dt.Rows.Contains(dataRow) && dt.Rows.Count != 0)  // Giving error
            continue;
        dt.ImportRow(dataRow);
        return dataRow;
    }
}

我假设您的 dt 变量应该是您的 dataTable 变量，如果您收到错误消息，告诉您您的表没有主键，可能是因为您使用了错误的变量，并且确实没有主键或与您尝试使用的变量关联的表。

所以我认为代码应该看起来像这样

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dataTable.Rows.Contains(dataRow) && dataTable.Rows.Count != 0)  // Giving error
            continue;
        dataTable.ImportRow(dataRow);
        return dataRow;
    }
}

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dt.Rows.Contains(dataRow) && dt.Rows.Count != 0)  // Giving error
            continue;
        dt.ImportRow(dataRow);
        return dataRow;
    }
}

I assume that your dt variable is supposed to be your dataTable variable, if you are getting an error telling you that your table doesn't have a primary key it could be because you are using the wrong variable and that there really isn't a primary key or a table associated with the variable that you are trying to use.

so I assume that the code should look like this instead

DataTable dataTable = GetTable();
if (dataTable.Rows.Count > 1)
{
    for (int i = 0; i < dataTable.Rows.Count; i++)
    {
        var dataRow = dataTable.Rows[i];

        if (dataTable.Rows.Contains(dataRow) && dataTable.Rows.Count != 0)  // Giving error
            continue;
        dataTable.ImportRow(dataRow);
        return dataRow;
    }
}

回复收藏 0 原文

~没有更多了~