Searching between two dates

Question

I have a C# program that assembles a report and can filter by name, but I want to go further, I wanted to pull all the records between two dates. Good as I do to assemble the WHERE of that filter by dates ?

Since I already have a Tableadapter in which it filters my records by name

Code of what you name:

SELECT `ID_Pacote`, `Nome`, `peca`, `Quantidade`, `Data_entrada`, `Data_saida` FROM `pacote`
WHERE Nome = @nome

Answer 1

Test like this:

SELECT `ID_Pacote`, `Nome`, `peca`, `Quantidade`, `Data_entrada`, `Data_saida` 
FROM `pacote`
WHERE data_entrada between @data1 and @data2.