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:
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.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
So, is this thing just messed up and should I start over or what?




Reply With Quote