hi! i am creating an application that is like an alarm, for example an item in my listbox is "2010-10-24" and the date in my label is also "2010-10-24".
i would like to pop a message that there is a due paper in that date.
my problem is my code below, it does not find the item in listbox and the label equal. i wonder what is the problem, can anyone help me? thanks alot!
Code:Dim connectionstring As String Dim query As String Dim adapter As MySqlDataAdapter Dim table As DataTable connectionstring = "server=localhost;uid=root;pwd=passw0rd;database=purchasing" query = "SELECT due_date FROM request ORDER BY due_date ASC" Try adapter = New MySqlDataAdapter(query, connectionstring) table = New DataTable adapter.Fill(table) ListBox1.DataSource = table ListBox1.DisplayMember = "due_date" For Each item In ListBox1.Items If item.ToString = Label1.Text Then MsgBox("There is a Due Paper today") End If Next




Reply With Quote
