ComboBox Filtering (Cascading) Problem.

Hello , im develping an university schedule and im having a problem with ComboBox cascading, and im not finding the answer yet.
So what i want to do is to Filter the COURSE based on CATHEDRA and YEAR .
so CATHEDRA is comboBox1 , YEAR is comboBox2 and COURSE is comboBox3.
the Cathedra data is used from the database , but the YEAR numers are used from the comboBox2 EDIT ITEMS ( i put them myself LIKE : 1,2,3,4).

This is the Query im using for that gets me to an error :

cmd.CommandText = ("SELECT idlcourse, name_of_course FROM tblCOURSE WHERE cathedra =@cathedra AND year=@year"); cmd.Parameters.AddWithValue("@cathedra", comboBox1.Text);

cmd.Parametes.AddWithValue("@year", comboBox2.Text);

PS: YEARS attribute type is Numeric(18).
If someone could sove it for me i would be very thankful.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jasmin M12y ago
It says that it cant convert from string to nimeric i tryed to convert Int.parse(combobox2.text) Convert.toint32(...) But no success it says cant bin data smth kike this or ur code sytanx is wrong. Regards
Jasmin M12y ago
It says that cant
Jignesh Trivedi12y ago
hi,

your code look ok.
Are you getting any error?

can you please share what problem your are facing...