I am working on a windows application that tracks repairs for my business. The goal is to use LabelID (Which is the ID of the record) and update it with the text from combostatus.text

This is what I have so far:

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim conn As New SqlConnection(My.Settings.Smitty)
conn.Open()

Dim cmd As SqlCommand = New SqlCommand("Update Repairs set status = ' " & ComboBox1.Text) '" WHERE RepairNumber = '" & Label1.Text & " '", conn))
cmd.ExecuteNonQuery()

conn.Close()


End Sub


I keep getting this error message: ExecuteNonQuery: Connection property has not been initialized.

I have tried all different kinds of combinations and I get one error or another. I appreciate any help I can get on this. Thanks