Update OrderMaster set OrderFrmType='G',OrderDate='" & dtpOrderDate.SelectedDate.ToString("dd/MMM/yyyy") & "',SMGIDRef='" & j & "',MDIDRef='" & k & "', Remark='" & txtRemark.Text & "', AIDAgencyRef='" & l & "' where OrderFormNo='" & cmbOrderNo.Text & "'"
--Please try it if it is not multilingual.
--If multilingual then
Update OrderMaster set OrderFrmType='G',OrderDate='" & dtpOrderDate.SelectedDate.ToString("MM-dd-yyyy") & "',SMGIDRef='" & j & "',MDIDRef='" & k & "', Remark='" & txtRemark.Text & "', AIDAgencyRef='" & l & "' where OrderFormNo='" & cmbOrderNo.Text & "'"
For more please
visit me