Ucitavanje podataka:
Code:
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
oledbcon.Open()
Dim i As Integer
Dim schemaTable As DataTable = oledbcon.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
For i = 0 To schemaTable.Rows.Count - 1
ListBox1.Items.Add(schemaTable.Rows(i)!TABLE_NAME.ToString)
Next i
strSQL = "SELECT * FROM MaticnePloce"
cmd = New OleDbCommand(strSQL, oledbcon)
objRead = cmd.ExecuteReader
While objRead.Read
lv = Me.ListView1.Items.Add(objRead("SifraArtikla") & (""))
lv.SubItems.Add(objRead("NazivArtikla") & "")
lv.SubItems.Add(objRead("JM") & "")
End While
objRead.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
oledbcon.Close()
End Try
End Sub
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Try
oledbcon.Open()
Dim i As Integer
Dim schemaTable As DataTable = oledbcon.GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
For i = 0 To schemaTable.Rows.Count - 1
ListBox1.Items.Add(schemaTable.Rows(i)!TABLE_NAME.ToString)
Next i
strSQL = "SELECT * FROM MaticnePloce"
cmd = New OleDbCommand(strSQL, oledbcon)
objRead = cmd.ExecuteReader
While objRead.Read
lv = Me.ListView1.Items.Add(objRead("SifraArtikla") & (""))
lv.SubItems.Add(objRead("NazivArtikla") & "")
lv.SubItems.Add(objRead("JM") & "")
End While
objRead.Close()
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
oledbcon.Close()
End Try
End Sub
Probao sam da za svaku tabelu selektovanu u ListBox(SelectedIndexChange) ucita podatke u ListView ovako
Code:
strSQL = "SELECT * FROM" & ListBox1.SelectedItem & ""
strSQL = "SELECT * FROM" & ListBox1.SelectedItem & ""
ali mi javlja gresku Syntax error(missing operator) in query expression '*FROMProcesori' (ili bilo koji Item selektovan).
mogu da definisem za svaki selektovani Item u ListBox da mi vraca odredjenu tabelu u ListView, ali to ce biti mnogo linija koda,
da li ima bolji i drugaciji nacin da ovo resim ili da ispravim?
Poz!
"Ne menjaj nesto sto te sasvim dobro sluzi, ne trazi leba preko pogace" - Aleksandar Andrijevic