How to read column value from database then check that if that number is greater or less from value entered in textbox

Question

0.00/5 (No votes)

See more:

hi, i have a stock table and there is a Unit column in Unit column only entered the integer value
and then problem is that how to check that the Unit entered in textbox if it is greater or less than colun value and then show message.

Posted 23-Apr-14 6:31am

Ashwani iOS

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)

PIEBALDconsult · Answer 1 · 2014-04-23T06:52:00

Solution 1

A NumericUpDown would likely be better than a TextBox.
If possible, you could then set the MaxValue to the current value in the database.
If not, then pass the value to the database (as a parameter) and perform the comparison there, not in your code.
A technique to consider is to calculate and return the databasevalue-selectedvalue -- a negative result means that too many are requested.

Posted 23-Apr-14 6:52am

PIEBALDconsult

Updated 23-Apr-14 6:53am

v2

Comments

Ashwani iOS 23-Apr-14 13:02pm

if in databse column have 10 unit and in textbox if i enter 5 then it should check and then show message ..please help me how to do that

PIEBALDconsult 23-Apr-14 13:20pm

I thought I had. Go try it.

Ashwani iOS 23-Apr-14 13:22pm

but the data value can be vary...

PIEBALDconsult 23-Apr-14 13:38pm

Yes, of course.