I have a DataGridView in which I register customer orders.
The DGV has a column "PRICE", Price must be > than 100, and I control that in this way:
Private Sub DataGridView1_CellValidating(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellValidatingEventArgs) Handles DataGridView1.CellValidating
Dim newInteger As Integer
[Code].....
I am trying to find the proper way to code a datagridview so that I transfer the cell contents to a two dimensional array.
View 3 RepliesHere is my problem: I have a DataGridView and I am adding a new row. In a particular cell, I have to check that the user does not enter existing values in the related table. That is, the value of that cell must be unique. If the user enters an existing value, the application must:
- Show error message
- Clean the cell
- Put the focus again into the cell, to allow the user to enter another value.
Would you know someone do this?
I'm using visual basic 2010 and i am able to import the raw data from excel and into my datagirdview but i am unable to get the code to add the values of raw data in column 2 and 3 and show the answer in column 5. Do i need to loop it?
The entire project is in the attachment take a look at it.
This is the entire code i have now:
Imports System.Data.SqlClient
Imports System.IO
Imports System
[Code]....
On geting input into DataGridViewTextBoxColumn but the column should not accept input of data that is not integer like; 10003, 2.00, 1500.00
View 3 RepliesSome codes here on how could I validate my datagridview? I mean, a certain column on my datagridview should accept integers only, otherwise, it will return a messagebox. Kindly include on which event it should be posted.
View 17 RepliesOption Strict On Public Class Form1 Private Sub btnDistance_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDistance.Click 'The btnEnterSpeed click event accepts and displays up to ten speeds from the user'and then calculates and displays average speed
[Code]...
I cannot figure out how to incorporate the number of days into the input box then get it to loop and count the number of times the User inputs in the number of days. Then I have to incorporate it into the equation to get the total distance D = MPH * Hours. What I have right now wil not count up the number of days and locks up after I input one number and will not add anything to the listbox. Because I also have to make sure that they cant add nonnumaric values and the number of hours per day cannot exceed 20. I have put things in and taken them out but it has been 2 days and I am lost now
how to input a data/value to excel through vb input form and get the data/value from excel back to the input form?? (For example: put a number into exel A1 from input form and get another number from ecel B1 bact to the input form)
View 1 RepliesI'm using a While loop that loops a certain number of cycles (1-576) based on a value entered by a user. It's activated by the user clicking a "Start" button, But I would like it to be able to be canceled using, preferably, the "Escape" key. However, when the loop is going I can't get the program to recognize any keypresses.
[Code]...
I have a program in VB2008 and I need to execute a thread from differents Subs.Each time I start the thread I want to cancel the previous.Here an example:
Private Sub TextBox_Changed(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim ThreadResults As New Thread(AddressOf ShowResults) ThreadResults.Start() End Sub Private Sub ckBoxAllRecords_CheckedChanged(ByVal sender As Object, ByVal e As System.EventArgs) Dim ThreadResults As New Thread(AddressOf ShowResults) ThreadResults.Start() End Sub
I write in a textbox, TextBox_Changed fires, thread spend 4 minutes filling a dataset I check a checkbox, ckBoxAllRecords_CheckedChanged fires, thread spend 10 seconds filling a dataset.I dont want anymore the dataset of TextBox_Changed so I want to cancel its filling.
I've set up a background worker to search a directory for emails and if my specifi criteria (i.e. date ranges, contains a word) are fulfilled, then a list view is populated.I have this working absolutely fine - when I click search, the list view is populated as I watch - but when I press my 'Stop' button, which runs bg.CancelASync() it does not stop the process at all - results still populate in the list view as it was before.
View 1 RepliesI'd like to start by saying that simply though searching, DreamInCode has taught me alot about VB.NET. In fact, I would imagine without DIC as a resource, I probably wouldn't have been able to move forward and learn most of what I know now, just because I got stuck on some things here and there.Anyway, I searched around for information regarding how to "capture" a minimize event in VB.NET. I am working on the GUI for an application that I would like to have minimize to the system tray. Currently, instead of accomplishing this with the minimize function, I do it on the FormClosing event like this:
Private Sub MainFrm_FormClosing(ByVal sender As System.Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles MyBase.FormClosing
'Cancel the attempt.
[code]....
That code works, and upon making the form visible again with Me.Visible = True the form is restored to its original position. However, prior to the form being hidden, the window manager draws a minimize and restore effect before eventually hiding it. Any change to the WindowState _after_ hiding the form does not appear to have any effect, so when the form is unhidden it is still minimized.is there a way to capture Minimize events, and when captured, is it possible to cancel them in a manner similar to what I did with the FormClosing event?
Really wracking my brain here and I'm sure it's something simple I'm missing. Basically I have a form with two tabs. I'm checking the controls on each tab to see if they're dirty and want to prevent a user from clicking a tab if there are changes on the current tab.
I had thought if I check the dirty variable and just set the tab index to the one that hasn't been selected I'd be fine but every time I programatically set a tab's property, it fires off a bunch of the tab's events that just produce an undesireable result such as the right control set is showing but the wrong tab is selected. Here is the code for as close as I've gotten to getting it to work.
[Code]...
I have a task that needs to be executed many times in a thread, so as to keep my GUI responsive. Right now I'm using the ThreadPool to accomplish the tasks, and it works perfectly. I get all the data I expect back from the threads, life's good. When those tasks are finished, I then fire off another set of threads to accomplish another set of tasks, in the same fashion. The work method of these threads uses a call to RegistryKey.OpenRemoteBaseKey, which does exactly that, opens a remote registry key. The problem is: if the user running the application does not have permission to open the remote registry the call will throw an IOException, but I expect this behaviour because the user does not have permission to do it. However, the call itself can take FOREVER.
I wrote the application initially to use delegate methods and used the WaitHandle.WaitOne() method on AutoResetEvents in a state object I passed to each delegate. I tried the WaitOne method using a timeout, which worked fine until I realized that even though the WaitOne timed out, the thread was still running. This is a problem because (from what I understand) processes are only given a certain number of ThreadPool threads and, once used, they must be finished in order to be released back to the threadpool. In my work method, I also have a variable that can be signalled when the thread should be stopped, but that (obviously) only works on code that I've written.how can I cancel a thread that's stuck on a .NET method? Is there some sort of garbage collection method I can call if I give it a handle?
I'm trying to create an app with a backgroundworker to enable canceling a loop, but it won't work as I hoped it would.When I debug right after the line ThreadWorker.RunWorkerAsync() the programm goes directly to Private Sub ThreadWorker_RunWorkerCompleted and skips the Private Sub ThreadWorker_DoWork part, where of course the actual code is in (I've left that code out, it's about a 100 lines and without BGW it works).Does anyone have an idea what could be wrong with it?
[Code]...
I've been working on some code to add together input from an input box to make a string and display it in a message box. I've put the code in a loop so that it will add all input into the string until nothing is entered in the input box.
Dim stringInput As String
Dim message As String
Do Until stringInput = String.Empty
[Code].....
All I get is just the last input entered to show up in the message box and none of the previous entries. How do I get all the input to be added together and show up in the message box?
Right basically if a checkbox in my application is checked "Close to system tray" then my form will cancel close and send to tray instead
[Code]...
Protected Overrides Function ProcessDialogKey(ByVal keyData As Keys) As Boolean If keyData = Keys.Enter Thenme.currentcell.value = "Hello" ' Here i want to give text "hello" to the current cell is this possible
View 1 RepliesI have just started with vb and would like to know if there is a way to input several boxes of data on one form and display individual pieces of that data on several other forms at timed events in the future?
View 1 RepliesI am new to VB.net. I want to read and input file and store that data to an SQL Server database. Do you have an sample code that do such?
View 1 RepliesI'm just trying to create a graph where the user can input data into textboxes and then plot the data. I am attempting to use Zedgraph, but open to other suggestions. The program below creates a plot, but it won't update when the textboxes are updated.
Imports ZedGraph
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[code]....
I have a program for school project that has input fields for Name, Address, City, State and Zip. I need to error check so that the fields are not empty.I have used If statements that check to see if the fields are empty and shows a message box if they are but if I leave the whole form empty and click the button that activates it, all the if statements go- one by one instead of pausing for the user to input the required data.How do I check for data and make the program stay there until the data is input? I have tried TRY/CATCH but it won't catch this type of error.
this is the
'This program computes customer's bills at the pizza shop for all combinations of
'crusts, toppings, sizes and discounts
Option Strict On
Public Class PizzaForm
[code].....
Is it possible to use a datgridview as an input device and then transfer the input to variables (one or two dimensional). I am creating a programme that can be used for a widely divergent number if inputs and the grid would be easier for the user rather than me creating a lot of text boxes at design time which may not be required much of the time and a datagridview would probably be preferable.
View 1 Repliesi have a problem with the sales transaction. i need to show all the product purchase and i need to show it on the data grid but everytime i input a product it keeps on replacing the data i entered. need code for adding data in the rows of data grid.
View 1 RepliesI have used following code to create and write the user input data to XML through Dataset. Hope it can be understood by looking the following code:[code]But the above code is not working. it is not writing the value in XML file.
View 8 RepliesI would like to ask if it is possible for datagridview to have a "drop down calendar" for date inputs and checks when one date is chosen 10 times already.
View 2 RepliesProbably I am asking something stupid. I have a datagridview in which I would like to be able to let the user change values of multiple columns by entering values (input 55.0) or additions(input +1.2)/decreases(input -1.2).How can I check what the exact input of the user is ?
At the moment I only use the input value (so for exampel 55.0) for which I use the DataGridView1.CurrentCell.Value which I put in all selected cells, but I would like to receive the exact user input (so eg '+1.2')
How i clear all data and not delete data or column in datagridview?
View 1 RepliesI tried to make a phone book but I having some problems inserting it to the databank and then updating the Datagridview. I use a Dialog to input the contact details. I have 7 dialog's and 7 Label's.
Name + Textbox for giving contact details , ...
Then I click the button and I thought to use this code
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'I have set it to false so they have to use the dialog to make the contacts but I don't think its the best way'
Form2.DataGridView1.AllowUserToAddRows = True
'Simple Check For checking phone number and Name has values(user must give the value)'
[Code] .....
How do I input a combobox into a selected cell in a datagridview
View 6 Replies