Datagridview not displaying

[darknoobie]

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

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()

[.paul.]

try this:

WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("@startdate", DateTimePicker1.Value)
WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("@enddate", DateTimePicker2.Value)

[darknoobie]

Thank you for the reply. The query works. Its the datagridview that wont display. If I add a datagridview on this form it displays. but in the code I need it to update the datagridview on the workordersadmin form.

[m.davide]

i use oracle db, but aren't u missing an execute statement?