How can I sum up listbox value but the value I want to sum up is the one i multiplied. The q variable. look at my code. I want the sum of all Q variable in the textbox.Disregard the variables declared because I was trying to get some experiment but failed so some previously variables used left ,I did not clean up my variables.[code]
View 9 RepliesI am trying to add numbers. So if there are 2 numbers in a listbox, theyare summed up. If there are 3 numbers in a listbox, they are summed up
[Code]...
What I'm trying to do is to count the number of items. Then I start my counter at 0. For each time the counter goes up, I add another row from the list box. and loops until my counter reaches the number of items in my listbox. I'm stuck intTotal. The only way I know of adding the totals is lstCosts.Items(0)+lstCosts.Items(1)+lstCosts.Items(3). But what if the user enters 4 numbers? I can't find a way around that. I think this should be a very simple question and I think only this line needs to be changed.
i have a combo box with grade A to F in it and at the combo-box textchange event it sholud add the value of each letter to and store it in a textbox.This is because i am adding all the grades of a student into a datagrid and i want all the 8 different grades to appear in the grid but it should some only the first selected six out of the eight...I am using this code but it is not stop when the loop counter is six?
Private Sub cmbgrade_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbgrade.SelectedIndexChanged
If Me.cmbgrade.Text = "A" Then
[code]....
So with this code any time the user selects any of the Letters it should at it value to a tatal aggregrate till it add six different letters since i want to calculate for the grade of best six...example if user picks A A A A A A it should some up to six in the textbox and after that it should stop summing and add to the datagrid.that datagrid will have all eigth grades in its column but the system must add only six of them?
I have an underlying dataset for my datagridview which it is bound to. I've done most of the DGV code programatically.
I'm calculating quantity x Price and displaying it in a cell like this, which works well:
Private Sub DGVAdviceDetail_CellFormatting(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles DGVAdviceDetail.CellFormatting
[Code].....
I have a large matrix, aprox 600x300 and want to divide it up into 6 sections across and 4 vertically and then sum the corresponding areas of the large matrix based on this division. To clarify all the numbers in the top 100 x 150 area of the matrix would be summed to give me the first number in the next matrix. I've tried playing with some code but its not giving me what I expect and I'm unable to figure out exactly why. I'm sure there is a more efficient way to do this but I'm unable to find it.
Array1 - original large array
Array2 - new small array
y and x count are the new coordinates of the new array
[code]....
I have to generate a series of random numbers, say 100, within range of -1 and 1 and scale them by a value, say square root of 2. After which I take those 100 values and their sum = 0. Then scale that sum by another value. Check the code below to see what I mean.
[Code]...
I'm have trouble summing a datagridview computed column. I can sum other columns in the DGV. Is it possible to sum a DGV computed column and have the result shown in a textbox elsewhere on the form? I have BindingSource with an End Date Column and a DaysLate computed by column. The calculation is in code and works fine. I now need a total days Late TextBox under the DGV days late column
View 2 RepliesI am reading a textfile and extracting information from each line. For example string1 and string2. I am then writing these string to a datatable. However, sometimes there will be repeats in string1 and string2. If there are repeated lines I would like to be able to delete the repeating line and add a counter to find the total number of repeating lines. so if a string repeates 3 times I would like there to be a column with a 3 displayed next to the line in my datatable.
View 3 RepliesI have a dictionary that has strings variables as keys and a List collection of doubles as values.
Dim CellAddressContainer As New Dictionary(Of String, List(Of Double))
Dim Results As New List(Of Double)
Within a loop I populate the Results variable as follows:
[code].....
Trying to work out if there's a nice way of doing this, preferably in Linq rather than loops, which is what I've done for now.
I want the number of days my Product is active between two dates.
Product has many ProductHistories, ProductHistory has values for DateActive and DateInactive. DateInactive can be null, and often will be, to show that this history is ongoing. Histories won't overlap.
I want to sum the maximum of my startDate or the ProductHistory's DateActive, and subtract that total from the sum of the minimum of endDate or ProductHistory's DateInactive (endDate by default if DateInactive has no value).
Worked example:
Get active number of active days between 2011-01-01 (1st Jan) and 2011-02-01 (1st Feb)
Histories:
Active 2010-12-25 : Inactive 2011-01-05
Active 2011-01-15 : Inactive 2011-01-20
Active 2011-01-25 : Inactive null
[Code]....
I'm creating an array of textboxes using this code, (x number of textboxes)
'Quantity textboxes
ReDim QuantityTextBoxes(x)
QuantityTextBoxes(x - 1) = New TextBox()
[Code]....
I need to sum the values of each textbox, but only if there is a value in it. I have error checking elsewhere so that isn't the issue. It keeps giving me an error saying "Object reference not set to an instance of an object."
I am working on a sale report program. Its purpose is to record the new item and the amount made from the item mon - fri. My problem isn't getting the total. I am using a For..Next to do this. The problem is that everytime i add a new item it changes all of the previous items weekly totals as well. Thus throwing off my Total Sales. My initial suspicion is that since i don't have it added as part of the output i display it changes and re-adds it to all old items.
The section of code below is the area where i believe my problem is.
The Array itemNames holds 10 elements for the Items sold.
The Array itemSales holds the weekly price data.
' add item to listbox
For counterItem = 0 To itemCount Step 1
[CODE]..........................
I have a List<Object> where Object contains Name, Month, Type, Value.
is it possible to sum all the Value based on type, and then based on month?
I am using .NET 3.0 in VB.NET I was doing withe like 4 For loops, but its taking a while to run.
For clarification, I have something like this:
Name | Month | Type | Value
-----------------------------
hello | Jan | A | 1
hello | Jan | A | 2
hello | Jan | B | 2
[Code].....
I Have a Datagridview, with a column containing integer values. Is there any way to make a fast sum of all items in the column?Something like a SUM function in SQL.
View 12 Replieshow to best go about this project. I have just been given the task of creating a program that will primarily be used to import and sum a excel or text file that is tab delimited. As a quick example the file would be in the following format:[URL]The problem is that I would need to store this information locally (unless you know better) because I need to be able to append information to this from a second (or third, fourth, etc...) file and re-sum it, lets say that this is the second excel file that I needed to sum:
[URL]
I would have to append the week5 and week6 columns and add the Neapolitan row to my summation. This program will then format the sums into a list of the different flavors and the sums of all products sold during the total weeks and output to a text file.I have informed my employer that it would be easiest to do this with a VB script in excel, however, they are adamant that they want this done in VB.NET with a GUI.
I have tried several means all to no avail. how sum items in the column of a listview
dim lv as listviewitem
lv=listview1.items.add(txtscore)
lv.subitems.add(txtunit)
lv.subitem.add(grade)
I have suceeded in adding scores, unit and grade to the listview and i dont know how to sum the total unit in column 2 and how to get point to calculate the gpa
If I set a ListBox.Height = ListBox.PreferredHeight when the control is hidden and IntegralHeight = True, then set it visible:
a) Actual Height reduces by typically 3-5 pixels after redraw (but not 1 pixel per item).
b) PreferredHeight does not not appear to give the correct integral of item heights.
Is there a way to make ListBox calculate the correct integral Height before the ListBox is made visible, so it can be correctly pre-positioned from bottom edge?
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ListBox1.Visible = False
ListBox1.IntegralHeight = True
[CODE]...
This code bellow to compile a single listBox on form1 to listBox on form2 then listBox on form3.
I want to modified this code to compile 169 of ListBoxs on form1 to 169 listboxs on form2
and 169 listBoxs on form3.Try this code,not need the new coding.
Original code from JoOl and modified by John Anthony oliver
[Code]...
1 when my listbox returns resaults it only brings back 10 how do I set it to return lets say 500
and question 2 is when I click on my links in listbox it's not opening webpage as I would expect it...
This is my code
[Code]...
I am using VB.NET (version 2008). I have two types of items populating in a listbox (checked listbox). For example: lets say one is type "A" and other is "Type B". Their names maybe same so if the user sees those items in listbox then he won;t be able to determine their type until he click on them and checks out its properties. I wanted that I add each item to listbox and colour them so that blue for example means type "A" is there and red means the other. So this way I will be able to know at a glance that how many item of what type is present. I guess it may not be possible to do that in a standard checkedlistbox. I am also using component factory's krypton controls which enhance the gui of an application. But I dunno if I can progress using that.
View 5 RepliesThe scrollbar that comes with the ListBox is too small for touch screens, so I use my own scrollbar instead. But when you do this on various forms you end up repeating a lot of code. So my solution was to create a custom scollbar that has a property I can set to the control I want it to be a scrollbar for. In vb6, I can use the withevents keyword to get access to the control's events so that all the scrollbar related code can be in the custom scrollbar object I created, except...I had to create a refresh method for the consuming code to use to let the scrollbar know when the number of items changes. The scrollbar doesn't need to be told how many items there are because it has access to the control, but for a listbox there is no event to tie into when an item is added/removed so not 100% of the scrollbar related code could be encapsulated.
View 2 RepliesIs it possible to select an item in one listbox and then display the data of another listbox with the same indexed position? I am planning a project and this is something I would like to attempt but I haven't figured out how to do it.[code..]
I tried doing the above code but instead of displaying the listbox text the message box just returned false.
I am using Visual Basic 2008 Express Edition and I am trying to set a listbox so it starts to scroll when it hits the middle point of what is viewable on my list. I also want to set it so the list is always visible so you when you reach the bottom of the list you can scroll down to the bottom but if you scroll back up once it reaches that middle point it will start to scroll up again.
View 2 Repliesproblem that i am facing is i want to add array of object as a single item in listbox. in vb6 i was using this Label1.Caption = Label1.Caption & Mid$ (strInput, intI, 1) & " " List1.AddItem (Label1.Caption) i was using label. caption to store object but not work in vs2008 because label.text only take text and left other values
View 18 Replieswhat it does iswhen a user checks an item in the checked list box it transfer it to a listboxso i have a checked list box and a listboxi am planning to put another listboxwhat i would like to be able to do is thatwhen the user checks an item on the checked list box it will transfer the item into the listbox [like the one on my previous thread]and be able to show an messagebox with a textbox [ i read its called an input box ] or another form with a textbox and/or combo box will pop up
View 13 Replies I am starting to learn reading and writing to textfiles. One quick problem. My code here
'Read is the variable that will read the kp.txt file"
Dim read As IO.StreamReader
read = IO.File.OpenText("C:2/kp.txt"[code].....
however when it is read into the listbox those 3 words appear on one line in listbox
How can i make it so that each line of the textfile is placed in each line on the listbox?
I am having problems with copying from one listbox to another and keeping the paths of the files in the listbox's. At the moment i have two listbox's, listbox1 shows the list of files without the directory paths showing. Listbox2 is used to add items from listbox1 which work ok but what i need is to be able to preserve the directory paths to each file. how to do this and have searched high and low for a solution without any luck.
I have worked out one way of doing it but i think there is a better way of doing it as the reverse does not seem to work. So basicly i want listbox1 to list the files without the paths and pass it on to listbox2 so that the files can be copied to temp directory as they are being add to listbox2.
Below is my
[CODE]...................
Routine to add items from listbox1 to listbox2: I have created another listbox3 (which is in bold), which is hidded under listbox1 and holds all the paths to the files and is use to copy the files from there original directory to a new directory.
[CODE]...................
Routine to add items back to listbox1 and remove them from listbox2. I have created another listbox4 which is hidden under listbox2 which i was trying add the paths from listbox3.
[CODE]...................
I enter Names and scores from a text box. Once i press "show me the array" my listbox gets populated with the names and scores. [code]...
View 14 RepliesI have a question here.. pls kindly advise.I need to design a simple form that allow user to choose the value from Listbox A to Listbox B. For example, in Listbox A, have value A, value B and value C, then user can choose (or highlight value B and value C) and copy into the listbox B.
May i know how can i do this in vb.net? Any reference link?
i successfully load data from database to listbox, what i want to do is to add a record and then directly the listbox will update as well as in the delete.
[Code]...