title: Update sql command in vb.net flaws?
body: <p>i have this code made by myself researching,
  it returns no error, it update(s) some of the data entered in textboxes but not all the fields</p>
  
  <p>i check the codes near the field that is updating to compare it to the textboxes that do not
  update.</p>
  
  <p>but i dont see the difference, it just not update all fields, only some fields</p>
  
  <pre><code>   Dim sqlconn As New SqlClient.SqlConnection
      sqlconn.ConnectionString = "server = SKPI-APPS1;" &amp; _
      "Database = EOEMS;integrated security=true"
  
      Dim myCommand As SqlCommand
      Try
  
          'update command
          sqlconn.Open()
  
          myCommand = New SqlCommand(
            "UPDATE tblOfficeEquipmentProfile SET OE_Category = '" &amp; cmbCategory.Text
  &amp; "',OE_SubCategory = '" &amp; cmbSubCategory.Text
  &amp; "', OE_Name = '" &amp; txtName.Text
  &amp; "', OE_User = '" &amp; txtUser.Text
  &amp; "', OE_Brand = '" &amp; cmbBrand.Text
  &amp; "', OE_Model = '" &amp; cmbModel.Text
  &amp; "', OE_Specs = '" &amp; txtSpecs.Text
  &amp; "', OE_SerialNo = '" &amp; txtSerialNo.Text
  &amp; "', OE_PropertyNo = '" &amp; txtPropertyNo.Text
  &amp; "', OE_MacAddress = '" &amp; txtMacAddress.Text
  &amp; "', OE_Static_IP = '" &amp; txtStaticIp.Text
  &amp; "', OE_Vendor = '" &amp; cmbVendor.Text
  &amp; "', OE_PurchaseDate = '" &amp; txtPurchaseDate.Text
  &amp; "', OE_WarrantyInclusiveYear = '" &amp; cmbWarrantyInclusiveYear.Text
  &amp; "', OE_WarrantyStatus = '" &amp; txtWarrantyStatus.Text
  &amp; "', OE_Status = '" &amp; txtStatus.Text
  &amp; "', OE_Dept_Code = '" &amp; cmbDeptCode.Text
  &amp; "', OE_Location_Code = '" &amp; cmbLocationCode.Text
  &amp; "', OE_Remarks ='" &amp; cmbRemarks.Text
  &amp; "' WHERE OE_ID = '" &amp; txtOEID.Text &amp; "'", sqlconn)
  ' ^^  (edited to separate lines for ease of viewing )
          myCommand.ExecuteNonQuery()
          MessageBox.Show("Office Equipment Profile Successfully Updated Records")
      Catch ex As Exception
          MsgBox(ex.Message)
      End Try
  </code></pre>