Database-table That Contains Two Columns / Items And Price Of Each Item
Jun 5, 2011
I am currently using microsoft access 2007 and vb.net 2008. The problem senario is this: I have a database-table that contains two columns, items, and the price of each item. I tried to drag this table to the form as a checkbox tool, but only one checkbox1 was diplayed. The table consists of four rows. My requirement is when I drag the checkbox I want to see the all items in the first column, i.e. four checkboxes that hold the same name as in the table in the database, and when I check one or more items to be able to use, in somehow, the price(s) to make some kind of calculations.
View 1 Replies
ADVERTISEMENT
May 25, 2012
Regarding my college project. i'm working on a sales system . i have a form which consist of all the following information( item code , item name , item price , quantity of item ) which is display using a data grid . data input by user using text box and all this information will be stored in a database(sales database) i'm using ms access 2007. the grand total will be displayed in a text box . and amount paid will be input in a text box too , my major problem now is how to i create a reciept that will have all this information of the purcase. i have a reciept button . what the next step ? i dont have any idea how to get the reciept done.
Imports System.Data.OleDb
Public Class Form5
Dim con As New OleDbConnection
[CODE].......................
View 9 Replies
Oct 13, 2011
How someone would select an item from a list box and click a button and have that item go into another listbox with it's price? I seem to be stuck on this part.
Here's my code:
I want to select the first option from the first listbox and I want to put it into another listbox along with the price of that item on the same line in the listbox. I can't seem to figure out how to that.
Public Class Form1
Const dcmPRICE_STRESS As Decimal = CDec(595.0)
Const dcmPRICE_TIME_MANAGMENT As Decimal = 695
[CODE]...
View 12 Replies
Apr 28, 2012
I want to get all items from one column of database table to the combobox items.
View 2 Replies
Mar 23, 2010
I created a database in my project, and added a table and some columns to it. Now after making several changes to the program I decided to add some more columns, but for some reason those new columns don't show up in the SQL query builder or the database explorer. I realize that this is an oversimplified explanation
View 4 Replies
Jun 27, 2009
-in my database..there are 2 tables..
1)Leave_application
2)Staff
-how do i type the code to minus out the number from "Leave_balance" (in the Staff table) with the number from "Days_apply" (in Leave_application table) eg: 10 days (from "Leave_balance" Staff_ID "S0001") - 2 days (from "Days_apply" ID "abc") = 8 days and then update the "Leave_balance" of staff_ID "S0001" with 8 days
View 3 Replies
Jun 28, 2009
-in my database..there are 2 tables..
1)Leave_application
2)Staff
-how do i type the code to minus out the number from "Leave_balance" (in the Staff table) with the number from "Days_apply" (in Leave_application table)
[Code]...
View 3 Replies
Aug 6, 2010
I'm reading "Programming with Microsoft Visual Basic 2008". At the end of each chapter there is excersize that I don't have the answers sheet for. Anyway, the first one is:
A procedure needs to store an item's name and price (which may have decimal places). Write the appropriate Dim statements to declare the necessary procedure-level variables.
What I have so far is:
Dim "Candy" as String
View 7 Replies
Nov 12, 2010
I am writing a program that uses an array of structures to display a price in a label based on what item is selected in a list box(the data is stored in a text file). I am having trouble figuring out how to make the price corresponding with the item appear in the label. Currently, it just keeps showing the last price in the text file.
CODE:
View 12 Replies
Mar 12, 2012
I am struggling to write the code for a calculation. The calculation I wish to do is to multiply the quantity of an item by the price. The problem is that the "form" i am creating uses a letter (i.e A, B, C etc) which corresponds to a set value. I do not know how to link the Letter to the corresponding value.
For Example, A= 25, B= 20, C=25
I want to calculate the total of 6 lots of A. I am also using a Combo Box to list the Letters.
View 2 Replies
Apr 18, 2009
I loaded up a checkedListBox with items form a .txt file. The .txt file has itemName, ItemPrice. Every item that gets checked shows up in a listBox on another form. The problem that I am having though is that I need to accumulate the itemPrices of the selected items to show up in a textBox, but the only price that shows up is the price of the item in the checkedListBox that has the focus. I'll add the code to this:
Public Class Form3
'define the Product structure
Structure Product
Public itemName As String
Public itemPrice As Decimal
[Code] .....
View 8 Replies
Mar 30, 2009
Anyway, i have a list of products in a product table. Primary key 'id', and 'Price' is a float(all variables defined at the top - cut main code out)
objConnect = New OleDbConnection
objConnect.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=|DataDirectory|Ecommerce.accdb;"
[code].....
View 2 Replies
Aug 13, 2009
I have to create a program where you enter the description, price, and quantity of an item, then click on the Add button. It will then put the description, price, quantity, and total for that line (including tax) in a listbox. The tax is determined by what you put in a text box labeled tax:. When you press Submit Order, it should show a grand total in a text box called Grand Total. It should have a class that is called Items that has a function called GetTotalAmount() that figures out the total including tax. I have started it, but am having a tough time with how to get the subtotals into the text box, then also show the amount including the tax PLUS then do the grand total.
Heres what I have so far:
CODE:
View 3 Replies
Jan 12, 2010
I have 22 item in combobox which i want place in one table. Why the code below do not work? [Code] I try learn database program but the code add first combobox item 22 times! What wrong with concept I use?
View 6 Replies
Jul 13, 2010
In my application, I've built an object that communicates with an OPC server and whenever the value of a certain OPC item changes, it logs all the OPC items to a database. This all works beautifully. However, I'm having a problem with disposing of the instances of this class. Whenever I want to remove an instance of this class from the application, I'm dereferencing the object (objDevice = Nothing) and letting GC take care of the rest. I've inserted breakpoints and am monitoring to ensure that the object is dereferenced (it is).
Problem is, even after the object has been dereferenced and is CONFIRMED to be equal to Nothing, the object is still logging data to the database. I'm still trying to get a handle on disposing of objects properly, but most everything I read tells me to dereference and let Garbage Collection take over.
View 5 Replies
Aug 18, 2011
I have Dataset ds filled up with values Until now I was displaying values in GridView. Now I want that all the rows should be columns and columns should be rows.I have 2 options: Either 1 I can directly convert grid to columns and display it, or 2 I can convert the GridView to html and then write loops to convert. I was trying the 2nd option but I cant figure out how I should do that.[code]With this code I am still getting same as GridView. Please help me for converting rows to columns and vice versa.
View 1 Replies
Oct 26, 2011
I'm using VB.net 2005. I have working programs that I populate DataGridViews with something like the following:
[Code]...
View 6 Replies
Nov 25, 2011
I am new to vb and I am having so much trouble with this. What I need to do is this: I have a form application for winter sports equipment rental.I have a listbox filled with the equipment for the user to choose from then I have a combobox for the user to select the duration they would like to rent it. The book that I am using has no examples I can refrence and i have had no luck online either. I am posting what I have so far. However, i think I am going in the wrong direction. I have been working on this for so long that I think I have over thought it and made a mess of it. I am thinking that I need to add a new class for rentalRates then use enum of durationType and equipmentType but I am unsure how to move that way. That is using a enum, a 2d array and a parallel array? [code]
View 1 Replies
May 23, 2011
Imagine the following scene: I have one table which have tree columns (ID, Number, Name).
A Select query result on this:
code:
Now, the user deletes the Number 3 and 4. So, now the Select query is going to be:
code:
And I want to have:
code:
How can I organize the column?
View 14 Replies
Sep 7, 2009
i have imported names from database table into combobox..i want to add item"all" above all names..how can i just add one single item in combobox after populating it form database tabel.
View 1 Replies
Feb 15, 2011
each of the ToolStripMenuItems has more than 20 ChildItems and each of these ChildItems have more than 30 ChildItems.In my form I havea login form and each user must log in.I want to know that how can I check my UserAccess Table with these MenuItems and ChildItems names and if the user does not have the MenuItem or ChildItem name in UserAccess Table, the MenuItem or ChildItem must be disabled.
View 16 Replies
Feb 21, 2011
I've the following code which successfully makes an average for all the columns from a table. What I need to do though is ignore certain columns in this equation.
Dim totalNumber as Double = 0
Dim count as Integer = 0
For x = 0 To xyz123.Tables(0).Columns.Count - 1
[Code]....
View 2 Replies
Feb 28, 2010
Averaging columns in a table - ignoring certain columns
View 2 Replies
Apr 14, 2009
Visual studio 2005 - vb.net..I have a user control on a form containing 15 combo boxes.All contain Y, N, and blank (for Yes, No, or blank) in the Items Collection property.Each of the combo boxes have a binding source to the same table, different fields.When you select a value Y, N, or blank for any of the fields and do a save, the values save while the application is open.Once you close and reopen, the values are gone.It appears the dataset does not recognize the change, so the values are not getting stored in the database table. Is there something I can do or put in one of the events that would identify this as a change.
View 3 Replies
Jan 24, 2012
PHP
Public Class GasPump
Private name As String
Private quan As Double
[Code].....
I get problem in the code when you going to pick y/n. how i going to get the price of the premium or Regular in Price per unite?
View 7 Replies
Aug 23, 2010
I have two tables Employees and CafeLogs. Some employees can be cashiers and also customers at the Cafe shop.
Table structures:
Employees: EmployeeId(PK) , FirstName, LastName
CafeLogs: LogId (PK), CashierId, EmployeeId, Value, => CashierId and EmployeeId are the data from column EmployeeId of Empoyee table
Table relationship:
Employees 1:N CafeLogs (CashierId (FK))
[code]....
Right now I know how to select only LogId, Employee's name, and , Value, not with Cashier name yet.
Dim query = From log In db.CafeLogs _
Join emp In db.Employees On emp.EmployeeId Equals log.EmployeeId _
Select log.LogId, emp.FirsName, emp.LastName, log.Value
View 1 Replies
Apr 17, 2012
I have a form as follows "Price changer" The user is allowed to select a product and enter price . So when the change price button is clicked...the price is stored in a array which is later called
So what i am stuck is when the user selects a product from the drop down menu...the user can enter price . But i need to display a error message when the user enters text instead of numbers for prices. I tried try parse method but it displayed the error message but did not transfer the entered price to the array.
My code is as follows
The bolded intMediaprice() are arrays....
Private Sub btnPrice_Click(sender As System.Object, e As System.EventArgs) Handles btnPrice.Click
If cbMedia.Text = "8-Track" Then
[CODE]...
View 3 Replies
Jun 13, 2012
My problem is with the tickets table, I have listed the user that created the ticket, the tech who will solve the ticket and a user that over sees the ticket. All three users reference the users table. So how do I can I query the tickets table and get all three users that reference the same table storing the users?
Table1: Tickets
1) Ticketnumber
2) EnteredBy User 100
3) Issue
[code]....
What I can do now is something like this:
Select Ticketnumber, EnteredBy, Issue, UserName FROM Tickets INNER JOIN Users
ON Tickets.EnteredBy = Users.UserID
View 3 Replies
Oct 15, 2009
I am using the following code to alter an table imported from an Excel spreadsheet
Dim SQL As String = "ALTER TABLE receipts ADD payee integer, account integer, category integer, reconciled boolean"
Dim dataread As New OleDb.OleDbCommand()
dataread.Connection = Connection1
[code]....
Both ExecuteNonQuery() actions yields the exception message {"Syntax error in field definition."}The error message does not happen with the first if the boolean column is not there (I tried Tes/No as a definition - but that also failed.The second query to modify the ID column from autonumber to integer I assume fails because it is a Primary KeyHas?
View 1 Replies
Nov 15, 2011
I have to create a form that I enter the price of gas each month over a year. I enter the price in a text box and click the enter button to send the price to a list box immediatley and use an array. I have the following code but I don't think it's working with the array correctly as it will let me enter the information but doesn't stop letting me enter after the 12 prices. I am really having a hard time trying to figure out how to set up this input for an array and make it all work.
[Code]...
View 1 Replies