从数据表中删除记录。 [英] Delete a record from datatable.

问题描述

我正在查询数据表

I am querying a datatable

var ss = from data in dtRec.AsEnumerable()
                                     where data.Field<string>("Recommendations") == "Contact Vibration Specialist"
                                     select data;

我得到两个值所以我想只删除一个值我怎么能删除？我必须更新数据表。

I am getting two values so i want to delete only one value how can i delete?? and i have to update the datatable.

推荐答案

试一试

try it

DataTable dt1 = new DataTable();
dt1 = ds.Tables[0];
for (int i = 0; i < dt.Columns.Count;i++ )
{
if (i == 3)
{
dt.Rows[i - 1].Delete();
dt.AcceptChanges();
}
}

使用removeall方法删除记录。



示例：

var authorsList = authorsList.Where（x => x.FirstName！=Bob）。ToList（）;



authorsList.RemoveAll（x => x.FirstName ==Bob）;

use removeall method to delete record.

Example:
var authorsList = authorsList.Where(x => x.FirstName != "Bob").ToList();

authorsList.RemoveAll(x => x.FirstName == "Bob");

这篇关于从数据表中删除记录。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！