manully generate ID for sql server.

<i><b>Originally posted by : simon (scht80@hotmail.com)</b></i><br />hiye all...<br />I'm very new to vb.net and asp.net please pardon my stupidity...<br />does anyone know how to manually generate the ID column for sql server2000 using VB.net?<br /><br />for example if the table has no data, the Id would be set to 1 and if there is already some data, i would like to add 1 to it.<br /><br />Can anyone help me in here?<br />thanks in advance people..<br /><br /><br /><br /><br />

<i><b>Originally posted by : Doug Hagerman (DougH@Usbs-Panels.com)</b></i><br />Sometimes instead of generating the Id through code its better to let Sql Server do it.<br /><br />When you are in design mode for creating a table, click on your "Record_Id" column and then look down at the bottom left of the screen. You will see an (Identity) Property. Change its value to yet. Made sure your field value is like numeric (that way you don't have to worry about its size).<br /><br />In most cases this will take care of your needs. Its a lot easier than Sequences in Oracle.<br /><br />...<br />Doug<br /><br /><br /><br />------------<br />simon at 4/22/2002 9:19:50 PM<br /><br />hiye all...<br />I'm very new to vb.net and asp.net please pardon my stupidity...<br />does anyone know how to manually generate the ID column for sql server2000 using VB.net?<br /><br />for example if the table has no data, the Id would be set to 1 and if there is already some data, i would like to add 1 to it.<br /><br />Can anyone help me in here?<br />thanks in advance people..<br /><br /><br /><br /><br />