VB.Net: Form with DataGridView control failing to close

I have a dataGrid control in my VB.Net form, which has been failing to work.  Right now, to test the form, I simply have the one control that is bound to an Access dataset.  When I first open the form, I see the data in the control, which I can edit.  Regardless of whether I edit it or not, each time I try to close the form it both refuses to close and presents me with an error.  The only way I've found to close the form is to go into the Task Manager and kill the process.  I screencaptured the two errors I'm getting.  

I've reproduced the code below: the only thing there is the generic process that VB.Net automatically generates to populate a control with a predesignated dataset.  I also have an attachment of the two error messages I get, which persist in iteration after iteration of the same genre of error.  Hope you can help.

Thanks, ~Peter Ferber

Public Class DataGrid_Control_Form

    Private Sub DataGrid_Control_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'Data_DefinitionDataSet1.tbl_Role_Outfield' table. You can move, or remove it, as needed.
        Me.Tbl_Role_OutfieldTableAdapter.Fill(Me.Data_DefinitionDataSet1.tbl_Role_Outfield)

    End Sub
End Class

Open in new window


Error messages returned each time I run app, with Inability to close the form
PeterFrbWeb development, Java scripting, Python TrainingAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Jesus RodriguezConnect With a Mentor IT ManagerCommented:
Can be various reasons but first check is the key field on your data in access doesn't have a valid value (Null or is the field will be integer that doesn't contain any letters ). It happens to me when the Key Field of the table contains an invalid value.

 Also can be that the some of the fields doesn't can not be formatted to the expected format of the grid for example if is date format on the grid and the data has an invalid date, then you will get this error too.
0
 
PeterFrbWeb development, Java scripting, Python TrainingAuthor Commented:
You point is spot on, Jesus; and the conflict was Null values in the dataset, which I changed, via a query, to zero-length strings.
0
 
PeterFrbWeb development, Java scripting, Python TrainingAuthor Commented:
By changing my null values to zero-length strings, I am now able to run the program and close it on command!  Woo hoo!  Many thanks.  ~Peter
0
 
Jesus RodriguezIT ManagerCommented:
Always welcome my friend.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.