Datagrid is it the best choice?

[alocin]

i'm developing a C# application.

This application uses SQlite, i'd 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®;

 

but it doesn't work like this...

i think i'm 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