I think I'm missing something really obvious but can't for the life of me figure out what. I've got a details view submitting to a db but for some reason the dropdown list field isn't going through the update even though (I think) I've specified that it should and it is throwing the error that it can't submit because the column can't be null. Here is the code of what I've done. Am I missing something really obvious???
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsublicationsListConnectionString %>"
SelectCommand="SELECT Status.Status, PublicationRecords.NameOrTitle, PublicationRecords.LocationOfDocument, PublicationRecords.Description, PublicationRecords.ISBN_ISSN_DOI FROM Status INNER JOIN PublicationRecords ON Status.StatusID = PublicationRecords.StatusID WHERE (PublicationRecords.ID = @ID)"
UpdateCommand="UPDATE PublicationRecords SET StatusID = @StatusID, NameOrTitle = @NameOrTitle, LocationOfDocument = @LocationOfDocument, Description = @Description, ISBN_ISSN_DOI = @ISNB_ISSN_DOI">
<SelectParameters>
<asp:QueryStringParameter Name="ID" QueryStringField="ID" />
</SelectParameters>
<UpdateParameters>
<asparameter Name="StatusID" Type="Int32" />
<asparameter Name="NameOrTitle" Type="String" />
<asparameter Name="LocationOfDocument" Type="String" />
<asparameter Name="Description" Type="String" />
<asparameter Name="ISNB_ISSN_DOI" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="StatusSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStringsublicationsListConnectionString %>"
SelectCommand="SELECT * FROM [Status]">
</asp:SqlDataSource>
<aspetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
Height="50px" Width="125px">
<Fields>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="StatusLabel" runat="server" Text='<%# Bind("Status") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<aspropDownList ID="StatusID" runat="server" DataSourceID="StatusSqlDataSource"
DataTextField="Status" DataValueField="StatusID" AutoPostBack="True">
</aspropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="NameOrTitle" HeaderText="NameOrTitle" SortExpression="NameOrTitle" />
<asp:BoundField DataField="LocationOfDocument" HeaderText="LocationOfDocument" SortExpression="LocationOfDocument" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:BoundField DataField="ISBN_ISSN_DOI" HeaderText="ISBN_ISSN_DOI" SortExpression="ISBN_ISSN_DOI" />
<asp:CommandField ShowEditButton="True" />
</Fields>
</aspetailsView>
</div>
</form>
<form id="form1" runat="server">
<div>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStringsublicationsListConnectionString %>"
SelectCommand="SELECT Status.Status, PublicationRecords.NameOrTitle, PublicationRecords.LocationOfDocument, PublicationRecords.Description, PublicationRecords.ISBN_ISSN_DOI FROM Status INNER JOIN PublicationRecords ON Status.StatusID = PublicationRecords.StatusID WHERE (PublicationRecords.ID = @ID)"
UpdateCommand="UPDATE PublicationRecords SET StatusID = @StatusID, NameOrTitle = @NameOrTitle, LocationOfDocument = @LocationOfDocument, Description = @Description, ISBN_ISSN_DOI = @ISNB_ISSN_DOI">
<SelectParameters>
<asp:QueryStringParameter Name="ID" QueryStringField="ID" />
</SelectParameters>
<UpdateParameters>
<asparameter Name="StatusID" Type="Int32" />
<asparameter Name="NameOrTitle" Type="String" />
<asparameter Name="LocationOfDocument" Type="String" />
<asparameter Name="Description" Type="String" />
<asparameter Name="ISNB_ISSN_DOI" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="StatusSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStringsublicationsListConnectionString %>"
SelectCommand="SELECT * FROM [Status]">
</asp:SqlDataSource>
<aspetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" DataSourceID="SqlDataSource1"
Height="50px" Width="125px">
<Fields>
<asp:TemplateField>
<ItemTemplate>
<asp:Label ID="StatusLabel" runat="server" Text='<%# Bind("Status") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<aspropDownList ID="StatusID" runat="server" DataSourceID="StatusSqlDataSource"
DataTextField="Status" DataValueField="StatusID" AutoPostBack="True">
</aspropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="NameOrTitle" HeaderText="NameOrTitle" SortExpression="NameOrTitle" />
<asp:BoundField DataField="LocationOfDocument" HeaderText="LocationOfDocument" SortExpression="LocationOfDocument" />
<asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
<asp:BoundField DataField="ISBN_ISSN_DOI" HeaderText="ISBN_ISSN_DOI" SortExpression="ISBN_ISSN_DOI" />
<asp:CommandField ShowEditButton="True" />
</Fields>
</aspetailsView>
</div>
</form>