How Can I Show A State Name Instead Of Numeric Value In Label

Question

0.00/5 (No votes)

See more:

I am using repeater in asp.net website, in this repeater i have labels in which i am showing data from database table.
eg:-
<asp:Label ID="lbl_state" runat="server" Text='<%#Eval("state") %>'>
here state data is state id which is numeric.

I have two tables in database 1.) register 2.) state
When i register product i save state id in register table for state.
and in state table i have state id and state name.

I am fetching data from register table so it is showing me state id.
But i want to bind state name instead of state id.

Posted 2-Apr-14 0:54am

Raj Negi

Add a Solution

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)

Code Help 2014 · Accepted Answer · 2014-04-02T01:34:00

Solution 1

Use a JOIN to fetch the data from both tables.

SQL

select r.*, s.StateName from Register r
INNER JOIN State s ON r.StateID = s.StateID

Now you can use the StateName.

Posted 2-Apr-14 1:34am

Code Help 2014

Comments

Raj Negi 3-Apr-14 4:58am

It works fine but I have one more question, if i have one more country table and similarly i want country name then how to integrate in this query.

Code Help 2014 3-Apr-14 6:02am

Use a similar join with Country table. For example:

select r.*, s.StateName from Register r
INNER JOIN State s ON r.StateID = s.StateID
INNER JOIN Country c ON c.CountryID = s.CountryID

Raj Negi 4-Apr-14 3:34am

okay good, One more last query, suppose if i fetch 0 and 1 in a label from database but i have no other table to join. I want, when i fetch 0 then it shows text "No" and when the value is 1 then it shows "Yes"...how to do this.

Code Help 2014 4-Apr-14 5:58am

Suppose you have a table Student with column IsPass having value 0 and 1 then the query will be:
select CASE IsPass WHEN 1 THEN 'YES' ELSE 'NO' End as StdResult FROM Student