Datagrid is it the best choice?

[alocin]

im developing a C# application.
This application uses SQlite, id like to know which is the best convenient choice to represent out the ResultSets from an SQlite Select....

i thought i could use DataGrid control but on what i found it is oriented on ADO.net and accepts a Datasource object...maybe it will work the same way also with SQlite?

i thought also that Datagrid could be used creating a Row for each db result then adding it...
pseudo code
Datagrid d;
Row r = new Row();
///add the contents to the row then
d.add(r);

but it doesnt work like this...
i think im a bit confused on this...and maybe i lack of some info about something...
anyone can drive me to the best choice or examples?
Thank you in advance

 

[FZelle]

There is an Adoprovider for SQLite on sourceforge.net.
With that you can use SQLite as you would use Access or Sql-Server.

For this to work i strongly suggest that you read at least an article about
ADO.NET and how it works.

Something like this:
http://www.codeproject.com/cs/database/DatabaseAcessWithAdoNet1.asp