Good morning forum. I have run into some trouble that i'm unable to fix >_< It does not give me an error but just doesn't display anything in the datagridview. Any help is appreciated. Thank you

Code:
DateTimePicker1.Format = DateTimePickerFormat.Custom
        DateTimePicker1.CustomFormat = "yyyy-MM-dd"
        DateTimePicker2.Format = DateTimePickerFormat.Custom
        DateTimePicker2.CustomFormat = "yyyy-MM-dd"

        Try
            WorkOrdersAdmin.WorkOrderCommand.commandtext = "SELECT work_order_id as 'Work Order Number',work_order_type AS 'Work Type', equipment_number AS 'Equipment Number',priority AS Priority,open_date AS 'Open Date' FROM work_orders WHERE DATE(open_date) >= @startdate AND DATE(open_date) <= @enddate;"
            WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("startdate", DateTimePicker1.Text)
            WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("enddate", DateTimePicker2.Text)
            WorkOrdersAdmin.WorkOrderAdapter.selectcommand = WorkOrdersAdmin.WorkOrderCommand
            WorkOrdersAdmin.WorkOrderAdapter.fill(WorkOrdersAdmin.WorkOrderClosedData)
            WorkOrdersAdmin.DataGridView2.DataSource = WorkOrdersAdmin.WorkOrderClosedData
            WorkOrdersAdmin.WorkOrderCommand.parameters.clear()
        Catch MysqlError As MySqlException
            MessageBox.Show("Error: " & MysqlError.Message & Environment.NewLine & "Error No. " & MysqlError.Number)
            Me.Dispose()