Solved

Required field validation In datagrid view Columns

Posted on 2009-03-31
5
1,390 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

758 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

22 Experts available now in Live!

Get 1:1 Help Now