Datagridview only shows empty tables!

shabnamzangeneh · May 2nd, 2014, 12:08 PM

Hi I am trying to apply your tyrit example in lesson 39 to my application. the problem is if I connect the datagridview to an empty table, it shows the column headers just fine, but if I connect it to a filled table, it gives the error that:
Unable to cast object of type 'System.EventArgs' to type 'System.Windows.Forms.DataGridViewCellEventArgs'.

The error occurs on the last line of this code:

Code:

        'Get the selected airplane
        Dim plane As Airplane =
        DirectCast(cmbLineNumberTo.SelectedItem, Airplane)

        'Display the airplane information
        dgvAPList.DataSource = plane.AirplaneStallAssignments

I appreciate your help!

Rod Stephens · May 2nd, 2014, 01:27 PM

Hi Shabnam,

Quote:

Unable to cast object of type 'System.EventArgs' to type 'System.Windows.Forms.DataGridViewCellEventArgs'.

Code:

'Get the selected airplane         Dim plane As Airplane =         DirectCast(cmbLineNumberTo.SelectedItem, Airplane)

'Display the airplane information         
dgvAPList.DataSource = plane.AirplaneStallAssignments

I don't think I understand this. If you don't get an error on the first line, then the selected object must be an Airplane as you intend.

I'm guessing that AirplaneStallAssignments is a collection or table (something that is enumerable)? I don't see how making that assignment should lead to that particular "unable to cast" error.

Do you have any event handlers registered for the dgvAPList control? Perhaps setting its DataSource makes it raise an event and it is actually the event handler that is throwing the exception?

The other thing that might make sense is if there's an automatically generated event handler somewhere (perhaps created by EF). If it's code is marked with the right attributes, it wouldn't show up in the debugger, but it could still throw this exception.

You might try searching the project for DataGridViewCellEventArgs and see if you find anything.

If you can't find a likely cause for this, you can zip the project up (without the bin and obj directories) and attach it to this post (or email it to me) and I'll try to take a closer look.

shabnamzangeneh · May 2nd, 2014, 01:34 PM

yes; you were exactly right. I had this:

Code:

Private Sub dgvAPList_CellContentClick(ByVal sender As Object, _
    '    ByVal e As DataGridViewCellEventArgs) Handles dgvAPList.CellClick

I removed this handler and everything works fine; but I still need this handler. Would you please explain how I would have the cell click even handler with a datasource connected to my grid view?

Thanks

Rod Stephens · May 2nd, 2014, 01:45 PM

Huh. Your code doesn't have that apostrophe on the second line, right? And you're registering it with the Handles clause, not an AddHandler statement?

I think the CellClick event handler should take a DataGridViewCellEventArgs as a parameter, so I don't see what's wrong with your code.

You might try commenting out the event handler and then creating a new one by using the Properties window or dropdowns in the code editor, just to see if it gives you something with the same parameters.

If that doesn't work, I would try changing the e parameter's data type to System.EventArgs. Then set a breakpoint inside the event handler so you can see what is in that parameter when the event handler executes. For example, you can type this in the Immediate window to see what type the e parameter really has:

Code:

?TypeName(e)

Or you can hover over it to see what values it contains.

shabnamzangeneh · May 2nd, 2014, 01:58 PM

how funny; I un-commented the event handler and now it works. I am not quite sure what was wrong before. it is the same event handler (originally it didn't have that apostrophe on the second line).

Anyway, thank you very much for your help. I truly appreciate that.

Rod Stephens · May 3rd, 2014, 12:34 AM

As long as it works!

mmorgan30 · May 6th, 2014, 09:24 PM

The exception tells you exactly what is wrong. Your event handler event args is of type System.Windows.Forms.DatagridCellEventArgs and the type of events that the framework expects is of type System.EventArgs so it throws a cast exception. Change the type of the event args to System.EventArgs and you will fix it.