检查datagridview中是否已经存在一个值

本文介绍了检查datagridview中是否已经存在一个值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

有人可以帮我吗? 我正在从标签向datagridview添加值.但是在插入值之前，我想检查该值是否在datagridview中不存在.我在堆需要帮助. 在此先感谢您.

Hi, Can somebody help me out? I am adding values to a datagridview from a label. But before i insert the value, i want to check if the value does not already exist in the datagridview. I am stack. Need help. Thanks in advance.

推荐答案

您可以对使用datagridview进行分配的Assign数据集进行查询.例如. You can make query on assign dataset which is assign with datagridview. for example. dim ds as new dataset Dim da as new oledb.OledbDataAdapter("Select * from table1",conn) da.Fill(ds) DataGridView1.DataSource = ds.Table(0) ''Now if you want to check that record is all ready exists of not. dim dr as datarow() dr = ds.Table(0).select("SearchFieldName = " & ''SearchValue) if dr.Length >0 then Messagebox.show("Duplicate Record") end if