如何在Vb.Net中查找/检查我的数据库记录？ [英] How Do I Find/Check My Database Record In Vb.Net?

问题描述

我已经创建了一个数据库，我也将它连接到Web表单，正在输入记录，我收到了确认消息，现在我想知道如果他们真的如何/在哪里可以看到记录已进入。我在MS Access中创建了一个数据库，如果我搜索它没有显示任何内容，那么请告诉我如何查找记录的数据。我在Microsoft VB中创建了一个ASP.NET Web表单。

解决方案

从小处开始：设置数据库的副本，但是（其中）有五个记录 - 删除所有其余部分。

然后运行你的应用程序并添加一条新记录。

关闭你的应用程序。

使用Access打开你的数据库，看看它掌握的所有记录。

是5吗？或6？

如果它是6，只需检查数据是否正确并在正确的字段中继续前进。

如果它是5，那么你需要仔细观察您使用的代码并确切地检查它正在使用哪个数据库以及它是如何工作的 - 我们不能为您做到这一点。



当数据进入表格时，将代码添加到应用程序以在DB上运行SELECT查询：

  SELECT  *  FROM  MyTable  WHERE  MyColumn = ' 你输入的价值' 

看看返回的结果。



但我们不能做任何事对你而言：我们无法看到你的屏幕，访问硬盘或阅读你的想法！ ：笑：

I have made a database and i have connected it to the web form too, and the records are being entered and i am getting a the confirmation message, now i want to see how/where i can see the records if they really have been entered. I have made a database in MS Access and if i search that it shows nothing, so please tell me how to find the recorded data. I have made an ASP.NET web form in Microsoft VB.

解决方案

Start small: set up a copy of your DB, but with (say) five records in it - delete all the rest.
Then run your app and add one new record.
Close your app.
Use Access to open your db, and look at all the records it holds.
Is it 5? Or 6?
If it's 6, just check the data is correct and in the right fields before moving on.
If it's 5, then you need to look closely at the code you used and check exactly which DB it is using and how it works - we can't do that for you.

When the data is going into the table, add code to your application to run a SELECT query on the DB:

SELECT * FROM MyTable WHERE MyColumn='value you just entered'

And look at the returned results.

But we can't do any of that for you: we can't see your screen, access your HDD, or read your mind! :laugh:

这篇关于如何在Vb.Net中查找/检查我的数据库记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！