ASP/Database problem (Long)

[Bakedgoods]

Neither

This is really a pretty pain in the bum problem

 

[Bakedgoods]

 Dim codestatusAdapter As New ManHoursTableAdapters.CodeStatusTableAdapter()
        Dim codeStatus As ManHours.CodeStatusDataTable
        Dim codeStatusRow As DataRow
        Dim CodeID As Integer
        Dim TimeCodeStatusTextBox As New TextBox
        Dim TimeCodeDropDown As New DropDownList

        TimeCodeDropDown = CType(DetailsView1.FindControl("TimeCodeDropDown"), DropDownList)

        CodeID = Convert.ToInt32(TimeCodeDropDown.SelectedValue)


        TimeCodeStatusTextBox = CType(DetailsView1.FindControl("TimeCodeStatus"), TextBox)
        codeStatus = codestatusAdapter.GetCodeStatus(CodeID)

        codeStatusRow = codeStatus.Rows(0)
        [B]TimeCodeStatusTextBox.Text = codeStatusRow("CodeID").ToString[/B]

When I select a code from my DropDownMenu I get the following error on the line in bold:

Column 'CodeID' does not belong to the table CodeStatus

 

[Bakedgoods]

The two fields concerned at CodeID and CodeStatus, that's exactly what they are called in the database.

 

[Bakedgoods]

It says Text Visualizer and inside is the number 14 (I picked Code 14 from the drop down).

 

[Bakedgoods]

Ok the DataSet visualiser shown the field CodeStatus and a value of 'In Progress' was in there.

That's a pretty good sign I suppose! Not that i've got a clue why it isn't working