I have a datagridview comboboxcolumn populated with jobs. these jobs have a wage attached to them. for example job "Policeman" has a wage of R20.I have 5 checkboxcolumns for each day of the week as well. so if I check 3 of the checkboxes and have the job "Policeman" selected, I must then calculate the weekly wage (3*20=60) and display the wage in the weekly wage column. which event is best to handle this.
View 2 RepliesI have a WinForms DataGridView control on a form. There are two fields in this DataGridControl:
Email Address
Resolved Email Address (calculated based on the input in Email Address)
After the user inputs or changes a value in Email Address, I want the value in Resolved Email Address to update based on a separate method. What event should I tie in to so that that the Resolved Email Address cell is updated after the Email Address cell is updated?I'm not sure where to put the event because the user could do a number of things after adding/changing a value: tab to the next cell, click cancel on the form, click ok on the form, etc.
How Do I Make Button.click Event Perform both the enter and period(del) keys on the numeric keypad? [Code] Case Keys.Enter and Case Keys.Separator do not work. Nor does anything like Keys.OEMPeriod for the period(del) key. I've also tried calling the enter key in a KeyPress event etc. But to no avail. Any ideas? I'm trying to mimic Windows calc.exe for a school project and thought I'd try throwing in a few extras such as numeric keypad functionality.
View 1 RepliesHow can I make my app perform an event (in this case updating) on the first run, and every five starts after that? So on the first, then the fifth, then the tenth etc. I know I could do it by adding 1 to a settings variable every startup, but I can't figure out how to check if it is a multiple of five. Or is there a better way?
View 9 RepliesI have 64 labels in my program and I need to perform a single bit of code every time each of them is clicked.
[Code]...
how can i perform a label click event using the code only.like in button we have a code like me.button1.performclick
is there something like in label
I have a feature in my program that allows the user to have multiple tabs, each having its own rich text box. Is there a way that I can only perform an event, such as "Text Changed", for the selected tab's rich text box, or will everything still work (the way I want) if I give them all the same name?
View 12 Repliesi'm using a datagridview to display the records which are filled in my dataset. however i need to perform paging to display only selected numer of records (e.g: display only 10 records per page) and by using the buttons (like: FirstPage, NextPage, PreviousPage, Last Page) allow users to nevigate through the records. and possibily display the total number of records in my dataset (e.g: |< last <Next 10/100 previous> first >| ) this might sound very simple but i'm new in .net and so far whatever source code i found in google is moslty written in C# which i don't know.
View 4 RepliesI am creating an Excel Add-In using Visual Studio 2010. I would like to run some code when users clicks a combination of keys.Here is the code I have got
Public Class CC
Private Sub ThisAddIn_Startup() Handles Me.Startup
EnableShortCut()
End Sub
Sub A1()
[Code]...
The Add-In when installed shows an error on clicking the short cuts. It says the specific macro cannot be found.The code under the Sub EnableShortCut() works well when it is in an excel vba module. The same won't work when it is added to an Excel Add-In created with Visual Studio.
I have a button on a datagridview (dgproducts)that when clicked, sends the data from that row to another datagridview called (DgSelectedProducts) in a Keypress. The button on dgproducts is unbound and is (0) and is named AddProductsButton in the collection. I am using a barcode scanner into txtboxsearchbarcodeID so that when the user enters the barcode to the textbox it finds the barcode in the dgproducts it filters down to that item.
When I say filter I mean all the items that do not match are not shown on the dgproducts datagridview. Only a single item can match. That part works ok. The problem that I am having is that I do not know how to perform a click on the cell(0) ie addproductsbutton so that the item is passed from the dgproducts to the dgselectedproducts when the item is scanned. This is for a POS form so it needs to do this.
Private Sub txtBarcodeSearch_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtBarcodeSearch.KeyPress
' If e.Handled = Keys.Enter Then
txtSearchTerm.Text = txtBarcodeSearch.Text
Me.CBOProducts.DisplayMember = "ProductIDBarcode"
cmbSearchField.Text = "ProductIDBarcode"
[Code] .....
currently i am working on a project in which i am using datagridview control. if I enter key value in cell than remaining data of that particular row fetch automatically from data base. how? how to delete as row in datagridview? how to update a row in datagridview?
View 5 RepliesI 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.
I have a datagridview which is populated from the SelectionChangeCommitted event of the combobox. The datagridview contains both bound and unbound data columns (see below).
View 1 Repliesvb.net
Private Sub DataGridView1_CellValueChanged _
(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) _
Handles DataGridView1.CellValueChanged
[code]....
I have a datagridview bound to an Access datatable. It is nothing more than a one column list of chemicals. To allow the user to more easily navigate the list, if they press a letter it will jump to the first chemical alphabetically of that letter. If they keep tapping that same letter it will move down that list one by one. This all works fine. The problem is if you hold down the letter it will progress down the list but it doesn't show that progression. I want it to function much like if you hold down the down arrow key in a datable you'll see each successive cell be selected as it goes down the column.
[Code]...
I'm facing a strange problem in my dgv, I have the dgv bounded to a datatable, now I had to add a new column to let the user checks the rows that he/she want to export to a text file. I had the checkbox column, but when I run the application I can't check any row, I try to add in the click event of the dgv to manually check the column but it still not works...
My
VB
da.SelectCommand = com_pfda.Fill(ds, "table_1")dgv_dados_obra.DataSource = ds.Tables("table_1")
Dim dgvColunaCheck As New DataGridViewCheckBoxColumnWith dgvColunaCheck
[Code] .....
The code in the click event, because the normal click in the checkbox doesn't worked:
VB If e.ColumnIndex = 7 Then
If dgv_dados_obra.Item(7, e.RowIndex).Value = 0 Then
dgv_dados_obra.Item(7, e.RowIndex).Selected = True
[Code] .....
I don't know why this doesn't work...
I have a 2d array of data that I have performed the sum of the individual column of the 2d array. I want to send the results to a datagridview and also will like to have the result as a 1d or 2d array.
Below is sample of my code
Dim Array1(,) as double
Array1(0, 0) = 5
Array1(0, 1) = 7
[code].....
How to perform a mouse click using VB 2008?
View 3 RepliesDim Conn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "C:Documents and SettingsUserDesktopContribucionescontribuciones.mdb"
rs.Open()
rs.Open("SELECT * FROM master")
rs.MoveFirst()
TextBox1.Text = rs.Fields("sueldoanual").Value
I have this error
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
can i perform sql queries on xml files?
View 9 RepliesI am trying to copy a file from 1 location to other location with a new name. The new name should be like "Oldname + date & time". I wrote the following code but getting error that the Given path format is not supported Imports System.IO[code]...
View 2 Replieswhy can't I performCllick using a button which is on other tabpage. I tried those two so far but nothing happens:
[code]
btnAdd.PerformClick()
DirectCast(My.Application.OpenForms("record"), record).btnAdd.PerformClick()
/CODE]
it must be simple I just can't do it because I need to get this done when I am in other tab
How can i perform order by tCount in this Query?
Public sub StatReport()
Dim Transaction = xmlDataset.Tables("ebus_transactions")
Dim TranCounts = From T In Transaction Take 2 _
[code]....
is it possible to perform an action when the tab key is pressed in a textbox or the mouse cursor is moved to another box?
View 1 RepliesI need to perform a silent download in visual studio 2008
View 1 RepliesIn VB6 I could use an asterisk as a wildcard when searching the object browser. For instance, searching on "c*Report" would find "cFooReport" and "cReport". I can't seem to do the same in VS2008, am I just missing something obvious?
View 1 Replieshow to perform the database operation such reading data and using them for comparison within the VB programming..
Please guide me with explanation as i have very little knowledge regarding the database operation...
i am using VB.Net 2008 as frontend...and MS SQL Server 2008 (express edition ) as back end...
I have an Access database that has thousands of records. The fields in the database are EMPID, FIRST, LAST, JOBTYPE and PAGES. I would like to know how to loop through the data table and for each individual EMPID to calculate the sum of the PAGES for each JOBTYPE.There are four JOBTYPE's: "E", "K", "O" and "R".Here is some
Dim WebAllEmployeeQuery As String = _
"SELECT ELPallEmployees.[EMPID], ELPallEmployees.[FIRST], ELPallEmployees.[Last], ELPallEmployees.[JOBTYPE],
[code].....
I've been creating a small application and now I'm going to make a setup file for it. And I started doing this using Installshield. Here's a prtscreen of where I'm stuck: Since I've developed my Application in .Net, I don't know whether it can be installed on earlier versions of Windows such as Windows 98. Should I uncheck some options?
View 6 RepliesHow to perform add, edit, delete in a dataset that will update the database as well?
View 1 Replies