Conversion from string "LLL" to type 'Integer' is not valid.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lorencsg
    New Member
    • Jun 2014
    • 2

    Conversion from string "LLL" to type 'Integer' is not valid.

    Hi. I cant fix it :( any ideas PLZ? :(
    Code:
    Public Class Form1
        Dim sqlConn As SqlConnection
        Dim COMMAND As SqlCommand
        Dim Query As String
    
        Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
            sqlConn = New SqlConnection
            sqlConn.ConnectionString = "data source = .\SQLEXPRESS;integrated security = true; initial catalog = Start_Data"
            Dim READER As SqlDataReader
    
            Try
                sqlConn.Open()
                Query = "select * from START_AP_PHARMACY_CHECK"
                COMMAND = New SqlCommand(Query, sqlConn)
                READER = COMMAND.ExecuteReader
    
                While READER.Read
                    Dim sName = READER.GetString("LLL")
                    ComboBox1.Items.Add(sName)
                End While
    
                sqlConn.Close()
    
            Catch ex As SqlException
                MessageBox.Show(ex.Message)
            Finally
                sqlConn.Dispose()
            End Try
    
        End Sub
Working...