ODBC serial question

I am currently trying to find the best practice using C#.NET and ODBC connection. When I insert a row into a table with a serial I need to retrieve the serial number that was generated. What I need to know is should I do this in a stored procedure, a transaction in C#, or a different method all together? Following is how I am currently doing it but I can already see problems with doing it this way. insert into test(indexno) values('7'); select first 1 dbinfo('sqlca.sqlerrd1') from systables; Thanks, Nate Buchholz nbuchhol@genesyspho.com