Newly Inserted Record RowID To A Label Control

Greetings all,

I am tring to capture the ID of a newly inserted record from a form to a label that I will reference in a reciept page.  I intend to pass the rowid to retrieve record information on other pages.

The insert suceeds... I just need to capture the auto generated ID for the new row to a label on the page post onclick.  Any thoughts?

 

 

 

Dim MySQL As String = "Insert into dropkick (name, status, payroll, unit, contactnumber, email, equipment, issue, timein) values (@name, @status, @payroll, @unit, @contactnumber, @email, @equipment, @issue, @timein)"Dim myConn As SqlConnection = New SqlConnection(SqlDataSource1.ConnectionString)

Dim Cmd As New SqlCommand(MySQL, myConn)Cmd.Parameters.Add(New SqlParameter("@payroll", txt_payroll.Text))

Cmd.Parameters.Add(New SqlParameter("@name", txt_name.Text))Cmd.Parameters.Add(New SqlParameter("@status", "W"))

Cmd.Parameters.Add(New SqlParameter("@unit", txt_dept.Text))Cmd.Parameters.Add(New SqlParameter("@contactnumber", txt_cell.Text))

Cmd.Parameters.Add(New SqlParameter("@email", txt_email.Text))Cmd.Parameters.Add(New SqlParameter("@equipment", txt_equipment.Text))

Cmd.Parameters.Add(New SqlParameter("@issue", txt_issue.Text))Cmd.Parameters.Add(New SqlParameter("@timein", lbl_datetime.Text))

myConn.Open()

Cmd.ExecuteNonQuery()

Label1.Visible = "true"

Page.DataBind()

myConn.Close()

Label1.Text = "Your data has been received!"

''LABEL TO BE POPULATED WITH ID OF NEW RECORD

lbl_id.Text = ID