increment the value of id in windows application(net) through database

if i click a button the last value in id should be incremented and displayed in the textbox in windows application(.net).

eg..

in database there are 10 records.开发者_开发知识库.. in the column id from 1 to 10... if i click the button the value should be increment and 11 should be shown in my textbox in windows application.. please send as soon as possibe

You need to specify that the ID column in your DB is an "identity" column. Then, when you insert a new record into the table, SQL will automatically assign the new record with the previous highest value in that column incremented appropriately (you can have SQL increment by 1 or more if you wish).

David Hayden wrote up a nice little article on this very subjectlink text: http://www.davidhayden.com/blog/dave/archive/2006/02/16/2803.aspx