I have a Datagrid with 4 columns. Column 1 is ID, Column 2 is Products, Column 3 QTY, Column 4 Price and Column 5 is Total. I would like to get the Total of Column ID if it has 3 of the same ID and the Column 3 Price is $10.00 ea. Then on the Coulumn 4 Total get a result of $30.00.
View 3 RepliesI Have a datagrid with Item, Description of Item, Qty and Price.I would like on the 1st txtbox display subtotal depending on the quantity, price and add a tax textbox and the subtotal all from the datagrid to to those textboxes.
I already have all of that on my table of Products.
The program is for calculating an amount of fruit. I have a label saying the name of the fruit, a textbox to enter a value of 0-99 and another textbox with ReadOnly which will show the price.
A little picture here:[URL]
As you can see, the Fruit1 Etc... Is only the fruit name.
The Text box wich indicate 1-99 means the number of fruit.
The Textbox with Cash on it, means the total price.
The Calculate button, when I will push it, all the total price from all the fruit will be added together to form a total price which will be indicated in the total price textbox under the Calculate button.
When I will enter the number of fruit, if I enter 99, it give me a price.
When I will enter 60, I want that the 60 are multiplied by (let say) 0,10$
I just like to know how I can do this... Its really bothering e and I don't want to calculate all the things and make 99 line for 1 fruit cause it will be long.
The code I was using was:
Private Sub TextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If TextBox1.Text = "99" Then
TextBox2.text = "10.00$"
Elseif TextBox1.Text = "98" Then
TextBox2.Text = "9,90$"
EndIf
End Sub
Until the the number of the fruit in the code reach 0. So its very long.
I have a form with check boxes and behind the check box i assigned it to a const Price. I have a Total Label box and I want to check to check boxes and add them to the total label
View 1 RepliesCombine and Add the Quantity of same index in listview here's my Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click If NumericUpDown1.Text = "" Then
MessageBox.Show("Please Input the Quantity!", "Sale", MessageBoxButtons.OK, MessageBoxIcon.Exclamation)
NumericUpDown1.Text = 1
End If
[Code]...
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] .....
If i had a structure and a list of the structure like this [code]Using Linq, how would i get the total sum of the saleprice from the list but the solddate has to be within 2 given dates.
View 2 RepliesI 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]...
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 RepliesPHP
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?
I am trying to count all the rows on a datagrid after it has been populated from my DB. I have searched online on how to do this but nothing seems to work.[code]where test is my datasource it gets thrown into
View 1 RepliesProtected Sub invokePagination(ByVal table As DataTable)
'CallPagination() As PagingControlDTO
If table.Rows.Count > 0 Then
Me.DataGridPaging1.Visible = True
[code].....
The code which is underlined is to be replaced.Instead of this I want to use column name to get the total count , since it contain the total count.Column Name is "TOTALROWCOUNT"
I am trying to filter a datagrid based upon stepping through records and suming the contents. What i am trying to do is get to select records that equal (or if the sum of records exceed the entry they revert to the previous record) or less than the entries specified in a combobox on a form.
View 9 RepliesHow can I produce a total for values in a datagrid and them display them in a label?
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]...
I was wondering the best method or code to Sum\total a bunch of cell values of an unbound column in a datagrid to a textbox string. this request is 100% genuine...im not some student trying to get you guys to finish my project, this is purely for educational and personal information for myself. im new to vb.net.
View 2 RepliesI need to create a simple program that will calculate de price of the meal+the taxes aswell as the tip.
The prov taxe= 8,5%
the fed taxe = 8%
and the tip is 15%
I need to use const for this one.heres what i came up with:
Private Sub partie4_click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles partie4.Click
Dim repas As String
Dim sous_total As String
[code]....
The user has to type the price of the meal and then it should calculate the price but for some reason instead of *8,5% it will do x*8.5.
i am doing a small project for my business and i got stuck with this 2 weeks ago and still no progress.I have an access db table "store" that has columns: (filldate,brand,model,plateno,mileage,litres) where i am storing these info each time a car in my company fills gas. For example8/25/2011,Renault,Megane,5487844,3943,20).What i want to do now is to display in a datagrid the total consumption of gas (litres) with the kilometers driven (mileage) between 2 dates.
View 2 Repliesi'v started learning visual basic on a software development college course and i have to make a program which outputs a price of something into currency only when i click on my calculate button it only comes out as a whole number so instead of �1.00 it just says 1, this is my output code.
qty = txtQty.Text
money = 100
If lstItems.SelectedIndex = (0) Then
[Code]......
How do I code the total cost to give me a pound sign with the total cost at the moment when the total comes up for an example it gives me 3.6 when I need it to show £3.60 here is the code I have so far. [code]
View 2 RepliesThe pay rates for the project are:
a. Level 1 - $10.00
b. Level 2 - $12.00
c. Level 3 - $14.00
d. Level 4 - $16.00
e. Benefit Deduction Rate - 0.10
f. Overtime Factor - 1.5
For ease of program maintenance, all of the above rates and factors must be stored in module level constants. All references to pay rates in the program must refer to the module level constants.
When the Calculate button is clicked:
a. The value in the Hours text box must be validated to insure that it is numeric value greater than zero.
1. If the value is not valid, a message box must appear as shown below and the user must be offered the option to continue processing or quit the program.
2. If the user chooses to continue processing, the focus must be set to the Hours text box.
3. If the user chooses to quit, the program must close immediately.
b. If the value is valid, the program must calculate and display the total pay in the Total Pay label.
1. The pay rate is determined by which Job Grade radio button is checked.
2. For hours less than or equal to 40, the total pay is the hours times the pay rate.
3. For hours greater than 40, the total pay is 40 hours times the pay rate plus the hours in excess of 40 hours times the pay rate times the Overtime Factor.
4. If the Full Time radio button is selected, the total pay must be reduced by the Benefit Deduction Rate.
5. The value displayed in the Total Pay label must be formatted with a dollar sign and with two decimal
places.
6. The focus must be set to the Hours text box.
Why i get an error when i try to run this code
Code:
Also the message box, both yes and no close the program.....
I am working with VB 2008. I want to be able to run this program say in N: and it will show me in an excel sheet the following:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
where clients contains subfolders and files and the size is the total of all those files within each folder and the count is the total within each folder also.
This works fine as it is but i have to select one by one the top level folders and some of them are huge so it takes forever to give me an answer.
1) I would like to see in my spreadsheet the following by only select the network drive n:
Folder Path Size(GB) Count of Files
N:Clients 0.53 308
N:Software 10.7 15430
N:Billing 0.98 105
2) I would also like to know if this is the faster method.
3) I tried adding a progress bar so that the user can have an idea of how much this will take but i had to remove because it was not working.
4) I would like to see the folder name, size of folder and count of files in the listview.
Here is the code:
Imports Microsoft
Imports Microsoft.Win32
Imports Microsoft.Win32.Registry
Imports System.Collections
[code].....
I am using visual basic 2008 amd creatomg a datagrodview format like below [code] Now I wnat to get total balance in total column after less discount in percentage with ENTER EVENT proceedure and get the whole total column balance in a textbox i.e Net BalanceTextBox. Please tell me how to calculate discount in percent % and get total in total column and also tell me how to move cursor in next cell instead of bottom row in datagridview.
View 2 RepliesI have 3 columns in a unbound datagridview, "length" "height" and "Total". Total = length x width and the final total in TextBox outside of the Grid. I found question simalar in this forum and tried the code but i am getting errors.The following is the code i am using
Public
Class Form1
Dim UnboundColumn[code]...
[Code]...
this is my code right now i want to make it so that it will keep adding the total. meaning if i get an answer then get another answer i want both of them to add up and show.how can i change it so that it will do tat??
I want add a Total textbox to every form.The total will add the values that will be entered in the montant textbox. So the total will take the specific value of that texbox for all the entries that the user will have and add them. How I can do so?
View 15 RepliesI have created a little backup script to backup users files, and incorporated a little progress bar.The backup script backs up 5 main directory's on the users PC.Is it possible to have the status bar display total time for each individual directory? instead of each folder within a directory? [code]
View 4 RepliesI am having trouble trying to add the grand total arrays of number of passengers and the total cost into the list box...the way I have it right now it says for each city whatever the amount that was chosen in the combo box last and same thing with the price. I am thinking you have to use a loop of some kind to sort through all the cities and add them up individually.
Option Strict On
Public Class Form1
Dim decCostPrice As Decimal
Dim intNumbOfPassengers As Integer
Dim decFinalCost() As Decimal
Dim intFinalPassengers() As Decimal
[Code] .....
I have a text box in form1 that displays the total, I want to carry this over to form 2 into another text box as I navigate between them, how would I do this? Also I have a button on form2 to return to form1 but I need all the data that has been input by the end user to be cleared from both forms when returning, again how would this be completed?
View 8 RepliesI'm maintaining a Accounting program.. I have a Cash Book Table in SQLserver Databse...field are DATE DESCRIPTION DR CR RT(Running Total is empty record). When in Insert a transaction into that Table the Running Total should give the correct balance for example :
Date Desc Dr Cr RT (Running Total)
1/1/2011 Cash Balance 5000 5000
1/1/2011 Purchase 2000 3000
[code]....
I'm inserting record into that table through Windows form.