AboutSyed Rizwan Muhammad Rizvi Expertise I can answers questions regarding web based and desktop based programming in VB.Net. Which can include SOAP, XML, Custom Controls, COM Interoperability etc.
Experience Have been working in this specific area for last 2 years previously I was a VB 6 Developer with experties in other languages as well. Total 10 years of programming experience.
myd = .runQuery("SELECT Lastname, Firstname, Barangay, TypeofSeed, TypeofArea FROM tbltrcclient & " WHERE Lastname LIKE '" + TextBox2.Text + "' OR Firstname LIKE '" + TextBox3.Text + "' OR & " Barangay = '" + ComboBox6.Text + "' OR TypeofSeed = '" + ComboBox1.Text + "' OR (TypeofArea = '" + ComboBox3.Text + "' & " OR '" + ComboBox2.Text + "') ")
take note of my last field, it has two combobox. it doesn't work well because of it. how do i recode it for it to function well? field TypeofArea has two combobox to select by the way.
Answer Should be:
myd = .runQuery("SELECT Lastname, Firstname, Barangay, TypeofSeed, TypeofArea FROM tbltrcclient WHERE Lastname LIKE '" + TextBox2.Text + "' OR Firstname LIKE '" + TextBox3.Text + "' OR Barangay = '" + ComboBox6.Text + "' OR TypeofSeed = '" + ComboBox1.Text + "' OR (TypeofArea = '" + ComboBox3.Text + "' OR TypeofArea = '" + ComboBox2.Text + "') ")
