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)
...
kayclink
Last Activity: Jan 10 '11, 10:27 AM
Joined: Oct 25 '09
Location:
-
after several updates, data gets lost in other fields
-
Date PROBLEM in VB.NET
Hello, i am getting a problem to generate a report based on a date. iam using vb.net 2005 and SQL 2000. here is my code;
[code=vbnet]
myConnection = New SqlConnection(" Data Source=CALVIN20 09\DEV;Initial Catalog=TBFMS;I ntegrated Security=True;d atabase = TBFMS")
MyCommand.Conne ction = myConnection
'If Main.ManifestDa tagrid.Selected Rows.Count > 0 Then
... -
thank you so much. it helped so sort out the problem... -
Invalid Column name
hi, i am trying to generate a report through a record in a combo box but i get this error "invalid column name "DFG55FS"
Please note "DFG55FS" is a record name in my combobox. please help
i am using vb.net 2005 and SQL 2000
my code here..
"select *from Booking2 where horsereg =" & Me.ComboBox1.Te xt
No activity results to display
Leave a comment: