how can i convert integer to string

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Erjola
    New Member
    • Mar 2018
    • 2

    how can i convert integer to string

    I have a school project and I need to convert sasia(quantity) ,cmimi(price) to string...can anyone help me please?
    Code:
    Public Sub executeyourquery(ByVal query As String)
            Dim cmd As New SqlCommand(query, con)
            cmd.Parameters.AddWithValue("@produkt_id", txtID.Text)
            cmd.Parameters.AddWithValue("@emertimi", txtEmertimi.Text)
            cmd.Parameters.AddWithValue("@sasia", txtSasia.Text)
            cmd.Parameters.AddWithValue("@cmimi", txtCmimi.Text)
            cmd.Parameters.AddWithValue("@vlera", txtVlera.Text)
            cmd.Parameters.AddWithValue("@furnitor_id", txtF.Text)
            con.Open()
            cmd.ExecuteNonQuery()
            con.Close()
        End Sub
    Last edited by Frinavale; Mar 5 '18, 09:55 PM.
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    What error are you getting?

    Assuming your txtSasia is a TextBox, then txtSasia.Text is already a string.

    Do you want to convert that into an Integer?
    Use the Integer.TryPars e Method...
    Code:
    Dim sasiaInt As Integer
    Integer.TryParse(txtSasia.Text, sasiaInt )
    cmd.Parameters.AddWithValue("@sasia", sasiaInt)
    Dim cmimiInt As Integer
    Integer.TryParse(txtCmimi.Text, cmimiInt )
    cmd.Parameters.AddWithValue("@cmimi", cmimiInt )

    Comment

    • Erjola
      New Member
      • Mar 2018
      • 2

      #3
      Thanks Frinavale
      i had forgot .Text ...Now its ok

      Comment

      Working...