Sending Email based on Dropdownlist SelectedItem & Also Insert the Value of dropdown list into SQL Database

I have a web form with dropdown list, named dpRecruiter. I have two SQL tables named GT_Perm_Lookup & GT_UserList.

I joined the two tables and able to pull the 3 field that I need (pk_LookupID, LookupValue & UserEmail) via SQL Inner Join...

What I want to achieve is this: When a user select let's say "John Doe" from the Recruiter dropdown list, I want to send out an email to John Doe alerting him that a form has been submitted and at the same time insert the selected value (pk_LookupID) into the database.

I see that the dropdown list has two properties named: DataTextField="LookupValue" and DataValueField="pk_LookupID but how to get the User_Email is my major problem. Below is my SQL query and my ASP.NET VB code behind...

SELECT  GT_Perm_Lookup.pk_LookupID, GT_Perm_Lookup.LookupValue, GT_UserList.User_Email
FROM GT_Perm_Lookup INNER JOIN GT_UserList ON GT_Perm_Lookup.LookupValue2 = GT_UserList.GM_Username AND Department <> 'Ex Employee'
order by LookupValue asc


 Public Sub BindDropDownListData()
        ' connection string
        Dim connectionString As String = ConfigurationManager.ConnectionStrings("XXXConnectionString").ConnectionString

        ' Sql connection object initialized with connection string used to connect it with Trustaff_MedConnectionString
        Using mySqlConnection As New SqlConnection(connectionString)
            Try
                ' open the Sql connection
                mySqlConnection.Open()
               
                ' Sql Command object initialized with SQL query t
                '  Dim mySqlCommand As New SqlCommand(" SQL Select statement here", mySqlConnection)
                Dim mySqlDataAdapter As New SqlDataAdapter()

                mySqlDataAdapter.SelectCommand = mySqlCommand
                Dim myDataSet As New DataSet
                ' mySqlConnection.Open()


                ' Sql Data Reader to fetch the records row by row in forward direction.
                Dim myDataReader As SqlDataReader = mySqlCommand.ExecuteReader()
               
                If myDataReader.HasRows Then
                    ' read each row fetched using DataReader
                    While myDataReader.Read()
                        Dim li As New ListItem()
                        li.Value = myDataReader("pk_LookupID")
                        li.Text = myDataReader("LookupValue")
                        DropDownList1.Items.Add(li)
                        ' Dim RecEmailArray() As String = myDataReader("User_Email")
                        ' email = RecEmailArray.ToString
                    End While
                End If
                myDataReader.Close()
            Catch ex As Exception
                Label1.Text = ex.Message
            Finally
                ' close the Sql Connection
                mySqlConnection.Close()
            End Try

            DropDownList1.Items.Insert(0, New ListItem("Select Recruiter"))
        End Using
    End Sub

SELECT  GT_Perm_Lookup.pk_LookupID, GT_Perm_Lookup.LookupValue, GT_UserList.User_Email 
FROM GT_Perm_Lookup INNER JOIN GT_UserList ON GT_Perm_Lookup.LookupValue2 = GT_UserList.GM_Username AND Department <> 'Ex Employee'
order by LookupValue asc

Select all Open in new window