Data selected error of ADO VB6?

dim dta as integer
dta=35
strsql = "INSERT INTO phc_master (phc_id) VALUES ( " & Val(dta) &”)"

1- what are method or way I can store integer value into database please give all through full code
2- how to store value of selected combo1 in a variable vikas1 give code
1 answer 1