Datagridview not displaying
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()
Re: Datagridview not displaying
try this:
vb.net Code:
WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("@startdate", DateTimePicker1.Value)
WorkOrdersAdmin.WorkOrderCommand.Parameters.AddWithValue("@enddate", DateTimePicker2.Value)
Re: Datagridview not displaying
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.
Re: Datagridview not displaying
i use oracle db, but aren't u missing an execute statement?