combobox selecteditem [modified]
-
i have used check constarin like this constraint disignation CHECK(Designation IN('Key Person','Assignee')), when i try to enter data using my code it,s getting error on this constrain. in the code i have used combo box and there fixed items.i access this item using "bombobox1.selecteditem" but i check it using msgbox and it,s giving correct word.i,m confused with this coz i have used this on vb.net 2003 now i,m using vs2005 can any one help me my quary string is like this "insert into Complaint values('" & cbocustomerId.SelectedItem() & "','" & cborepID.SelectedItem() & "','" & cbosource.SelectedItem() & "','" & rtxtdescription.Text & "','" & cboempID.SelectedItem() & "','" & txtdate.Text & "','" & cbocatagory.SelectedItem() & "','" & cboFtype.SelectedItem() & "' ,'" & txtvehicleNo.Text & "','" & txtbustop.Text & "','" & cboOp_dept_no.SelectedItem() & "','" & cbostatus.SelectedItem() & "','" & txtrefNo.Text & "','" & txtplace.Text & "')") -- modified at 7:39 Monday 22nd May, 2006