Click here to Skip to main content
5,787,682 members and growing! (20,716 online)
Email Password   helpLost your password?
Desktop Development » Edit Controls » General     Intermediate

Numeric Edit Control

By Oscar Bowyer

A TextBox control that validates different numeric types.
C#Windows, .NET, .NET 1.0, Win2K, WinXPVS.NET2002, Visual Studio, Dev

Posted: 25 Feb 2003
Updated: 25 Apr 2003
Views: 131,508
Bookmarked: 46 times
Announcements
Loading...



Search    
Advanced Search
Sitemap
29 votes for this Article.
Popularity: 5.73 Rating: 3.92 out of 5
2 votes, 6.9%
1
2 votes, 6.9%
2
3 votes, 10.3%
3
13 votes, 44.8%
4
9 votes, 31.0%
5

NumEdit Image

Introduction

Building database data entry applications raises many questions. The one I want to discuss here is, "When should one validate user input?" Catching invalid data entry at the earliest possible point - while the user is typing - can have great advantages. Validating after entry such as during the LostFocus() event works, but you are faced with difficult choices. 1) Send the focus back if data is invalid, possibly causing the user to get "stuck" in a control or 2) Allow the focus to move with invalid data and the user must return to the invalid control to correct the problem.

With the purpose of stopping invalid data entry before it happens, let's take a look at the NumEdit Control.

Key Considerations

I wanted to be able to easily handle a variety of different .NET basic numeric data types such as various size floating point and integer types as well as Currency (internally treated as Decimal). Adding an IsDigit() check in the KeyPress event could handle much of the work, but there would be a few things missing.

First, digit-only filtering doesn't allow the decimal point or the negation "-" character. With a few changes we can allow negative numbers and a the decimal point, but the code rapidly becomes messy dealing with duplicate decimals and negative characters only in the first position.

Second, and possibly more important, is the numeric value entered. If we are working with .NET 32 bit integer values for example, then we need to stop further entry once the maximum value of an integer is typed. Otherwise we will be dealing with overflow errors.

For this reason, I chose to use the Type.Parse() method to test for valid typing. If the Parse() method throws an exception, then we know the KeyPress character is not valid and it should be canceled. This technique stops overflow errors when converting our TextBox string into numeric values. It also stops duplicate decimals as well as duplicate negation ("-") characters.

Last is pasting. Using IsDigit() in the KeyPress event will stop Ctrl+V paste keys but your users may like using Ctrl+V paste. How would you feel if Ctrl+V paste was removed from VS.NET? Adding handling for Ctrl+V paste will make our control a finished, production ready component.

Using the Control

The beauty of this control is that you never need to think about numeric data entry again. Simply add the control, set the InputType property and you're ready to go.

The IsValid() method is the heart of the NumEdit control. There are a few preliminary checks at the beginning of the method that handle the initial negation ("-") character, any leading "0" characters, and empty strings. The remainder of the method simply attempts to parse the string into the selected data type and returns false if any exceptions are thrown. If the IsValid() method returns false, the KeyPress event removes the current keystroke.

private bool IsValid(string val)
{
	// this method validates the ENTIRE string

	//	not each character

	// Rev 1: Added bool user param. This bypasses preliminary checks

	//	that allow -, this is used by the OnLeave event

	//	to prevent

	bool ret = true;

	if(val.Equals("")
		|| val.Equals(String.Empty))
		return ret;
	
	if(user)
	{
		// allow first char == '-'

		if(val.Equals("-"))
			return ret;
	}

//	if(Min < 0 && val.Equals("-"))

//		return ret;


	// parse into dataType, errors indicate invalid value

	// NOTE: parsing also validates data type min/max

	try
	{
		switch(m_inpType)
		{
			case NumEditType.Currency:
				decimal dec = decimal.Parse(val);
				int pos = val.IndexOf(".");
				if(pos != -1)// 2 decimals + "."

			           ret = val.Substring(pos).Length <= 3;
			    //ret &= Min <= (double)dec && (double)dec <= Max;

				break;
			case NumEditType.Single:
				float flt = float.Parse(val);
				//ret &= Min <= flt && flt <= Max;

				break;
			case NumEditType.Double:
				double dbl = double.Parse(val);
				//ret &= Min <= dbl && dbl <= Max;

				break;
			case NumEditType.Decimal:
				decimal dec2 = decimal.Parse(val);
				//ret &= Min <= (double)dec2 && (double)dec2 <= Max;

				break;
			case NumEditType.SmallInteger:
				short s = short.Parse(val);
				//ret &= Min <= s && s <= Max;

				break;
			case NumEditType.Integer:
				int i = int.Parse(val);
				//ret &= Min <= i && i <= Max;

				break;
			case NumEditType.LargeInteger:
				long l = long.Parse(val);
				//ret &= Min <= l && l <= Max;

				break;
			default:
				throw new ApplicationException();
		}
	}
	catch
	{
		ret = false;
	}
	return ret;
}

Points of Interest

After adding the Ctrl+V pasting code I discovered a default ContextMenu for the base class TextBox that includes a Paste command. This command bypassed all my carefully crafted code and allowed non-numeric values into the NumEdit control. I was unable to find a way to intercept this Paste command. My solution was to simply replace the TextBox ContextMenu with an empty menu, thereby removing the ContextMenu. If anyone has any ideas about overriding this ContextMenu, I would appreciate hearing from you.

Enhancements

After completing the NumEdit control, I thought of a few possible enhancements.

  1. Min/Max property. This would allow restricting the minimum/maximum values inside the data type min/max values.
  2. Positive-/Negative-only property. This could be handled with the Min/Max property so it is redundant but may be easier to use.
  3. Scientific or Engineering notation such as 12.345E10 could be useful.

History

Release 2/17/2003

Rev 1 4/4/2003

  1. Fixed 0 value not allowed.
  2. Added OnLeave handler to avoid "-", "-0", or "000" entries
  3. Added handling for Shift+Insert pasting
  4. Added Min/Max Property IMPORTANT NOTE: This feature has been commented out in the Source Code. VS.NET crashes with no error messages when you attempt to open the visual designer for any form containing NumEdit controls with the Min/Max Property enabled. I have not determined the exact cause, but it appears to be related to the double datatype used by the Min/Max properties. Initial searches indicate a possible bug related to the double.MinValue, double.MaxValue static value handling. NOTE: Using Min/Max values could also be problematic. Take for example a Max value of 100. User enters 20, and the NumEdit control disallows any further entry since any additional digit would exceed 100. This behavior is likely to be confusing to the end user.

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

About the Author

Oscar Bowyer



Occupation: Web Developer
Location: United States United States

Other popular Edit Controls articles:

Article Top
Sign Up to vote for this article
You must Sign In to use this message board.
FAQ FAQ Noise ToleranceSearch Search Messages 
 Layout  Per page   
 Msgs 1 to 25 of 30 (Total in Forum: 30) (Refresh)FirstPrevNext
GeneralWhat License?memberKunalpatel7:00 4 Jun '07  
GeneralMin and Maxmemberchris1755:14 26 Mar '07  
GeneralRe: Min and MaxmemberOscar Bowyer17:10 26 Apr '07  
GeneralBinding supportmemberChals6:44 21 Jun '06  
Generalre: Adding Date and Timememberljscottiii7:40 8 Dec '05  
GeneralDisabling the Context Menumemberro_xxx21:28 3 Nov '05  
Generalany updates?memberDaTom2:30 2 Sep '04  
Generaltrouble with . or , in floatsmemberkenneth nielsen8:01 5 Apr '04  
GeneralPasting bugsusskrugs52510:19 25 Mar '04  
GeneralFound another bug: too many '.'memberGabriel Nica12:01 28 Feb '04  
GeneralRe: Found another bug: too many '.'memberOscar Bowyer15:16 29 Feb '04  
Generalfound a bugmemberJVMFX4:34 29 Aug '03  
GeneralRe: found a bugmemberOscar Bowyer17:35 29 Aug '03  
GeneralA few other enhancements?memberPaul Auger12:53 24 Mar '03  
GeneralUsers can use "Shift + Insert" to input invalid datamemberDuNguyen2:55 10 Mar '03  
GeneralRe: Users can use "Shift + Insert" to input invalid datamemberPaul Auger11:50 24 Mar '03  
GeneralNumEditType.Currency is limited to '.'memberKarlTschuemperlin11:02 1 Mar '03  
GeneralOne small issue: can't just put a '0'sussAnonymous16:15 27 Feb '03  
GeneralRe: One small issue: can't just put a '0'memberOscar Bowyer17:56 27 Feb '03  
GeneralHandle PastememberDavid M. Kean11:49 26 Feb '03  
GeneralRe: Handle PastememberOscar Bowyer13:28 26 Feb '03  
GeneralRe: Handle Pastememberrandom.placeholder23:40 26 Feb '03  
GeneralRe: Handle PastememberDavid M. Kean10:12 27 Feb '03  
GeneralRe: Handle PastememberMerlin900011:11 13 Jun '03  
GeneralAnother Method to considermemberMichael Potter10:53 26 Feb '03  

General General    News News    Question Question    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

PermaLink | Privacy | Terms of Use
Last Updated: 25 Apr 2003
Editor: Nick Parker
Copyright 2003 by Oscar Bowyer
Everything else Copyright © CodeProject, 1999-2009
Web12 | Advertise on the Code Project