how to remove error : must declare the scalar variable

Question

0.00/5 (No votes)

See more:

Hello all,

I am unable to remove this error also i don't know why i am facing these error.
My code block is:

dt.OpenCon();

        SqlCommand cmd = new SqlCommand();

        cmd.Parameters.AddWithValue("@DAY", DateTime.Today.Day);
        cmd.Parameters.AddWithValue("@Month", DateTime.Today.Month);
        
        string str = "SELECT MA_First_Name,MA_Email_Id FROM Master_Applicant WHERE DATEPART(DAY, MA_DOB) = @DAY AND DATEPART(MONTH, MA_DOB) = @Month";
        DataSet ds = dt.ExecuteDataSet(str);

I want to compare Day & month with the Date of birth in table.

How can i remove this error.

Posted 21-Jul-15 23:51pm

Member 11221185

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)

DamithSL · Accepted Answer · 2015-07-22T00:05:00

Solution 1

C#

dt.OpenCon();
string str = "SELECT MA_First_Name,MA_Email_Id FROM Master_Applicant WHERE DATEPART(DAY, MA_DOB) = @DAY AND DATEPART(MONTH, MA_DOB) = @Month";
SqlCommand cmd = new SqlCommand(str);
cmd.Parameters.AddWithValue("@DAY", DateTime.Today.Day);
cmd.Parameters.AddWithValue("@Month", DateTime.Today.Month);
DataSet ds = dt.ExecuteDataSet(cmd);

I have change the sequence of adding parameters and executing sql statement, first create the command with your sql statement and add parameters to it. finally execute the command.

Posted 22-Jul-15 0:05am

DamithSL

Updated 22-Jul-15 0:07am

v2

Comments

Member 11221185 22-Jul-15 6:35am

thanks for this but previously i did same code but it will shows same error thats the reason change sequence but still showing the same problem

DamithSL 22-Jul-15 6:51am

what is ExecuteDataSet? are you using library/helper class?
any way you can do the same without parameters for example change the sql as

SELECT MA_First_Name,MA_Email_Id FROM Master_Applicant
WHERE Month(MA_DOB) = Month(CURRENT_TIMESTAMP)
AND Day(MA_DOB) = Day(CURRENT_TIMESTAMP)

Member 11221185 22-Jul-15 7:01am

Thank u so much. My problem has been solved.