如何验证记录是否已存在于数据库或列表视图Windows中 [英] How to validate if records is already exist in dataBase or in listview windowsApplication

问题描述

美好的一天，任何人都可以教给我一个如何给我一个提示，即如何跟踪列表视图中是否有记录.我目前在Vb.net 2008 Windows应用程序中使用列表视图，并且目前使用的For Loop可以读取其中的所有记录. listview验证记录是否在listview中，但是我的问题是if records
在列表视图中已存在此记录
例如:样品记录"，到样品记录"
我的验证码未跟踪此样本记录"
或从技术上讲，它们无法跟踪CAPITAL CHARACTER与Normal CHARACTER的相似性:(感谢所有编码人员在这里:D

good Day can any one teach me how give me a tip how to trace if records is already in the in listview , i currently use listview in Vb.net 2008 Windows Application and i currently use a For Loop that reads all Records in listview to validate if the records is in the listview , but my problem is if records
is in the the listview is already Exist this Records
for Ex:" SAMPLE RECORD" , to "Sample Record"
my validation code not trace this one "Sample Record"
or technically speaking they not trace the similarity of CAPITAL CHARACTER to Normal CHARACTER :( Thanks to all Coders Here :D

推荐答案

如果您的问题是在检查等效字符串时不考虑大小写，然后比较转换为大写的两个字符串.

If your problem is checking equivalent strings without regard to case, then compare both strings converted to upper case.

为进行比较，您不需要使用For循环，请将DataView.RowFilter(string)与比较值一起使用，并使用DataView.Count ()检查是否存在匹配项.

http://msdn.microsoft.com/en-us/library/system. data.dataview.rowfilter.aspx [ ^ ]

希望对您有所帮助.

For comparison you do not need to use a For loop, use DataView.RowFilter(string) with the comparison value and use DataView.Count() to check if there is a match or not.

http://msdn.microsoft.com/en-us/library/system.data.dataview.rowfilter.aspx[^]

hope it helps.

这篇关于如何验证记录是否已存在于数据库或列表视图Windows中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！