How to add values for database fields by selecting the item from List Box.

Question

0.00/5 (No votes)

See more:

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

Posted 23-Dec-15 4:15am

sarfarazbhat

Add a Solution

Comments

CHill60 23-Dec-15 10:23am

Firstly I would advise upgrading to a supported language such as C# or VB.NET - VB6 is no longer supported (and has been out-of-date for well over a decade)
Secondly you've just said you want to use a ListBox, so do so. I'm not sure where you are going to get "length and breadth" from nor to what you are referring

sarfarazbhat 23-Dec-15 10:29am

I need to enter length and breadth manually and then save the item purchased, length,breadth and total amount in another table and later print the invoice.

sarfarazbhat 23-Dec-15 10:32am

Sir as for as VB.net is concerned, I have developed a small project but unfortunately I was not able to install it on client computer because that was throwing some database error and I do have some time for that to complete.

sarfarazbhat 30-Dec-15 3:03am

Sir
After a response from you, I tried to deploy my VB.Net project on a client machine but this time using Click and deploy (Publish) method and i was able to install and run it successfully with a couple of small issues but I did not like that method reason being I was not able to find my database file etc.
I would like to install it with setup and deploy method using Visual studio 2010.
My code for connection string is


Imports System.Data.OleDb
Imports System.IO

Module connection
   
    Public Con As New OleDb.OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & Application.StartupPath & "\mydb.mdb")
    Public Dad As OleDbDataAdapter
    Public Drd As OleDbDataReader
    Public Cmd As OleDbCommand
    Public Dst = New DataSet
   
End Module

After creating setup i included the access database but while installing the setup on target machine there is no database and i had to manually copy and paste database file in the client computer.
Second issue is that while creating an account i am being prompted that unhandled exception has occurred.......operation must use an updateable query.
Please guide in this regard.
Thank you

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2015-12-23T04:50:00

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.