By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,034 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,034 IT Pros & Developers. It's quick & easy.

after several updates, data gets lost in other fields

P: 4
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.text &'",lname='"&me.lname.text &'"where bookingid='"&me.booingid.text
&'
"'"
Dim command as new sqlcomand (str, con)
Con.open
Command.excutenonquery()
Con.close
It updates but certain fields become blank after several updates. Plz help
Jan 10 '11 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.