Member Avatar for _::suhanna::_

hi..
im using vb.net

can u guys help me..

i dont know why error still come...
whats wrong with my coding?

dis 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 the program
this error will out "No value given for one or more required parameters"

please help me...
im in urgent..


thanks.

  • 3 Contributors
  • 4 Replies
  • 100 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by _::suhanna::_
Member Avatar for Narue

You're missing a comma between the address and handphone arguments in your call.

Member Avatar for _::suhanna::_

You're missing a comma between the address and handphone arguments in your call.

i already put a comma between address and handphone,but error still come
and this time is "Syntax error in UPDATE statement"

it is anything with my code?

thanks..

Member Avatar for Jx_Man

yes, you don't have parameter to update. i mean your key to update. your code its not specify who to update.
you need key :
where KeyName = ???. ex : where IdMember='"123"'
and you loosing to add single quote :

ExecuteSqlCommand("update member set tmembername='" & membername & "', taddress='" & address & "' and handphone='" & handphone & "' Where IdMember = '"???"' " )
Member Avatar for _::suhanna::_

hello u guys...

thanks for helping me...

im done now..sorry for the late reply..

thanks again..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.