VB.NET SQL 连接两个表

在VB.NET中连接两个SQL数据库表通常涉及使用ADO.NET，这是一种.NET框架下的数据访问技术。下面是一个基本的例子，展示如何使用SqlConnection和SqlCommand对象来连接两个表：

Imports System.Data.SqlClient

Public Sub ConnectAndJoinTables()
    ' 定义数据库连接信息
    Dim connectionString As String = "Data Source=your_server;Initial Catalog=database1;Integrated Security=True;"
    
    ' 创建SqlConnection对象
    Using connection As New SqlConnection(connectionString)
        Try
            ' 打开连接
            connection.Open()

            ' 创建SqlCommand对象
            Dim command As New SqlCommand("SELECT * FROM table1 INNER JOIN table2 ON table1.common_column = table2.common_column", connection)

            ' 执行查询并获取SqlDataReader
            Using reader As SqlDataReader = command.ExecuteReader()
                ' 遍历结果集
                While reader.Read()
                    Dim row1Value = reader("column_name_in_table1")
                    Dim row2Value = reader("column_name_in_table2")

                    ' 对数据进行处理
                    Console.WriteLine($"Row1 Value: {row1Value}, Row2 Value: {row2Value}")
                End While
            End Using
        Catch ex As Exception
            Console.WriteLine("Error occurred: " & ex.Message)
        Finally
            ' 关闭连接
            connection.Close()
        End Try
    End Using
End Sub

在这个例子中，你需要将`your_server`, `database1`, `table1`, `table2`, `common_column`以及`column_name_in_table1`和`column_name_in_table2`替换为你实际的数据库信息和表字段名。