if there is no data in my database then how can i show the message .....

Question

1.00/5 (2 votes)

See more:

hye! i can find out or fetch out data betn two dates but i wanna ....if there is no data betn two dates then how can i show the message that there is no data in ur database that in selected dates.......can any one help me to do that plz.....

Posted 14-Nov-11 8:13am

sammsul

Add a Solution

Comments

Sergey Alexandrovich Kryukov 14-Nov-11 15:18pm

Tag it properly. If this is about CrystalReports, tag it.
--SA

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)

OriginalGriff · Answer 1 · 2011-11-14T08:20:00

Solution 1

Depends on how you are retrieving the records.
If you are using an SqlCommand object and an SqlDataReader, then check the DataReader.HasRows[^] property.

If not, what are you using?

Posted 14-Nov-11 8:20am

OriginalGriff

Comments

sammsul 14-Nov-11 14:32pm

i use Crystalreport for retrieving the records ....when i passing two dates from my app. to SQl database ...if passing dates get any data bet two dates then showing with data and also without data some time...but i do not want to show crystalreport if there is no data in my database then what i do...help me plz

OriginalGriff 14-Nov-11 14:50pm

I don't use Crystal reports so I don't know if there is a way to say "don't bother reporting if you have no data".
Personnally, I would check the DB directly:
SELECT COUNT(*) FROM MyTable WHERE dateColumn BETWEEN @START AND @END
Execute that as a scalar and it will give you just the count.

RAHUL77758 · Answer 2 · 2011-11-15T23:18:00

Solution 2

if Datagridview1.rowcount=0 then

msgBox ".........."

End If

Posted 15-Nov-11 23:18pm

RAHUL77758