Hi, I have managed to display the data into the datagrid using a dataset, many thanks for all your help.
John. On 10/05/06, John Newby <[EMAIL PROTECTED]> wrote: > > Hi Michael, I am already using the Finisar.SQLite wrapper, I can > successfully connect to the database, create a table, insert data and > display it to the console or in a message box, but I am unsure as how to > display it into a grid (like ms access) > > > > > On 10/05/06, Michael B. Hansen <[EMAIL PROTECTED]> wrote: > > > > Hi John, > > > > There is a number of .NET-wrappers for SQLite > > (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers). > > > > I personally use Finisar.SQLite > > (http://adodotnetsqlite.sourceforge.net/) which performs acceptable > > (although I currently have one single issue with it - look for the > > subject "Transactions and 'library routine called out of sequence' locks > > > > the database" in this list). > > > > > > /Michael > > > > -----Original Message----- > > From: John Newby [mailto:[EMAIL PROTECTED] > > Sent: 9. maj 2006 17:18 > > To: sqlite-users@sqlite.org > > Subject: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider > > > > Hi, I am trying to access a SQLite database using the ADO.Net provider > > and bring all the data back in a tabular form, I can bring back the data > > > > using a datareader but I don't know if I can put the data into a datset > > or a datagrid. > > > > Does anyone know if you can do this? > > > > Many thanks. > > > > John. > > > >