Populating Data from two different tables in a Single DropdownList

Step 2: main.aspx.vb

Dim myconnection As New SqlClient.SqlConnection("Server=localhost;uid=sa;password=;database=northwind;")

Dim myda As New SqlClient.SqlDataAdapter("Select * from tb_USA", myconnection)

Dim ds As New DataSet()

myda.Fill(ds, "tb_USA")

myda.SelectCommand.CommandText = "Select * from tb_India"

myda.Fill(ds, "tb_India")

Dim i, j As Integer

Dim dc As DataColumn

Dim mystrval As String

Dim dt As DataTable

Dim dr As DataRow

For Each dt In ds.Tables

              For i = 0 To dt.Rows.Count - 1

                        For Each dc In dt.Columns

                                Select Case dc.ColumnName

                                     Case "tb_USA_City"

                                         mystrval = mystrval & dt.Rows(i)(dc.ColumnName).ToString

                                     Case "tb_India_City"

                                        mystrval = mystrval & dt.Rows(i)(dc.ColumnName).ToString

                                 End Select

                        Next

                      DropDownList1.Items.Add(mystrval)

                      mystrval = "" 

              Next

Next