none
problem in converting RRS feed

  • Question

  • Hi every one

    Now I have this code

     
     Function AddErad(ByVal namee As String, ByVal Pricecourse As Integer, ByVal PriceCd As Integer, ByVal PriceCerti As Integer, ByVal Pricecard As Integer, ByVal Priceother As Integer, ByVal Priceother2 As Integer, ByVal dateofregist As String, ByVal notese As String, ByVal free As String) As Boolean
    
     Dim SqlString As String
            SqlString = "Insert into Erad (namee,Pricecourse,PriceCd,PriceCerti,Pricecard,Priceother,Priceother2,dateofregist,notese,free)Values " & _
                " ('" & namee & "'," & Pricecourse & "," & PriceCd & "," & PriceCerti & "," & Pricecard & "," & Priceother & "," & Priceother2 & " ,  '" & dateofregist & "', ' " & notese & "',  ' " & free & "' )"
    
    


    some of variables are integer

    now how i can convert it in this code

      AddErad(TextBox35.Text, TextBox20.Text, TextBox37.Text, TextBox39.Text, TextBox41.Text, TextBox38.Text, TextBox40.Text, TextBox36.Text, TextBox42.Text, TextBox43.Text)
    
    


    when I try to convert the texts boxes to

    ex:
    Cint(textbox20.text)
    


    i have problem shown to me

    say that : ( Conversion from string "" to type 'Integer' is not valid. )

    what can i do ?
    Wednesday, September 21, 2011 12:00 AM

Answers