Fill Dropdown List....

Question

0.00/5 (No votes)

See more:

Hi Frnds,
i have a dropdown control.while displaying it i have to show the Item name...but while saving in the Database i have to save Item Code which is integer not the Item Name.
how can it be done.

Regards,
aamir

Posted 28-Jun-12 18:01pm

aamir07

Add a Solution

4 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)

Vani Kulkarni · Answer 1 · 2012-06-28T18:03:00

Solution 1

Use below code:

C#

if(ddlItemCode.SelectedValue != "")
   int itemCode = Convert.Int32(ddlItemCode.SelectedValue);

Pass itemCode to the database while saving.

Posted 28-Jun-12 18:03pm

Vani Kulkarni

Updated 28-Jun-12 18:06pm

v2

aamir07 · Answer 2 · 2012-06-28T18:07:00

hi vani,
but while filing the Dropdown i am just getting the Name of item and not the Id.
i have used sqldatareader();to fill the Dropdown like below

C#

SqlDataReader dr = command.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        string p;

                        if (dr[0].ToString() == null || dr[0].ToString() == "";)
                        {
                        }
                        else
                        {
                            p = dr[0].ToString();
                            drp.Items.Add(p);

                        }
                    }
                }

chetan virkar · Answer 3 · 2012-06-28T18:20:00

plz get item name and item code from dropdown ie
dr[0] is item name
and dr[1] is item code

C#

SqlDataReader dr = command.ExecuteReader();
                if (dr.HasRows)
                {
                    while (dr.Read())
                    {
                        string p;
 
                        if (dr[0].ToString() == null || dr[0].ToString() == "";)
                        {
                        }
                        else
                        {
                          
                       //drp.Items.Add(new ListItem("text","value") it is syntax now in your case add following


                drp.Items.Add(new ListItem(dr[0].toString(),dr[1].toString())
                        }
                    }
                }

from this code you save itemname as text and itemcode as value of dropdown

now you can get value of dropdown using following Code

int itemCode = Convert.Int32(drp.SelectedValue);

and save itemcode in your databse
may be this will help you

AshishChaudha · Answer 4 · 2012-06-28T18:24:00

Solution 4

for binding the dropdown list through dataset

C#

dropdownlist1.items.clear();
dropdownlist1.datasource=ds;
dropdownlist1.datatextfield="Itemname";
dropdownlist1.datavaluefield="ItemCode";
dropdownlist1.databind();

for saving the value field into database

C#

string sql= insert into (columnname) values ("+dropdownlist1.selectedvalue+");

Mark it answer if you get your solution

Thanks
Ashish

Posted 28-Jun-12 18:24pm

AshishChaudha

Comments

aamir07 29-Jun-12 0:33am

hi ashish,
i got the above query solved, while saving in DB i get the code...but now i want, on select of the Gridview row to show the ItemName not the code in the DropDownList control.

AshishChaudha 29-Jun-12 1:09am

You are showing the itemname in your gridview!! right..for showing the itemname while selecting through the gridview you have to bind the itemcode in gridview too...did you have binded the itemcode too in your gridview?? if yes then follow the code

dropdownlist1.selectedvalue = gridview1.selectedrow.cells[yourcolumnno of gridview].text;

//for example
dropdownlist1.selectedvalue = gridview1.selectedrow.cells[2].text;

Fill Dropdown List....

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0