SQLite table in DataGrid

Hi

I want to show the contents of a (small) SQLite table in a DataGrid (using
Delphi 8 for MS .NET).

Label2 shows the rows, but DataGrid1 does not.


procedure TWebForm1.Button1_Click(sender: System.Object; e:
System.EventArgs);
VAR
Q: Finisar.SQLite.SQLiteDataAdapter;
I: INTEGER;
S: STRING;
begin
Q := SQLiteDataAdapter.Create('SELECT * FROM books','Data
Source=library.db');
I := Q.Fill(DataSet1);
Label1.Text := I.ToString+' rows fetched';
DataGrid1.DataSource := DataSet1;
Label2.Text := DataSet1.GetXml;
Q.Free;
end;


Can any-one tell me how to solve this problem?

TIA


Jan P.


.

Quantcast