How to get record count using executescalar

Question

0.00/5 (No votes)

See more:

this is my code but not work:-

C#

void CountTotal()
        {
            con.Open();
            s = "select Count(*) from ResrvationData where Date_Reservation = @Date_Reservation";
            sCommand = new SqlCommand(s , con);
            sCommand.Parameters.AddWithValue("@Date_Reservation", dateTimePicker_Time.Text);
            object count = sCommand.ExecuteScalar();
            if (count != null) txt_TotalBooks.Text = count.ToString();
            con.Close();
        }

private void FRM_Reservation_date_Load(object sender, EventArgs e)
        {
           CountTotal();
        }

What I have tried:

i want display count where data

Posted 15-Feb-16 20:06pm

Member 12244977

Updated 15-Feb-16 20:30pm

koolprasad2003

v2

Add a Solution

Comments

koolprasad2003 16-Feb-16 2:25am

code looks fine, what is the issue ? have you got any error ? I think only conversion is need. see below
Int32 count = (Int32)sCommand.ExecuteScalar();

dan!sh 16-Feb-16 2:27am

Not needed. OP is anyways going to cast it to string.

koolprasad2003 16-Feb-16 2:28am

Yeah. not needed actually.

Member 12244977 16-Feb-16 2:35am

when i change date textbox not changed , i want textbox change when i change date

koolprasad2003 16-Feb-16 2:46am

When your date get changed, does your same code get called ? if it is then it should change the textbox contents, when you change the date what you get in 'dateTimePicker_Time.Text' ?

dan!sh 16-Feb-16 2:26am

What do you see in textbox now?

aarif moh shaikh 16-Feb-16 2:28am

conversion is need, i think datetimepicker returning date with time which is not matching.

[no name] 16-Feb-16 2:29am

Code looks fine. Any exception you are getting.

If no exception then what is the value you are getting now in your textbox?

Member 12244977 16-Feb-16 2:46am

when i change date , count not changed in textbox

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)

OriginalGriff · Answer 1 · 2016-02-15T23:10:00

when i change date , count not changed in textbox

Well - that's because you haven't told it to change.

The code you show calls the CountTotal method in the form Load event - and nowhere else. Which means that the SQL is executed only once: when the form is first loaded. Any changes you make via the DateTimePicker do not automatically update the count at all.
You could try calling the method in your DateTimePicker.ValueChanged Event (System.Windows.Forms)[^] handler.

But please, don't use the Text property of the DTP to check the DB - use the Value property which is already a DateTime directly, so there is no chance of miscommunication between SQL and your app as concerns data formats!