Possible for a program to get corrupted?

[ohok]

What I mean is corrupted I guess. I have been having nothing but trouble with this scheduling program, and things that should work aren't working. Newest example is this:

System.Data.EvaluateException was unhandled
Message="Cannot find column [ID]."


That is thrown in this code:

Private Sub cmbdoctor_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmbDoctor.SelectedIndexChanged
        If Me.cmbDoctor.SelectedIndex > 0 Then

            ' get new owner
            _owner = Me.cmbDoctor.SelectedItem

            ' apply filter to C1Schedule's data source (show only current owner's appointments)
            Dim v As System.ComponentModel.IBindingListView
            v = C1Schedule1.DataStorage.AppointmentStorage

            C1Schedule1.BeginUpdate()

            v.Filter = "ID='" + _owner.Index.ToString() + "'"

            ' Set default value for Appointment table Owner column (equal to the current owner index)
            Me.TestAppointmentDataBaseDataSet1.Appointment.IDColumn.DefaultValue = _owner.Index

            C1Schedule1.EndUpdate()

        ElseIf Me.cmbDoctor.SelectedIndex = 0 Then

            Dim v As System.ComponentModel.IBindingListView
            v = C1Schedule1.DataStorage.AppointmentStorage
            v = C1Schedule1.DataStorage.AppointmentStorage
            v.Filter = ""


        End If

Right at the v.filter it's giving that error. I used this SAME exact code in a sample program, with the same exact data source and tables and it works fine. The ID column is certainly in both tables I'm having it look at, and I fill them at form load. Not only this, but any time I add a data source I have to go into the designer.vb and add "Global" to every instance of data. When I add a new data source it removes all the Globals and I have to do it all over again.

So, is this thing just messed up and should I start over or what?

[ohok]

Anyone?

[Shaggy Hiker]

I would be very hesitant to have a column called ID. Whether it is contributing to your problems in this case, I don't know, but MS uses that particular pair of characters for some strange and hidden things. I first encountered this when I used a table that had an ID column as a primary key. When I output the data into the textfile, and tried to open it in Excel, I would get an 'Invalid File Type' error. It turned out that a textfile that starts with those two characters indicates something, though I don't know what. It could be that there is some meaning in this case, as well, so I would treat ID as if it was a reserved word.

As for the other, tinkering with the designer can cause some odd behavior. I haven't seen exactly what you describe, but I have seen other oddities.

[ohok]

I actually did rename it to something else before, it must have found its way back in. I still don't understand why the exact code and data source works with one and not the other, that makes no sense.

[Shaggy Hiker]

Not to me, either. It IS possible for code to become corrupted. I have never had to do it myself, but I see suggestions to empty the bin and object directories in the project directory and rebuild the code. I don't have any confidence in that, though.

I would put a breakpoint on the line that is causing the problem, which I assume is v.Filter, and take a look at v. It may not be what you think it is.