Hi Yes but remember always the new ID generated is greater than the last one you insert. I'll send you(maybe today) a complete application(C#) with SQLServer solution how to do it Huseyin

Hi I think I've got something it can help you on www.codeproject.com/cs/database/DBManipulationADONET.asp Huseyin Altindag

Hi have a look at my project here www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp I think and hope it will help you Huseyin Altindag

Hi have a look here.it should be something what you look for www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp#xx953344xx Huseyin

Hi I sent a solution for this problem to Ronboy in the message boards. Have a look there. hopefully it helps you. bye HuseyinAltindag

Hi Ronboy, There is a way doing that.What you need to do is : -Fire a KeyPress event in properties for your TextBox this.textBox.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox_KeyPress); private void textBox_KeyPress(object sender, System.Windows.Forms.KeyPressEventArgs e) { if (!Char.IsDigit(e.KeyChar) && e.KeyChar !=(char)8) e.Handled=true; } So you can enter now in the TextBox ONLY integers AND Backspace-key with (char)8 . e.KeyChar means it gets the char which is correspending to the key you pressed. e.Handled=true; means if you entered a non-integer value(0-9) you don´t pass this char to control element(TextBox). good coding Bye Huseyin Altindag Huseyin Altindag

Hi Larry I think I´ve got something for you I can send you as attached zip file email me Huseyin