fetch data from database.

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

, +

Hello

How to fetch data from database and show in a label.
It will show one by one by click in button or
we can show it through timer control through timer interval.

I think it may be possible through generics.

If any solution then please help me.

Thanks

Posted 15-May-12 2:47am

JBSAHU

Add a Solution

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 · 2012-05-15T03:27:00

Solution 2

Okay, here are the resources you would need for it.

1. Connection String - to connect to DB
2. ADO.NET - to retrieve data from database
3. No idea, how/why Generics came in the scene! Timer control.

Links:
For connection to DB: Connection String[^]!
Info regarding the data communication can be read here: Accessing data with ADO.NET[^]
For periodic tick, MSDN: Timer Control Overview[^]

Try now!

Posted 15-May-12 3:27am

Sandeep Mewara

Comments

Maciej Los 15-May-12 10:10am

Very good! +5

Sandeep Mewara 15-May-12 11:53am

Thanks!

Sebastian T Xavier · Answer 2 · 2012-05-15T02:58:00

Solution 1

Found a similar question here.

how to store values in lables from database[^]

This may be helpful to you

Regards
Sebastian

Posted 15-May-12 2:58am

Sebastian T Xavier

Anuja Pawar Indore · Answer 3 · 2012-05-15T04:38:00

Solution 3

Refer this
http://stackoverflow.com/how-to-retrieve-the-values-in-asp-net-form-from-sql-server-2005[^]
http://support.microsoft.com/kb/308100[^]
http://stackoverflow.com/how-to-retrieve-column-value-of-sql-server-table-and-store[^]

Posted 15-May-12 4:38am

Anuja Pawar Indore