搜索访问数据库 [英] search access database

问题描述

您好，我目前正在制作一个数据项目，我想为我的项目寻找一种搜索方法.
该表单具有三个分别名为textbox1，textbox2和textsearch的文本框.数据库具有一个名为tblwords的表和两个分别名为"word"和"mean"的字段. 我想当我单击搜索按钮时，它应该显示一个输入框并从中获取搜索值("word"字段是搜索字段)，它应该在textbox2中显示结果.我使用oledbconnection添加数据库.

Hi I''m currently making a data project and I want a search method for my project.
The form have three text boxes named textbox1 ,textbox2 and textsearch .The database have a table named tblwords and two fields named ''word'' and ''mean''.
I want when I click on a search button it should display a input box and get the search value from it(the ''word'' field is the searching field)it should display results in textbox2. I used oledbconnection to add database.

推荐答案

1)连接到您的数据库.
2)使用以下SQL:

1) Connect to your DB.
2) Use the following SQL:

SELECT mean FROM tblwords WHERE word='TheWordToLookup'

3)执行命令.
4)将结果放入文本框.

哪一部分给您带来困难?

3) Execute the command.
4) Put the results into your text box.

What part of this is giving you difficulties?

您能给我一个完整的代码吗?我试过了，但是我不明白这种方法.

Can u give me a complete code? I tried but I can''t understand the method.

这篇关于搜索访问数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！