Community discussion forum

how to update multiple entries

• • Reply

  1 year ago

  by leo.lvng

  leo.lvng

  , India

  Joined 1 year ago

  hello sir

  i have one field in database name (Fine)

  i have one listbox control having list of the data in(digit)

  i wanna update this all data simultaneously

  how can i do this

  i got problem in front end

  that conversion of string(update fine set fine=...) to double is not valid

  i used:

  for i=0 to listbox1.items.count-1

   

  update fine set fine='"+listbox1.items(i)+"'"

  ktcmd.executenonquery

  next

   

  Report abuse
• • Reply

  1 year ago

  by khari6579

  Hari K

  Chennai, India

  Joined 4 years ago

  Hi

   You have made one problem in the string concatination.

    update fine set fine="+listbox1.items(i)+" " [remove the single quote]

  I hope this will solve your problem

  Good Luck

  Hari K......

   

  Report abuse