Hi All,
I have some small problem with adding a function that will allow only numbers into the text box.
Can someone help?

Thanks alot.

Here is the code

Code:
 
using System; 
using System.Collections.Generic; 
using System.ComponentModel; 
using System.Data; 
using System.Drawing; 
using System.Text; 
using System.Windows.Forms; 
using Sybase.Data; 
using Sybase.Data.AseClient; 

namespace SID_Checker 
{ 
public partial class Form1 : Form 
{ 
public Form1() 
{ 
InitializeComponent(); 
} 

private void panel1_Paint(object sender, PaintEventArgs e) 
{ 

} 

private void label1_Click(object sender, EventArgs e) 
{ 

} 


private void button1_Click(object sender, EventArgs e) 
{ 

string ID = SID.Text; 

if (ID == "" || ID == "0" || ID == null) 
{ 
label4.Text = "Are you Kidding Me"; 
return; 
} 

// <--> Sybase Connection String and Query <--> 

AseConnection oAseConn = new AseConnection(); 
oAseConn.ConnectionString = "Data Source=10.161.56.162;" + 
"Port=2024;" + 
"User ID=dbs;" + 
"Password=password"; 
oAseConn.Open(); 

AseCommand getsid = oAseConn.CreateCommand(); 
getsid.CommandText = "select SID_num from Sessions where sid = " + ID; 
Object obj = getsid.ExecuteScalar(); 


AseCommand getname = oAseConn.CreateCommand(); 
getname.CommandText = "select code from SID_info where SID_num = " + obj; 
Object targetname = getname.ExecuteScalar(); 

label4.Text = targetname.ToString(); 
getsid.Dispose(); 
oAseConn.Dispose(); 

} 

private void SID_TextChanged(object sender, EventArgs e) 
{ 

} 
} 
}
P.S
I tried using the following but it either did nothing or gave me an error.
Please help me place it at the right place in my code.
thanks

Code:
private void textBox1_KeyPress(object sender, KeyPressEventArgs e) 
{ 
if (!char.IsDigit(e.KeyChar) && e.KeyChar != (char)Keys.Back) 
e.Handled = true; 
}
thanks
Jonny