[ aca andrijevic @ 21.07.2009. 14:03 ] @
Pravim neku aplikaciju tipa katalog u VB.NET-u i imam ListBox sa tabelama iz access baze i ListView sa kolonama iz svake tabele. 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 Probao sam da za svaku tabelu selektovanu u ListBox(SelectedIndexChange) ucita podatke u ListView ovako Code: 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! |