DataGridView — фильтрация по датам

Dim str_date_from As String = Date_From.Value.Date
Dim str_date_to As String = Date_To.Value.Date
 
tmpStr = "SELECT * FROM [main_base] WHERE [Дата] BETWEEN ('" & str_date_from & "') AND ('" & str_date_to & "')"

Private Sub DateTimePicker2_ValueChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles DateTimePicker2.ValueChanged
        BindingSource.Filter = "Date >= '" & DateTimePicker1.Text & "' AND Date <= '" & DateTimePicker2.Text & "'"
End Sub

 Dim str_date_from As Date = Date_From.Value.ToString("MM/dd/yyyy")
 Dim str_date_to As Date = Date_To.Value.ToString("MM/dd/yyyy")
 tmpStr = "SELECT * FROM [main_base] WHERE [Дата] >= '" & str_date_from & "' AND [Дата]<= '" & str_date_to & "'"

Dim str_date_to As String = Date_From.Value.ToString("dd/MM/yyyy")

Dim _date_from As Date = Date_From.Value
 Dim _date_to As Date = Date_To.Value
 
 commandText= "SELECT * FROM [main_base] WHERE [Дата] between @date_from AND @date_to"
 
Dim command As New SqlCommand(commandText, connection)
command.Parameters.Add("@date_from ", SqlDbType.Date) ' Не могу проверить
command.Parameters("@date_from ").Value = _date_from 
' аналогично для @date_to

 Dim str_date_from As String = Date_From.Value.ToString("MM\/dd\/yyyy")
 Dim str_date_to As String = Date_To.Value.ToString("MM\/dd\/yyyy")
 
tmpStr = "SELECT * FROM main_base WHERE ([Дата] BETWEEN #" & str_date_from & "# AND #" & str_date_to & "#)"