hi all! i have here a code
Code:Private Sub CheckBox1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CheckBox1.CheckedChanged
mycommand = New MySqlCommand
Dim daMyName As New MySqlDataAdapter
Dim dsMyName As New DataSet
Try
connection()
mycon.Open()
With mycommand
.Connection = mycon
.CommandText = "Select * from finaltickettable where work_group = '" & CheckBox1.Text & "' and date_handled = '" & DateTimePicker1.Value & "'"
.ExecuteNonQuery()
End With
daMyName.SelectCommand = mycommand
daMyName.Fill(dsMyName)
Dim sql2 = "Select * from finaltickettable where work_group = '" & CheckBox1.Text & "' and date_handled = '" & DateTimePicker1.Value & "'"
If CheckBox1.Checked = True Then
With ListView1
.Clear()
.View = View.Details
.FullRowSelect = True
.GridLines = True
.Columns.Add("Fault Number", 150)
.Columns.Add("Reported Date", 150)
.Columns.Add("Fault Description", 150)
.Columns.Add("Work Group", 150)
.Columns.Add("SubTeam", 150)
.Columns.Add("Service Type", 150)
.Columns.Add("PL Number", 150)
.Columns.Add("Fault Type", 150)
.Columns.Add("User", 150)
.Columns.Add("Date/Time Handled", 150)
FillListView(ListView1, GetData(sql2))
End With
Label3.Text = ("Team A Exported!")
ElseIf CheckBox1.Checked = False Then
Label3.Text = ""
End If
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
the bold part is my problem. its about date time picker. there is no error but whenever i choose a date that was handled on the specific day, there is no data displayed in my excel file with the selected date. but in my database, there was a ticket handled on the day that i picked kindly help me
