DropDownList not submitting to db

[RubyRue]

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="<%$ ConnectionStrings:PublicationsListConnectionString %>"
            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>
                <asp:Parameter Name="StatusID" Type="Int32" />
                <asp:Parameter Name="NameOrTitle" Type="String" />
                <asp:Parameter Name="LocationOfDocument" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter Name="ISNB_ISSN_DOI" />
                </UpdateParameters>
        </asp:SqlDataSource>
        &nbsp;&nbsp;<asp:SqlDataSource ID="StatusSqlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:PublicationsListConnectionString %>"
            SelectCommand="SELECT * FROM [Status]">
        </asp:SqlDataSource>
 
        <asp:DetailsView 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>
                    <asp:DropDownList ID="StatusID" runat="server" DataSourceID="StatusSqlDataSource"
                        DataTextField="Status" DataValueField="StatusID" AutoPostBack="True">
                    </asp:DropDownList>
                </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>
        </asp:DetailsView>
    </div>
    </form>

[jhardman]

Ruby,

Hello, and welcome to the scripts.com developer network. I have moved your thread to the .NET forum, there is a technical difference between ASP and ASP.NET and your question deals with the latter, so it belongs in the .NET forum.

BTW, thanks for posting your question clearly and in detail and putting your code in code tags. We really appreciate that extra effort.

Jared, moderator
ASP forum

[Shashi Sadasivan]

Just checking.!
Are you retriving the StatusID into your dataset which is being used to populate your dropdown?

cheers