使用vb.net检查Access数据库的列中是否存在现有值 [英] Check if there is an existing value in a column of Access database using vb.net

问题描述

关于我最近的问题，我认为这将是一个更具体的问题:
如何在访问数据库的列中存在 vb.net (仅限于我是一个初学者并且不了解其他编程语言)(如果我是初学者，并且不了解其他编程语言) >?

香港专业教育学院试图搜索，但答案只能使用其他语言，并且正如我说的，我是一个初学者.我的意思是我可以理解逻辑，但是我没有足够的知识将翻译成vb.net.

伙计们，请帮帮我!!!

hi guys, as for my recent question, i think this would be a more specific one:
how can i check using vb.net(only, as i am a beginner and do not understand other programming languages) if there is an existent value in a column of an access database?

Ive tried searching but the answers are only available using other languages and, as ive said, i am a beginner. I mean i can get the logic but i dont have enough knowledge to translate them into vb.net.

guys, help me please!!!

推荐答案

编写如下所示的选择查询

Write a select query like below

SELECT * FROM [TableName] WHERE [ColumnName]='ColumnValue'

使用OLEDBCommand对象的ExecuteReader或ExecuteScalar检查数据是否存在
在这里检查此线程检查记录是否已经存在 [ .NET代码转换-转换代码 [

Use ExecuteReader or ExecuteScalar of OLEDBCommand object to check the data exists or not
Here check this thread Checking Record Already exist or not[^]

For Code conversion(C# to VB.NET or etc.,), check this blog post.
.NET Code Conversion - Convert your code[^]

Dim dataImSearchingFor as String = "What I want to Find"
Dim expressionString as String = "ColumnName LIKE '" & dataImSearchingFor & "'"

Dim DR() as DataRow = dataForm.DataSet.Database.Select(expressionString)

if DR.Length > 0
 ''' Items Found!!
End if

这篇关于使用vb.net检查Access数据库的列中是否存在现有值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！