如何通过从列表框中选择项来添加数据库字段的值。 [英] How to add values for database fields by selecting the item from List Box.

问题描述

我正在开发vb6中的应用程序并访问2007但是我遇到了一个问题，比如我需要从列表框中选择一些项目，然后添加相应项目的长度和宽度。我不知道哪个控件应该使用网格控件或简单的文本框。



ex：

项目名称速率长度宽度Total_Amount

项目1 100 3 4 1200



我知道项目对应的项目费用将来自访问表，我只需要添加长度&只有广度。



希望得到你的一些想法。

谢谢

I am developing a application in vb6 and access 2007 but I am facing a problem like i need to select some items from a List box and then add length and breadth of the corresponding Items. I do not know which control should i use grid control or simple text boxes.

ex:
Item Name Rate Length Width Total_Amount
Item 1 100 3 4 1200

I know Item rate corresponding to the items will be coming from access table and I just need to add length & breadth only.

Hope to get some idea from you.
Thank you

推荐答案

您不应该在客户端计算机上安装Visual Studio IDE - 您应该构建应用程序并安装它。 .net框架应该已经可以在他们的机器上使用了（假设你没有使用Windows2000或类似的东西）



请记住，如果你打算使用VB6您需要在安装中包含所有运行时组件（一些包含在Windows中，但不一定包含您需要的所有组件）。您的安装程序无法用VB6编写，因为它需要运行运行时组件。 Catch-22。



VB6中的可编辑网格很痛苦。多年来已经有几个第三方产品提供这样的网格，但我不能推荐它们（我已经处理了很多）



我建议使用简单的文本框捕获数据，并有一个提交按钮（或类似的）将数据复制到网格/列表。确保您有一些标签或只读文本框，其中包含行中的其他数据，以便用户了解他们输入的内容。



如果您想发布某些数据库错误的详细信息，那么我们可以帮助您克服它。

You shouldn't be installing Visual Studio IDE on the client computer - you should be building your application and installing that. The .net framework should already be available on their machine (assuming you are not using Windows2000 or something silly like that)

Bear in mind that if you are going to use VB6 you will need to include all of the runtime components in your install (some are included with Windows but not necessarily all the ones you need). Your installer cannot be written in VB6 because it will need the runtime components to run. Catch-22.

An editable grid in VB6 is a pain. There have been several 3rd party products to provide such grids over the years but I cannot recommend any of them (and I've dealt with quite a few)

I suggest using simple text boxes to capture the data and have a Submit button (or similar) that copies the data to the grid/list. Make sure that you have some labels or read-only textboxes containing the "other" data from the row so that the user has some context of what they are entering.

If you want to post details of the "some database error" was then we may be able to help you overcome it.

这篇关于如何通过从列表框中选择项来添加数据库字段的值。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！