如何检查数据视图中是否存在记录？ C＃

Question

我已经有两个列的数据视图：ContactID和Name

我如何检查特定ContactID已经在数据视图现有的？

Answer 1

有你DataView.FindRows Method一看也许DataView.Find Method

Answer 2

的数据视图了，这可用于搜索特定的ContactID，例如一个名为FindRows方法...

var table = new DataTable(); 
var column = new DataColumn("Id", typeof (int)); 

table.Columns.Add(column); 
table.PrimaryKey = new[] {column}; // Unique Constraint 

var row = table.NewRow(); 
row["Id"] = 100; 
table.Rows.Add(row); 

row = table.NewRow(); 
row["Id"] = 200; 
table.Rows.Add(row); 

var view = new DataView(table) { ApplyDefaultSort = true }; 
var rows = view.FindRows(200); 

foreach(var r in rows) 
{ 
    Console.WriteLine(r["Id"]); 
} 

Answer 3

使用以下代码在Dataview中查找行

 //Your original Table Which consist of Data 
     DataTable dtProducts = new DataTable(); 
     //Add the DataTable to DataView 
     DataView ProductDataView = new DataView(dtProducts); 
     ProductDataView.RowFilter = ""; 
     ProductDataView.Sort = "ProdId"; 
     int recordIndex = -1; 
     //In the Find Row Method pass the Column 
     //value which you want to find 
     recordIndex = ProductDataView.Find(1); 
     if (recordIndex > -1) 
     { 
      Console.WriteLine("Row Found"); 
     }