DropDown selected value display in datagrid view

Question

0.00/5 (No votes)

See more:

Hello Friends,

i have datagrid where i bind the data in that.
i have one dropdown box. which like this :

XML

<asp:DropDownList ID="drpunit" runat="server" CssClass="input-short" Width="100px">
                        <asp:ListItem Value="0">--- Select  ---</asp:ListItem>
                        <asp:ListItem Value="1">Gram</asp:ListItem>
                        <asp:ListItem Value="2">KiloGram</asp:ListItem>
                    </asp:DropDownList>

now i store the store the value in database table.

when i bind datalist it display 1 , but i want to Gram insted of 1. me bound unit like this :

C#

<asp:BoundColumn HeaderText="Unit" DataField="Unit"></asp:BoundColumn>

How can i get text of dropdown insted of value.

Thank You to all....!!!

Posted 13-Aug-12 0:41am

Yatin chauhan

Add a Solution

2 solutions

Solution 2

try it like this.
<asp:listitem text="aas" value="0" xmlns:asp="#unknown">

Posted 13-Aug-12 1:03am

Gufran_khan

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)

Santhosh Kumar Jayaraman · Accepted Answer · 2012-08-13T00:44:00

Solution 1

C#

dropdown1.SelectedText

will give "Gram"
and

C#

dropdown1.SelectedValue

will give 1

Updated answer.When retrieving it fromd database, in the select query set the value.
Something like this.

SQL

Select OrderId,(Case when unit=1,then 'Gram' when unit=2,then 'Kilogram' END ) as Unit from tbl

Posted 13-Aug-12 0:44am

Santhosh Kumar Jayaraman

Updated 13-Aug-12 0:59am

v3

Comments

Yatin chauhan 13-Aug-12 6:48am

i know that but i can i retrieve Gram . i store 1 for gram and 2 for kilogram in database.
how can i get gram using boundcolumn in datagrid???

Santhosh Kumar Jayaraman 13-Aug-12 6:52am

When retrieving it from database,set the text.Like
Select OrderId,(Case when unit=1,then Gram
when unit=2,then Kilogram END ) as Unit from tbl

Yatin chauhan 13-Aug-12 7:41am

Hey Thank You So much i resolve that ..Thank You So Much Santosh...!!!

Santhosh Kumar Jayaraman 13-Aug-12 7:57am

Welcome