label Font Change According to database Values

Question

0.00/5 (No votes)

See more:

I have a 12 Labels
In asp.net page having texts Of all the Months

I have to retrieve the Data from Sql
which returns three or more month Values

The requirement is that
according to the DataBase Values
the Labels in the page must get Bold..

For ex : If Datbase values return months name Jan ,Feb and Oct
then Accordingly the label having text Jan,Feb,Oct must
get bold..or highlighted... and other labels remain as usual.

here is what i tried

Dim sd as New SqlDataAdapter("Select Months from table",con)
Dim dt as new Datatable
sd.Fill(dt)
For i as Integer =0 to dt.rows.count -1
    If  dt.rows(i).Item("Months") = 'Jan'
           -------Applied css to label1
    End If
    -------similary added the If Condition and applied the css

Next

.

Posted 21-Jul-12 2:19am

Karwa_Vivek

Updated 22-Jul-12 18:25pm

v4

Add a Solution

2 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 · 2012-07-21T03:18:00

Solution 1

And what is the issue?

It all sounds like server side implementation. No separate event required, all can be handled when you access the database. Once the data is returned, based on the data just set the style of needed label as bold. Simple would be to just change the CssClass for the label.

Try out!

Posted 21-Jul-12 3:18am

Sandeep Mewara

Comments

Karwa_Vivek 21-Jul-12 9:23am

Yes I am Using Css accordingly.
But Confused to fetch the Data and to check that with the label names.
I know have to use loop for checking. But I am not getting any clue how to check

Sandeep Mewara 21-Jul-12 12:21pm

You have defined 12 labels. Based on data fetched, in switch case just set the css as per need.

Karwa_Vivek 21-Jul-12 9:24am

Have Fetched the Data using dataAdapater.
But How I will Check that in loop thats the Issue

Ganesh Kumar Kaki · Answer 2 · 2012-07-21T06:18:00

Solution 2

Hi
This is pretty simple
rather than creating lables create them dynamically and change the text accordingly and display it on the page

And If you have any style requirements use CSS to achieve it.

Posted 21-Jul-12 6:18am

Ganesh Kumar Kaki

Updated 21-Jul-12 6:19am

v2

Comments

Karwa_Vivek 21-Jul-12 13:23pm

can you please explain this a bit..