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...
 

Hi,

 The correct sintax of TSQL Update command is:

UPDATE tablename SET field1=value1, field2=value2, field3=value3, fieldN=valueN WHERE condition

First...

You are missing the commas (,) character like a separator between fields and values.

Second...

You are using a clause AND without WHERE and CONDITION.

Third...

You must to place a character (') before and after each string field.

Like this:

ExecuteSqlCommand("UPDATE member SET tmembername ='" & membername & "'," & "taddress='" & address & "',"........etc)

I recommend to you use stored procedures to manipulate the data into a database.

Regards

 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 Sub

and 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 & "'")

You MUST to remove the and statement from address & "', and  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..