?
Solved

DataGridView Default Error Dialog when closing a Windows Form

Posted on 2009-04-01
5
Medium Priority
?
1,554 Views
Last Modified: 2013-11-26
My application is written in VS 2008, VB, .Net 3.5 and have three forms that stack on top of each other due to previous selection (Master Form, Patron Form & Members Form).
When I close the Patron Form I get the "DataGridView Default Error Dialog" (See attached form).

Can anyone help me figure out why and how to resolve this error?

Process to replicate error:
1) Launch Application.
2) Select Patron Form form Master Form.
3) Type in a Patron ID.
4) Click on the Search Button.
5) Retrieves that Patron's information.
6) Click on the [X] to Close form.
7) ERROR...."DataGridView Default Error Dialog"

Material-Basic.jpg
DataGridView-Default-Error-Dialo.JPG
0
Comment
Question by:ITCSAdmin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 9

Assisted Solution

by:Deathrace
Deathrace earned 500 total points
ID: 24041338
Hi,
If you don't have any error handlers in your procedures error will be raised by the CLR. To avoid that you need to have some similar.
Private Sub DataGridView1_CellEndEdit(ByVal sender As Object, _
                                      ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) _
                                      Handles DataGridView1.CellEndEdit
    Try
        '
        'all of your main logic goes here
        '
    Catch ex As Exception
        MessageBox.Show(ex.Message)
        '...
    End Try
 
End Sub

Open in new window

0
 

Author Comment

by:ITCSAdmin
ID: 24042000
Deathrace,
Sorry for wrong form page in previous message....
I tried your suggestion for both DataGridViews that I have on this form and I am still getting the same error. I think it is with one of the ComboBoxes.
See code and correct form below.


    'Members DataGridView
    Private Sub P_MembersDataGridView_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles P_MembersDataGridView.DoubleClick
        'Dim wf2 As New wfPatron_Member
        'Dim row As DataSet_Patron_Main.P_MainRow
        'row = CType(CType(Me.P_MainBindingSource.Current, DataRowView).Row, DataSet_Patron_Main.P_MainRow)
        'wf2.Show(row.Patron_ID)
 
 
        Dim wf2 As New wfPatron_Member
        Dim m As Integer
 
        'Get Patron_ID and Show wf2 - WORKING
        'wf2.Patron_IDTextBox.Text = Me.Patron_IDTextBox.Text
        'wf2.Show()
 
        'MsgBox("DataGridView 1 Row = " & P_MembersDataGridView.SelectedRows.Count)
 
        Try
            For m = 1 To 10
                If P_MembersDataGridView.SelectedRows.Count = m Then
                    wf2.MdiParent = Me.MdiParent
                    wf2.Member_IDToolStripTextBox.Text = P_MembersDataGridView.SelectedRows(0).Cells("MemberIDColumn").Value.ToString()
 
                    wf2.FillBy_Member_IDToolStripButton.PerformClick()
                    wf2.ShowDialog()
                    wf2.Dispose()
                Else
                End If
            Next
        Catch ex As Exception
            System.Windows.Forms.MessageBox.Show(ex.Message)
        End Try
 
        'Get Member_ID and Show wf2 - NOT WORKING
 
    End Sub
 
    Private Sub P_MembersDataGridView_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles P_MembersDataGridView.CellEndEdit
        Try
 
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
    End Sub
 
    Private Sub Patron_CommentsDataGridView_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles Patron_CommentsDataGridView.CellEndEdit
        Try
 
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
    End Sub

Open in new window

Patron-Screenshot.JPG
0
 
LVL 9

Assisted Solution

by:Deathrace
Deathrace earned 500 total points
ID: 24114229
first place all your combo box stuff inside try and catch block.
0
 

Author Comment

by:ITCSAdmin
ID: 24115458
Deathrace,

Thanks for looking at my problem, but I am a New Programmer and so please expand upon what you said.

ITCS Admin
Damon
0
 
LVL 15

Accepted Solution

by:
oobayly earned 500 total points
ID: 24115624
It sounds like a new record is somehow being added to the top datagridview. If the new record has for example a DBNull value for "Member Status", which is not a valid value for the combobox. The error is only displayed when the datagridview loses focus (ie. when the form closes).

You might want to handle the DefaultValuesNeeded event for the DataGridView, and use it to populate valid values for the cells that are displayed using the comboboxes.
0

Featured Post

Quick Start: DOCKER

Sometimes you just need a Quick Start on a topic in order to begin using it.. this is just what you need to know to get up and running with Docker!

Question has a verified solution.

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

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity) (CODE) There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

762 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