DrowDownList inside a FormView

[Crypton]

Hi, I need help:
I have a FormView control on the page, for managing Download Section on a web site. The download section has a list of categories (here is where DropDownList comes in). The DropDownList is binded to a AccessDataSource, which extracts the ID and name of a category (id is used for a file/category).
For some reason, my code returns an error

Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.

when I try to insert a record.

Here is the ASP.NET template for <InsertTemplate>

<td style="border: 1px solid #000000;">
                                                                            <b>Category:</b></td>
                                                                        <td style="border: 1px solid #000000;">
 
                                                                            <asp:DropDownList ID="kindDropDownList" runat="server" DataSourceID="dbCategories"
                                                        DataTextField="category_name" DataValueField="kind" Width="323px" SelectedValue='<%# Bind("kind") %>' >
                                                    </asp:DropDownList>
                                                                        </td>
 

Please help. =\

[gagandeepgupta16]

Hi, I need help:
I have a FormView control on the page, for managing Download Section on a web site. The download section has a list of categories (here is where DropDownList comes in). The DropDownList is binded to a AccessDataSource, which extracts the ID and name of a category (id is used for a file/category).
For some reason, my code returns an error

Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.

when I try to insert a record.

Here is the ASP.NET template for <InsertTemplate>

<td style="border: 1px solid #000000;">
                                                                            <b>Category:</b></td>
                                                                        <td style="border: 1px solid #000000;">
 
                                                                            <asp:DropDownList ID="kindDropDownList" runat="server" DataSourceID="dbCategories"
                                                        DataTextField="category_name" DataValueField="kind" Width="323px" SelectedValue='<%# Bind("kind") %>' >
                                                    </asp:DropDownList>
                                                                        </td>
 

Please help. =\

hi, are you passing all the parameters to be inserted into your table?
if you have the id field as autoincrement, then also you might have to pass null.
or you can try giving "allow null" in the table design if not all fields are to be inserted.

[Crypton]

hi, are you passing all the parameters to be inserted into your table?
if you have the id field as autoincrement, then also you might have to pass null.
or you can try giving "allow null" in the table design if not all fields are to be inserted.

ok, thank you, it worked!