Sure,

Make a column in the table your querying and set it to "Autonumber" type.

When you are working in .net with ado.net you can insert your row into a
datatable or dataset and after committing the update you can read the column
value back in.  You know, in case you are adding child records, providing a
tracking number, and so on.