Get Last Identity of column in Sql Server 2008

I'm not sure exactly what you are trying to do, but I assume you have a problem because this is an identity column and you need the identity value in your form before you save the record?

In short, you can't.

An Identity value is assigned by the database system when the record is saved, to prevent it being duplicated in any way: only the database can assign the value, and only when teh record is first saved. Attempts to assign it yourself, will cause an error.

All you can do is save the record, read it back to get the ID and then display it.

If you actually need the ID value, then I would strongly suggest you use GUID values instead: these are assigned by your code rather than the database and can be pre-generated and never used if the data is not saved.