How to get nextval while inserting a row to database

I try to make something or set an option, which would generate next values of the id of some table (id is primary key) while inserting a row to the table. I used once a sequence for Oracle database and wonder if there is something similar in .Net for "standard" database (Add new item -> SQL Database). I'm using SqlDataSources.

Is Repeater a component that would be useful here? Or shall i write a function that would generate ids manually?

Thanks in advance

I think what you want is an IDENTITY column. Here's a simple article with exampleshttp://www.databasejournal.com/features/mssql/article.php/3307541 and here's the more detailed stuff from MSDN http://msdn2.microsoft.com/en-us/library/aa933196(SQL.80).aspx

|||

Yes, it works now! I didn't noticed 'Column properties' in table definition ^_^

That was exactly what i was looking for - thanks!