title: ExecuteNonQuery: Connection property has not been initialized VB
body: <p>Getting an error here not sure why its not opening the connection. Hoping someone can help me.</p>
  
  <pre><code> Protected Sub Btn_Submit_Click(ByVal sender As System.Object, e As System.EventArgs) Handles Btn_Submit.Click
      Dim Sqlstr As String
      Dim con As SqlConnection
      Dim connectionString As String = "Data Source=DB\TEST;Initial Catalog=Orders;Integrated Security=True"
      Dim cmdInsert As New SqlCommand(Sqlstr, con)
      Sqlstr = "insert into customers(FirstName,LastName,Email,Phone,Address,City,State,Zip) values (@FirstName,@LastName,@Email,@Phone,@Address,@City,@State,@Zip)"
      Try
          Using connection As New SqlConnection(connectionString)
              connection.Open()
              cmdInsert.Parameters.Add("@FirstName", Data.SqlDbType.NVarChar).Value = FirstName.Text()
              cmdInsert.Parameters.Add("@LastName", Data.SqlDbType.NVarChar).Value = LastName.Text
              cmdInsert.Parameters.Add("@Email", Data.SqlDbType.NVarChar).Value = Email.Text
              cmdInsert.Parameters.Add("@Phone", Data.SqlDbType.NChar).Value = Phone.Text
              cmdInsert.Parameters.Add("@Address", Data.SqlDbType.NVarChar).Value = Address.Text
              cmdInsert.Parameters.Add("@City", Data.SqlDbType.NVarChar).Value = City.Text
              cmdInsert.Parameters.Add("@State", Data.SqlDbType.NVarChar).Value = State.Text
              cmdInsert.Parameters.Add("@Zip", Data.SqlDbType.NChar).Value = Zip.Text
              cmdInsert.ExecuteNonQuery()
              connection.Close()
          End Using
      Catch ex As Exception
          MsgBox(ex.Message)
      End Try
  </code></pre>