Get ID of inseted row

[acrow]

Can someone please tell me how I would get the ID of the row that was inserted using the following? (VS2012 VB.NET)

Dim connString = ConfigurationManager.ConnectionStrings("DBConnectionString").ToString
        Dim conn As New SqlConnection(connString)

        Dim sqlMembers As New SqlDataSource

        sqlMembers.ConnectionString = connString
        sqlMembers.InsertCommand = "INSERT INTO [Members] ([MemberEmail], [MemberRole], [MemberFirstName], [MemberLastName], [MemberCity], [MemberState], [MemberCountry], [MemberCredits], [MemberJoinDate], [MemberStatus]) VALUES (@MemberEmail, @MemberRole, @MemberFirstName, @MemberLastName, @MemberCity, @MemberState, @MemberCountry, @MemberCredits, @MemberJoinDate, @MemberStatus)"

        sqlMembers.InsertParameters.Clear()

        With sqlMembers
            .InsertParameters.Add("MemberEmail", txtCreateMemberEmail.Text)
            .InsertParameters.Add("MemberRole", "Member")
            .InsertParameters.Add("MemberFirstName", txtCreateMemberFirstName.Text)
            .InsertParameters.Add("MemberLastName", txtCreateMemberLastName.Text)
            .InsertParameters.Add("MemberCity", ddlCity.SelectedValue)
            .InsertParameters.Add("MemberState", ddlState.SelectedValue)
            ' TODO: ADD ADDITIONAL COUNTRIES LATER
            .InsertParameters.Add("MemberCountry", "187")
            .InsertParameters.Add("MemberCredits", "0.00")
            .InsertParameters.Add("MemberJoinDate", DateTime.Now.ToString)
            .InsertParameters.Add("MemberStatus", "Pending")

        End With

        Try
            sqlMembers.Insert()
            Response.Redirect("/article.aspx?slug=new-member-registered")
        Catch ex As Exception
            pnlCreateAccountStatus.Visible = True
            lblCreateAccountStatus.Text = "Sorry something is wrong"
        End Try

[sapator]

You could do it on SQL Sever itself.