SELECT COUNT Query In OlebExecuteScaler

Question

0.00/5 (No votes)

See more:

Hi all.

which line in the below code is wrong :

C#

public string Sele_count_dont_pay_ghest(string U_today)
       {
           string ret = string.Empty;
           string select_count_with_today = "SELECT COUNT(*) FROM ghesting WHERE (date_ghest <= ? )";
           OleDbParameter[] pp = new OleDbParameter[1];
           pp[0] = new OleDbParameter("date_ghest", OleDbType.Char);
           pp[0].Value = Convert.ToString(U_today);
          // a.Query_select_all_command(select_count_with_today);
         ret =  a.Query_Select_ExecuteScaler(select_count_with_today).ToString();

         return ret;

       }

I have following error :
No value given for one or more required parameters.

thanks.

Posted 12-Mar-15 3:32am

bernova

Add a Solution

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)

ZurdoDev · Answer 1 · 2015-03-12T03:39:00

Solution 1

You never added the parameter to the command Object.

Do something like this:

C#

string select_count_with_today = "SELECT COUNT(*) FROM ghesting WHERE (date_ghest <= ? )";
cmd.Parameters.AddWithValue("@date", U_today.ToString();

using .Parameters.AddWithValue() means you can add the parameter in one line of code and is much easier to read.

Posted 12-Mar-15 3:39am

ZurdoDev

Updated 12-Mar-15 4:02am

v2

Comments

Richard Deeming 12-Mar-15 9:55am

Almost perfect, except that OleDbCommand doesn't use named parameters. :)

ZurdoDev 12-Mar-15 10:02am

Thanks. I updated it and put it back to a question mark. It appears that it's just the order you add parameters in that is important.

bernova 12-Mar-15 11:13am

thanks . but i have same error
when remove WHERE statement , the query run correctly.

ZurdoDev 12-Mar-15 11:30am

Show your code then.