I was thinking of using a datagrid for calculation. Lets say I want to order several items from a supplier. I just fill up the details row by row, insert the quantity and the price for each. For each row, there will be a subtotal (multiplying quantity by price) and the end it should give the total. Can we achieve using data grid or is there another way to proceed?
View 2 Replies
I need to store a calculation to use later and obtain a new calculation
[Code]...
I am trying to speed this calculation up because I need it to run every time a textbox or a checkbox is changed within the program. My issue is that it runs so slow that there is a lag between changing the text or checking a checkbox and the actual completed calculation.
Sub CalculateP1LoanAmount()
On Error Resume Next
'create the variables for the calculations
Dim P11stPV As Integer = 0
[CODE]...
I have 5 textboxes named as txt1, txt2, txt3, txt4, txt4. Only numbers are allowed in these fields. I have another textbox named txtSubTotal which is calculated (SUM) from the values entered in the above five textboxes. What is the best way to calculate totals when numbers are entered or modified in any of the five textboxes?
View 2 RepliesI am a newby with VS and I am busy creating a golf scoring program. I am struggling with calculating the actual handicaps. I know the formula to do the calculation. I just do not know how to implement it in VS. I have a access database that has all the info. I have score, golfers and golf courses tables. I am trying to use my scores table to do this.The columns I will be using is Golfers, Score, differentials an Handicap to do my calculation.
I need to be able to use the last 20 scores input for each golfer and out of those I need to use the best 10 scores out of the 20 for each golfer. The formula is as follows if done manually : get the average of best 10 scores and multiply it by 0.96, the result is your handicap rounded to no decimal. Do I do this in access with queries or in VS?
I am making a quote calculation program with Visual Basic. Per quote there can be multiple parts/products.
What I want now:
1) insert productinformation (dimensions, quantity etc.) in one form
2) write this data into a table or something
The program then needs to calculate prices etc. but first it is important to get the data right for the calculation.
What I am thinking of myself is putting the data into textboxes and then let this data be transported to a table and have one product per line in that table. from this it can be calculated
I have a program that I wrote in vb 2010 that keeps track of employee times in a database. It figures hours worked based on a range of dates selected using two DateTimePickers.I have it successfully working at this point to figure hours worked per day in the range for it's current practical use. But I was wanting to extend it so that it would handle over night shifts properly in case they did ever occur.Right now my code looks like this and it works for my current application:
vb
Public Sub ConvertTimesTableToHoursTable(ByVal timesTable As DataTable, ByVal hoursTable As DataTable)
[code].....
For some reason my code is a little buggy, and i really would like a speed calculator with my program.
'Download progress bar kode
Private Sub WC_DownloadProgressChanged(ByVal sender As Object, ByVal e As DownloadProgressChangedEventArgs) Handles WC.DownloadProgressChanged
[CODE]...
I have DataTable, and is bound to DataGridView. So, when the user inputs some values in 4 columns, it would calculate the sum and put it in the last 2nd last column.
Here's the code that I'm experimenting:
vb.net
Private Sub DataGridView1_RowLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.RowLeave
Dim i As Integer
Dim intTotal As Integer = 0
For i = 5 To DataGridView1.Columns.Count - 3
[Code]...
So, basically it should sum up certain columns when the user enters numbers into it and then display it in the last column.
[code] Everytime i press the Calculate Button, it crashes on my first calculation part. What im trying to do is to not crash the program eventhough i have no input in it.
View 1 Replieshow to add value to selected row at datagridview control. hire my code to display and add row at datagrid :
vb.net
Public Class Form2
Dim dt As New DataTable("view")
[Code].....
I have a DataGrid that a user is sorting, problem is that the sorted results are not being updated in my DataTable (which makes another function fail later). I have tried calling AcceptChanges() after the sort is done, but that isn't updating the DataTable. dtMessage.AcceptChanges()How can I have the DataTable updated after the sort to diplay what is displayed in the DataGrid ?
View 2 RepliesI'm quite not so familiar with vb.net. so please bare with my query.
does vb.net support RTD function?can the datagrid be used as RTD client?
there is an app with RTD server and I'm presently using excel as RTD client but wish to move out of excel.
I have data bound to the silverlight 4 datagrid and now I want to grab the value of column 0, row 0. How do I do this? I can't find an example anywhere and this should be so simple.
View 1 RepliesI'm used to use the Listview, but need/want to use the datagrid. The problem is that I have never used the datagrid, so don't know how to import the data from the mySQL-database. I'm loading the data directly from the database, without any dataset.The code I use:
vb.net
Try
mysqlConn.Open()
Dim mysqlComm As New MySqlCommand(strBeslagdataComm, mysqlConn)
[code]....
Is it possible to put a caption at the top of a datagrid in VB Express 2010? I have no problems with rows and columns, but see nothing having to do with captions in datagrid properties.
View 6 RepliesI have a Datagrid with 5 columns, one of those columns is the only one to have fixed values.Let's put this in a simple way, that column (lets name it column A) contains rows with values from one to ten.With an API call I get some information, lets say I got this:
1 - Andrew - 1.8
8 - Peter - 2.8
Something like this.The first number is equal to the value on the column A, the other two are name and height. I will note receive all the values (one to ten) with call or full information relating to all the columns.How can I assign the information I receive to the proper row based on one of the value I get with the call? Another thing, I will have to create a lot of rows, do I need to add them row by row?
Kinda new to working with wpf apps (and vb.net). Looking for a way to filter a datagrid using a combobox (to select the field that the user wishes to search) textbox (to input search terms for specific records). The datagrid loads fine as does the combo containing the fields, however my filter simply does not work.
Code for loading data (works fine)
Dim obj = Me._dataManager.Collections.ReturnCollectionByID(tableSelectionCombo.SelectedItem.TableID)
Me.DataGrid.ItemsSource = obj
obj.Load(New DataManagementDataRequest(Nothing, Nothing))
Code for filtering (not working)
If Me.searchTxt.Text IsNot Nothing Then
obj.filter = selectFieldCombo.SelectedItem.ToString Like searchTxt.Text.ToString
Else
obj.filter = ""
End If
i have a problem with deleting certain information on my datagrid [Code] and this clears my whole grid, but i want it to delete only the selected row, what would the code be?
View 2 Replies[Code]...
The problem is when I change the value in the cell 2, it didn't "refresh" the cell 4. I think I've a problem on the event "valuechange" but I dont know why
I've been asked to add in some functionality to an existing project.On the main form is an unbound DataGridView. I've been asked to add in a column for a date. Easy enough to add in the column, however I would like to make it easier on the users & have a date picker in the column instead of having it as a free text field & then have to apply constraints to ensure I get the date in the correct format.I've not been able to find anything on this in the usual places & am hoping someone on the forum might have some ideas I could try ?
View 3 Replies[Code] I can output the above codes, the way I want. but 34 I could not cross the line and then the other page. After 34 lines of each page I want the atlas. 1 through 5 is going to be a between 6 and 8 between the columns, the columns to the right-based format, would like to have the money.
View 13 RepliesI have a text box setup to filter a datagrid. Work just fine, but if I search for something that is not there (empty results) it comes back with an error
"Object reference not set to an instance of an object." on the bolded line. How to fix that error?
[code]...
How to easily print the contents of a datagrid. I have searched and found some examples, but cant get any working in vb2010.
View 3 RepliesobjdataAdapter.SelectCommand = New SqlCommand()
objdataAdapter.SelectCommand.Connection = objconnection
objdataAdapter.SelectCommand.CommandText = "Select SerialNumber, EmailAddress, Results FROM Email WHERE SerialNumber='" & txtCriteria.Text & "'"
[code]....
What I want to do is for every row of data in the datagridview, i want to add a column for checkbox. The checkbox will be enabled or disabled based on the value found in the field results. The first time I am pressing the button, it works fine. But the second time i query, it keeps adding another checkbox to the same row. Even for the nth time. Everytime i press the button, a checkbox is added. I just want one checkbox every time i query the dataset.
I am doing a search to look for a value that corresponds in my datagridview. But the problem is it is being case sensitive. Is there a way to disable that? The code I am using is below.
Supplier_List.DataGridView1.Rows(i).Cells(0).Value.contains(txtSupplier.Text)
Supplier_List.DataGridView1.Rows(i).Selected = True
My program is databound to an access 2007 database. I have a datagridview showing rows as part of my screen and the other part of my screen is texboxes bound to a different table.What I currently have:
1. Date in textbox from one table
2. Age in Datagridview column from another table
I need help with having a calculated date column in the datagridview that will be the textbox date + age (in days) in the datagrid column. I would also need this column to store in my database like any other field also. So if I typed in 2/17/11 into the textbox, and I typed in 2 in the age field, the calculated field would display and store 2/19/2011 in my datagrid and database. My dataset designer won't let me add a date to a string so I'm completely lost. A query calculates it easy in access but when I load the access query in my dataset it doesn't calculate anymore.
VS 2010 [RESOLVED] Caluclated Fields in a Datagrid
View 8 RepliesHow to move in a datagrid object. which of the column 1 and row 1 I want to move to the row 1 and column 3.
View 3 RepliesI have a datagrid and has items of quantity, product, desc etc is it possible that i will get all the items in my datagrid and put it all in my database im thinking of using the datatable or dataset.
View 35 Replies
