Запрос в DataGridView через combobox

Question

У меня есть форма и база данных в vb.net, в которой, с помощью DataGridView, отражаются различные запросы с помощью кнопок. Но я бы хотел сделать так, чтобы вместо кнопок пользователь мог выбрать вариант из combobox, и на его основе получить запрос в DataGridView. Пример на фото:

Код формы с запросами:

Public Class Form12 Private Sub Form12_Load(sender As Object, e As EventArgs) Handles MyBase.Load conn.ConnectionString = "Server=127.0.0.1;User id=root;password=root;database=repair" conn.Open() RefreshGrid1()

End Sub
Public Sub RefreshGrid1()
    FillGrid(Grid6, "select * from products", "products")
End Sub

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
    Me.Hide()
    Form1.Show()
    conn.Close()
End Sub

Private Sub Button1_Click(sender As Object, e As EventArgs)
    RefreshGrid1()
End Sub

Private Sub Button3_Click(sender As Object, e As EventArgs) Handles Button3.Click
    FillGrid(Grid6, "select product_name,company,model,specifications,warranty_period from products  where product_name='Холодильник'", "products")
End Sub

Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click
    FillGrid(Grid6, "select product_name,company,model,specifications,warranty_period from products  where product_name='Фен'", "products")
End Sub

Private Sub Button5_Click(sender As Object, e As EventArgs) Handles Button5.Click
    FillGrid(Grid6, "select product_name,company,model,specifications,warranty_period from products  where product_name='Стиральная машина'", "products")
End Sub

Private Sub Button6_Click(sender As Object, e As EventArgs) Handles Button6.Click
    FillGrid(Grid6, "select product_name,company,model,specifications,warranty_period from products  where product_name='Машина для бритья'", "products")
End Sub

End Class

БЛОГ НА HUSL

Запрос в DataGridView через combobox

Ответы (0 шт):