Plz help me to find whether the entered salary is between defined range

Question

1.00/5 (3 votes)

See more:

I hav Table(BasicSalaryDefine) where 2 fields i.e FromAmount And ToAmount is defined...

and in another table(CorporateTitle) there is Salary field...

Ihav to chek the entered salary(in CorporateTitle) is between the RAnge or not

if it is in range then save otherwise not to save

plz guyz help me

Posted 18-Jan-12 20:54pm

abhay7

Updated 19-Jan-12 5:22am

Tech Code Freak

v2

Add a Solution

Comments

OriginalGriff 19-Jan-12 3:01am

We need a little more information - language? VB? C#? Javascript? SQL stored procedure? Or what?
What have you tried so far?
Use the "Improve question" widget to edit your question and provide better information.

Jephunneh Malazarte 19-Jan-12 3:03am

ouch... am having a nosebleed.
you want it implement on the server side or client side or sp logic?

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)

Tech Code Freak · Accepted Answer · 2012-01-19T05:09:00

Solution 1

First get your TextBox value in some variable (say sal).
Retrieve values (say minSal & maxSal) from your DataBase Table.
Then check whether entered salary is between the two retrieved values:

C#

if(sal<=maxSal && sal>=minSal)
{
  //save sal in DataBase
}
else
{
  //Generate an error
}

And you're done!

Posted 19-Jan-12 5:09am

Tech Code Freak

Updated 19-Jan-12 5:11am

v2