Visual Basic 2010如何根据从2个组合框中的选择搜索数据库

Imports System.Data.SqlClient

Public Class Form1
    Dim connectionString As String = "Data Source=YourServer;Initial Catalog=YourDatabase;User ID=YourUsername;Password=YourPassword"

    Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
        Dim searchValue1 As String = ComboBox1.SelectedItem.ToString()
        Dim searchValue2 As String = ComboBox2.SelectedItem.ToString()

        Dim query As String = "SELECT * FROM YourTable WHERE Column1 = @Value1 AND Column2 = @Value2"

        Using connection As New SqlConnection(connectionString)
            Using command As New SqlCommand(query, connection)
                command.Parameters.AddWithValue("@Value1", searchValue1)
                command.Parameters.AddWithValue("@Value2", searchValue2)

                connection.Open()

                Dim adapter As New SqlDataAdapter(command)
                Dim table As New DataTable()
                adapter.Fill(table)

                DataGridView1.DataSource = table
            End Using
        End Using
    End Sub
End Class