Detail View Dropdownlist Issue:: When updating it is not updating to DB

Question

0.00/5 (No votes)

See more:

Below is the Code Snippet. I have a Detail View which is populated on selecting two Dropdownlist, I have converted the required Field to Template and then Changed from Text Box to Drop down list with Data bounded. Now when I edit the Detail View and Select a item from Dropdownlist and click on Submit it is not updated to DB, instead a blank value is stored in DB. Please Help.

C#

<EditItemTemplate>
                        <asp:DropDownList ID="DropDownList2" runat="server" AppendDataBoundItems="true" 
                            DataSourceID="AccessDataSource5" DataTextField='<%# Bind("Project_or_Track") %>'  
                            DataValueField="DropDown" >
                        </asp:DropDownList>
                    </EditItemTemplate>

Posted 18-Jun-13 18:59pm

Member 4475977

Add a Solution

Comments

Christian Graus 19-Jun-13 2:17am

I always find when you expect things to happen by magic, they often don't. If you were to write actual database code, you'd have more control here.

Member 4475977 19-Jun-13 5:12am

Code is always Option, but if you have a solution to this problem, Post it.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rish_lp · Answer 1 · 2013-06-19T02:40:00

Solution 1

You have to define an update query on your Datasource which will update the database.

Posted 19-Jun-13 2:40am

Rish_lp