How do I pull sellers in a combobox to then filter the sale per seller?

Asked

Viewed 108 times

1

I have the following table:

VENDAS
------------------------------------------------------------------------------------------------------------
VENDA_ID | VENDA_RAZAOSOCIAL | VENDA_CIDADE | VENDA_DATA | VENDA_FORPAGAMENTO | VENDA_VENDEDOR | VENDA_VALOR

And I use the following SELECT to select the sales:

SELECT * FROM VENDAS WHERE VENDA_DATA>=@dataIni and VENDA_DATA<=@dataFinal and VENDA_VENDEDOR = @vendedor

I already have the INSERT , now I need to know how I can pull the seller to appear in the combobox and so I can click on a button to filter

Someone can help me ?

c#
  • 1

    You can use the System.Data elements to pull everything to a datatable and place the Datasource property of the combobox to search in this Datatable

  • would be like ? using system data ?

  • 1

    Web Forms, WPF, XAML, MVC... What you are using?

  • am using windows Forms c#

  • am using windows Forms c#

  • Someone could help me ?

Show 1 more comment
No answers

Browser other questions tagged c#

You are not signed in. Login or sign up in order to post.