For example, is this an acceptable way of checking that fields are not empty before submitting data to a datatable/database? Right now, Im simply checking with an If statement, and I'm starting to think that this is not the correct way to do it.
I'm also trying to learn more about unit testing, so if you have any tips or tricks, please feel free to share.
[Code]...
I am trying to see if producttextbox.text (getting ready to be entered) is duplicated in the DB. I have searched and search and typed some code but nothing is working. Code shown is so far the closest.I do get the NO MATCH message box now although it is a duplicate record. At least I know I am getting somewhere...
Public Sub ValME()
Dim dv As New DataView(FSC_DATADataSet.PERS)
dv.RowFilter.Contains(ProductTextBox.Text)
[code].....
Is there a way to prevent the form closing event from executing if validation fails on a control? If validation on a control fails this stops the form from closing, but the closing event still executes. Scenario is user has focus in a text box, tries to close the form. Validation fails, but closing event is fired. I'm not sure how I can abort that event.
View 5 RepliesI am trying to get valid data entered in a Windows Form.I simply used bunch of IF and ElseIF statements to set the conditions.
1. Because the field can only accept letters, I need to filter out characters. Eg: !@#$, stuff like that.
2. I need to apply a loop so that the user is prompted to re-enter the data or to have the error message repeat. Right now the error message display once and that's it.I understand the Do Until Loop but my book shows example only on numbers.
Public Class validDataForm
Private Sub validDataForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
End Sub
[code]....
Now that my application uses windows authentication to connect to the database, how will I authenticate the username and password that the user supplied? I've read about WindowsPrincipal and WindowsIdentity but still I have not found a way to do this.
View 5 RepliesI want to use windows authentication in my vb.net application rather than validating against Database. Is there any possiblitiies or APIs that allows me to use Windows authentication? I have user id and passoword text boxes. Once user entered the userid and password, it should validate again Windows authentication.
View 1 RepliesIt is possible to create windows service using windows form control in vb.net. give me the url or links. The windows forms control such as, Timer control, list-box, notify-icon control etc.
View 1 RepliesI am using validating procedures to validate user input from 4 text boxes. I am experiencing an issue using the 'x' button to close my form if invalid or no data is present in the textbox with focus when I click the 'x' button. Validating triggers and the message box appears. You can change the data to something valid and close fine but this is aggrevating. I changed the forms causevalidation attribute to false and created a sub to handle formclosing. In that sub I specified that causevalidation for all textboxes be disabled and also set e cancel to false. After that I tested with bad data and the message box showed again, but when I closed it the form closed also.
View 4 RepliesI have a form with a datarepeater that contains various controls (i.e. datetimepickers, text boxes, combobox) that are populated via a binding source. I also have other controls on the form that are not part of the data repeater. I would like to force validating all controls after the data is populated. I have successfully forced validating the non-datarepeater controls using Me.ValidateChildren() at the end of my load event. However, it does not fire the validating events for the controls within the data repeater. I have unsuccessfully tried many different attempts to set and move focus within the datarepeater controls trying to get the validating events kicked off. I am not sure where would be the best place (e.g. in drawItem? in ItemCloned?) to place the code and what it should be exactly.
Here was my latest attempt:
Private Sub DataRepeater1_DrawItem(ByVal sender As Object, ByVal e As Microsoft.VisualBasic.PowerPacks.DataRepeaterItemEventArgs) _
Handles DataRepeater1.DrawItem
For i = 0 To e.DataRepeaterItem.Controls.Count - 1
e.DataRepeaterItem.Controls.Item(i).Focus()
e.DataRepeaterItem.Controls.Item(0).Focus()
Next
I successfully handled the validating events in the data repeater caused by user input errors. However, I have the unusual situation that the data coming into my form is already bad for some of the controls. The purpose of the form is to validate the data coming in to it and from user-input. I am newbie with vb.net.
So I'm developing a Windows Forms Application in Visual Basic 2010. The user searches for data and fetches results, updates fields and some other CRUD operations. I want to provide a user input validation. Usual stuff i.e. some fields need to be always numbers>0, others need to be non-empty in order to avoid Null access on some objects and others just need to be some fixed strings.
[Code]...
i have a form hold some textboxes ,writed validating-event code and sometime set cancel=true in validatingnow,the problem is,when i click the close button of the form,the validating-event fired,and the form can't close when the validating set cancel=true,but this not i want.i think click "close" that meaning abandon all the form's data,so it not need validate.how can i do ?
View 2 RepliesWe have a window that has a text box on it that the user must enter in valid data before going on. So we have put in a message box letting the user know that they have to enter in the correct data before going on in the Leave event. That works just fine, but when the user press ALT+F4, or presses the X in the upper right corner of the window it still goes through the event. We would not like for that to happen. When we were using VB6 the same code was in the lost focus, and when the user pressed ALT+F4, and the X the LostFocus event did not fire, or acted like it did not fire. We have also tried moving the code to the Validating event, but it behaives similar to the Leave event? how to close a window, and either have the Leave, LostFocus, and Validating events not fire when the user Presses ALT+F4, or the X
View 6 RepliesI am writing below code for validating compulsary field account no. in form.User's requirement is set focus back on field when error comes :
If txtAccountNo = "" Then
MessageBox.Show("Account no filed can't be left empty")
txtAccountNo.SetFocus
Exit Sub
End If
It's working properly. But suppose user don't want to fill form and exiting from application.Message box keep on appearing till user enters account no.
In my .NET porject, I have to run a lot of validation on 4/5 fields. This validation checks if certain fields have errors, for example: the name field is not allowed to have numbers or symbols. If all these checks are passed, I need to execute a SQL query to pull some data out of the database. I could have it with a lot of nested IFs, and run the function at the end once it passes them all, but this will translate into about 12 nested IFs, and it seems a really bulky way to do it. I have also thought about setting a boolean value after every check, and if the value is 1 then don't run the function, else do. But of course this gets overwritten by other checks that pass.
View 2 RepliesI'm upgrading a project from VB6 to VB2008.I have a routine that clears a combo box, named 'cmbDataTable' which could be on any form. I pass the form and the combo box is cleared.
[code]...
I assumed it would be the same in VB2008 but I get the error.'cmbDataTable' is not a menber of 'System.Windows.Forms.Form'I am working my way through the project, first updating the global procedures - this is one - I haven't written the calls so cmbDataTable doesn't yet exist.
New to Visual Studio 8 running on Vista with Office 2007.Attempting to create first simple form with data grid using Nwind.mdb Customers table. Data source is created and using Preview data actually shows the data contained in the table.After dragging the DataGridView onto the new Form1 no data appears in the grid when the form is run.
View 4 RepliesI have 3 checkboxes on a groupBox, when the user presses "OK" i was first wanting to validate that at least 1 checkbox was ticked before commencing, if they haven't selected any i was going to throw an error up, i'm stuck on how to do this i'm sure a for each, but i can't seem to figure out the syntax.
View 3 Replieshow can i insert data to database using datagridview in vb.net? i want to use the datagird as input filed. i dont want to bind the gridview.
View 5 Repliesi want to save the form name in data base and load form using that saved name. How would we achieve this task?
View 5 RepliesI am trying to insert data into two lables from an access database(2 different tables) by doing a search. I have code that wont work
Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Dim SearchPatient As String = txtNPatientID.Text
[Code].....
I'm making program that will copy one file and over-write another to purge data.I have a windows form interface where the files can be selected and want a console application to run this process so it can be put into the PC's startup folder to run on each startup.
The problem is I need to send the file location data to the console app when I choose a save button on the form. Both are part of the same project and referenced but I can't seem to reference any variable from the win form to console app.Also will I see the Console app as a seperate icon in the program files so I can put it on the PC startup?
It's simple question. I am confused since I am new to vb.net and windows form. I would like to display combining of one column (lastname+firstname) in the list box control from the query. My code display something.
[Code]...
I have an app. MDI Parent and several forms,connected to SQL server 2005 via ODBC, and form1 is my app. main form.What I try to do is,
1-when insert data into the database if data already exist then it don't do anything and popup message let you data already in the database.
2- How to prevent end user modify textboxt1 on from1 if there is value in textbox1?
I'd like to use a TreeView control to display database data in a windows form with VB2008. All the information what I found is related to a website design, but I'm working on a database program (sql2005), where I'd like the user to see the structure what he/she make up with a TreeView like control. Just something like that when you explore your hard disk. How can I do that?
View 3 Repliesi want to which way is better when concentration is on processing speed. i want to call a method that compute some data that method is on another form in my windows form application then what you prefer is better way 1) to call that method in another form and use returned value or create similar method in form where it is required.i want to make it's processing fast.
View 3 RepliesIs it possible to combine the data of 2 or more datasources in 1 windows form in a project solution?
i'm using sqlserver 2008 and visual studio 2008
I have a requirements in "Windows form exe" that when we click on the exe, the data from the Oracle database should be exported to another Oracle database and also the data that has been exported should be emailed with excel attachments to intended recipents.
I searched but couldn't get the code as such and also i am not able to implement the functionality.
I am using Datagridview and ListView Controls in my windows desktop application using vb.net.I want to Import data directly to Excell sheet and CSV file directly from form.
View 3 RepliesI have exported data from a SQL Server table into a XML file and the output looks like this:
Filename = 11190.xml
Table name = LRTest
<NewDataSet>
[Code].....
Now I want to save the above XML file into my SQL Server 2005 table
With the same columns using vb.net windows forms, in every exported xml file there are 100 to 200 records. .
I have a form program that runs long, and for kicks I was wondering if I could out put some data to a "real console" -not the Console useing the Output debugger.
View 8 Replies