[RESOLVED] sql update statement help

[gracehskuo]

hi,currently i want to update the sql data from the textbox amend data.
once i execute the sql query all the database will update to same value of textbox.i only want to update 1 row data from the textbox amended,not all the database field.please help.

sSQL = "Update SpcData set PartNo = '" & txtpartno.Text & "',Dimension ='" & txtdimension.Text & "',MachineNo = '" & txtmachineno.Text & "', Inspector = '" & Txtinspector.Text & "', Date ='" & txtdate.Text & "' ,Time = '" & txttime.Text & "',SampleNo ='" & txtsampleno.Text & "', Data = '" & txtdata.Text & "'"
conn.Execute sSQL

thanks.

[amrita]

To update one row add a where clause

Update tblName
Set Col = Value
Where Id = IdValue

Is this what you are looking for ?

[youquijano]

yup, you should add a where condition so as to filter the records to be updated

[Hack]

Take a moment and go through our database FAQ section.

[gracehskuo]

hei thank guys,the problem has been solved.