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