hi again everyone...i have here an attach image of my problem.... items in year level came from my database...what i wanted is that their would be no repitition...is this possible? please help
Use DISTINCT keyword inside you sql query statement (since you said these data come from database).
"SELECT DISTINCT column_name(s) FROM table_name"
thanks a lot.. one more thing about this other attach image...i don't know why Section 1 & 2 are place in the last it should be above section 3
In sql SELECT statement use ORDERBY columnName
"SELECT DISTINCT column_name(s) FROM table_name ORDERBY columnName"
"select * from SetSched where YearLevel = '" & ComboBox1.Text & "' And Buildings = '" & ComboBox14.Text & "' And Sessions = '" & ComboBox13.Text & "' ORDERBY Sections ""
what's wrong with this?