no value given...
-
hi..
im working with vb.net
i got a few problem..can u guys help me out...
1. can u all tell me
whats wrong with my code
Public Sub UpdateMember(ByVal membername As String, ByVal address As String, ByVal handphone As String)
ExecuteSqlCommand("update member set tmembername=" & membername & " taddress='" & address & "' and handphone='" & handphone & "'")
End Sub
when i running this error msg will out..
"No value given for one or more required paremeters"
please help me..im in urgent..
thanks...
-
hiii..
thanks for helping me..but its still got error..
Public Sub UpdateMember(ByVal membername As String, ByVal address As String, ByVal handphone As String)
ExecuteSqlCommand("update member set tmembername='" & membername & "'," & " taddress='" & address & "', and handphone='" & handphone & "'")
End Suband error msg is..."Syntax error in UPDATE statements"
actually i dont know vb.net very well.
thanks
-
write like this
ExecuteSqlCommand("update member set tmembername='" & membername & "',taddress='" & address & "', handphone='" & handphone & "'")
-
i can update...
but...
all the data in member table also update..let say i have 5 data in table member...
i want update data no 4..
but after i press update then all the data becomes like no 4.
i think i should put WHERE statements rite?
-
hello u guys...
thanks for helping me...
im done now..sorry for the late reply..
thanks again..
Post a reply
Quick links
Recent activity
- arif ahmad replied to How to receive data in web ...
- William Thompson replied to What is the name of the Win...
- Sameera Piyadigamage replied to Point of Sale Developers: H...
- Scott Carline replied to 4 x C# Developers for large...
- Rajendra Dhakal replied to Restore SQL Server text dat...
- cloud rainda replied to How to convert between TS f...
Enter your message below
Sign in or Join us (it's free).