Solved

Required field validation In datagrid view Columns

Posted on 2009-03-31
5
1,410 Views
Last Modified: 2012-05-06
i am working on windows application, using VB.Net. How can i Implement required field validation in dataGrdiview columns. The user should not be able to submit the form until he selected index is changed from the combobox or Something is enterd in the textbox...
0
Comment
Question by:yuvaratna
  • 2
  • 2
5 Comments
 
LVL 48

Expert Comment

by:jpaulino
ID: 24031273
The CellValidating event with the e.Cancel = True forces the user to enter something
0
 

Author Comment

by:yuvaratna
ID: 24031333
How can i show a message box if the user hasnt entered anything....should i check the value to string.empty and then display the user a message that the textbox cant be empty????
0
 
LVL 48

Accepted Solution

by:
jpaulino earned 500 total points
ID: 24031380
ok, then you have to loop on each item in the datagridview

Like:

    Function ValidColumn() As Boolean

        For Each row As DataGridViewRow In Me.DataGridView1.Rows
 

            If Not row.IsNewRow Then
 

                Dim dt As DateTime

                If row.Cells(3).Value IsNot DBNull.Value AndAlso Not Date.TryParse(row.Cells(3).Value, dt) Then

                    Return False

                End If
 

            End If

        Next
 

        Return True

    End Function
 
 

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

        If Not ValidColumn() Then

            Stop ' Not valid

        End If

    End Sub

Open in new window

0
 

Author Comment

by:yuvaratna
ID: 24031484
Thanks a lot ipaulino..give me a minute...I will check if it works....
0
 
LVL 2

Expert Comment

by:minjiber
ID: 24037808
Assuming your validating the 3rd column of the datagridview, use the below code which uses the RowValidating event

Private Sub DataGridView1_RowValidating(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellCancelEventArgs) Handles DataGridView1.RowValidating

        If Not DataGridView1.Rows(e.RowIndex).IsNewRow Then

            Dim c As DataGridViewCell = DataGridView1.Rows(e.RowIndex).Cells(2)

            If IsDBNull(c.Value) Or c.Value = "" Then

                c.ErrorText = "Cell cannot be empty" ' or msgbox("Cell cannot be empty") as u prefer

                e.Cancel = True

            Else

                c.ErrorText = ""

                e.Cancel = False

            End If

        End If

    End Sub

Open in new window

0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now