i want to use dropdownlist in formview but not able to insert dropdownlist selected value in database,

Question

0.00/5 (No votes)

See more:

I want to use DropdownList in form view in asp.net web application to insert data from list to database. I tried using <asp:DropDownList />
Please any body can give me code for this to insert data from dropddownlist to database using formview or by manual

Thanks

Posted 3-May-13 1:38am

diggudg

Updated 21-Jun-23 7:46am

v2

Add a Solution

Comments

smilingsameera 3-May-13 8:09am

do you want to insert selected item from dropdownlist to database or all the items?

diggudg 3-May-13 21:51pm

selected item to database

diggudg 3-May-13 22:20pm

<asp:DropDownList ID="ddlcourse" runat="server" DataTextField='<%#Bind("course") %>' AutoPostBack="true">
<asp:ListItem Text="MCA" Enabled="true" Value="1" Selected="True">
<asp:ListItem Text="BCA" Enabled="true" Value="2">

I'm using this code for dropdownlist control but on insertion, null value is inserted into database, I want to know how to insert selected value of dropdownlist and how to use dropdownlist in formview in asp.net c#

3 solutions

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)

Sandeep Mewara · Answer 1 · 2013-05-03T09:51:00

Following should guide you on how to approach the implementation: MSDN: Modifying Data Using a FormView Web Server Control[^]

Additional hint: Have a dropdown in item/edit template as per need and then access that to get selected value. Use that for updation.

Try out. Post specific issue if you face.

smilingsameera · Answer 2 · 2013-05-07T00:21:00

This is not difficult digvijay. I believe you are using the insert template in formview to do the insert.if not, let me know.

on the item inserting event for form view add the below code:

var ddl = FormView1.FindControl("ddlcourse");

if ddl.selectedindex > -1 then
yoursqldatasource.insertparameters("course").defaultvalue = ddl.selectedvalue
end if;

so your sqldatasource should have an insertcommand and insert parameters.

I hope this helps.

smilingsameera · Answer 3 · 2013-05-07T00:33:00

Solution 3

This is not difficult digvijay. I believe you are using the insert template in formview to do the insert.if not, let me know.

on the item inserting event for form view add the below code:

var ddl = FormView1.FindControl("ddlcourse");
if ddl.selectedindex > -1 then
yoursqldatasource.insertparameters("course").defaultvalue = ddl.selectedvalue
end if;
yoursqldatasource.insert();

so your sqldatasource should have an insertcommand and insert parameters.

I hope this helps.

Posted 7-May-13 0:33am

smilingsameera

Comments

diggudg 7-May-13 6:49am

I'm doing this in C# and your code is in VB, can u convert into c#
thanks for solution.

smilingsameera 7-May-13 10:03am

DropDownList ddl = FormView1.FindControl("ddlcourse");
if (ddl.selectedindex > -1) {
yoursqldatasource.insertparameters("course").defaultvalue = ddl.selectedvalue;
}
yoursqldatasource.insert()

i want to use dropdownlist in formview but not able to insert dropdownlist selected value in database,

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0