Hi
I have an update command that works fine, but when I update the record let's say twice or thrice, some data gets losts in the database in certain fields.
E.g
Dim str as string = "update booking set name= '"&me.fname.tex t &'",lname='"&me .lname.text &'"where bookingid='"&me .booingid.text
&'
"'"
Dim command as new sqlcomand (str, con)
Con.open
Command.excuten onquery()
Con.close
It updates but certain fields become blank after several updates. Plz help
I have an update command that works fine, but when I update the record let's say twice or thrice, some data gets losts in the database in certain fields.
E.g
Dim str as string = "update booking set name= '"&me.fname.tex t &'",lname='"&me .lname.text &'"where bookingid='"&me .booingid.text
&'
"'"
Dim command as new sqlcomand (str, con)
Con.open
Command.excuten onquery()
Con.close
It updates but certain fields become blank after several updates. Plz help