Scope_Identity Does Not Return Anything!

Hi,

I want to capture the last inserted ID field for a table so that i can use it to display the last entered record on a formview. (ReadOnly Mode) 

This should happen straight away after that new record is inserted. I wrote the following code, but my results variable is always null.

 1 protected void FormView1_ItemInserted(object sender, FormViewInsertedEventArgs e)
2 {
3 //Get the CarID for the newly created record
4 SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
5 SqlCommand sqlcomm = new SqlCommand("SELECT SCOPE_IDENTITY()", conn);
6 conn.Open();
7 string results = sqlcomm.ExecuteScalar().ToString();
8 conn.Close();
9
10 Session["id"] = results;
11 FormView1.ChangeMode(FormViewMode.ReadOnly);
12 }