thanks its working

but what about the condition contractorid='"+ contractorid+"'

here contractorid=ddlcontractor.selectitem.value

thanks now if i have another table name empadd where i have to update at the same time and whose fields are

EaddID address ...

thanks if the empid is automatically generated no then is it same

Thank you Michael Earl Its works now.