Improve company productivity with a Business Account.Sign Up

x
?
Solved

Reflect through control that SQL table has data

Posted on 2004-08-20
4
Medium Priority
?
227 Views
Last Modified: 2010-04-23
Hi everybody:

I would like visually indicate on Win Form that specific SQL table has data in it. Nice thing would be to indicate what time data was loaded into SQL.

Any ideas would be appreceated.

RGDS
Sam
0
Comment
Question by:BOOBIC
  • 2
  • 2
4 Comments
 
LVL 28

Expert Comment

by:iboutchkine
ID: 11854462
Execute SQL
select count(*) from Table

and return the qty of records in the table
0
 

Author Comment

by:BOOBIC
ID: 11856480
iboutchkine,

Thank you  for your post. If I want to show that I have records in a SQL table at the front end through changing colors on checkbox, how to do that?

RGDS
Sam
0
 
LVL 28

Accepted Solution

by:
iboutchkine earned 800 total points
ID: 11880851
After you executed the count SQL you know how many records in your SQL table
if count = 0 then paint your checkbox in one color. If the count > than 0 than paint it to another
0
 

Author Comment

by:BOOBIC
ID: 11882399
iboutchkine,

Thank you for your post. Your points submitted.

RGDS
Sam
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

595 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question