P
Peter Lux
Ok.. all I'm trying to do is get a list of non-system tables from a Sqlbase
db into a listbox. The following returns many rows that say:
System.Data.DataRowView
System.Data.DataRowView
..
..
..
Here's the code:
hQuest.ConnectionString = "DSN=this worksfine.."
hQuest.Open()
sSelect = "select name from sysadm.systables where name not like 'SYS%' "
Dim Cmd As New Odbc.OdbcCommand(sSelect, hQuest)
da.SelectCommand = Cmd
Dim ds As DataSet = New DataSet
da.Fill(ds)
lbTable.DataSource = ds.Tables(0)
hQuest.Close()
What's wrong? Is it the data adapter or the data set?
db into a listbox. The following returns many rows that say:
System.Data.DataRowView
System.Data.DataRowView
..
..
..
Here's the code:
hQuest.ConnectionString = "DSN=this worksfine.."
hQuest.Open()
sSelect = "select name from sysadm.systables where name not like 'SYS%' "
Dim Cmd As New Odbc.OdbcCommand(sSelect, hQuest)
da.SelectCommand = Cmd
Dim ds As DataSet = New DataSet
da.Fill(ds)
lbTable.DataSource = ds.Tables(0)
hQuest.Close()
What's wrong? Is it the data adapter or the data set?