updatecommand

Question

UpdateCommand="update [Employees] Set [EmpId]=@EmpId,[FirstName]=@FirstName,[MI]=@MI,[LastName]=@LastName,[DOB]=convert(nvarchar(30),DOB,110),[DOJ]=convert(nvarchar(30),DOJ,110),DOL=convert(nvarchar(30),DOL,110),[EmailP]=@EmailP,[EmailW]=@EmailW,[PhoneM]=@PhoneM,[PhoneH]=@PhoneH,[PhoneW]=@PhoneW,[Status]=@Status[Address]=@Address,[Country]=@Country,[State]=@State,[City]=@City where [EmpId]=@EmpId"

 

DeleteCommand="delete from [Employees] where [EmpId]=@EmpId">

 

:) this is the synax which i wrote in the gridview to update and delete.the data of the above [dob],[doj] & [dol]] are not working.

 

pls reply..