Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-05-10 Thread Noel Frankinet
John Newby wrote: 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 tha

RE: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-05-10 Thread Michael B. Hansen
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 "Transaction

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-05-10 Thread John Newby
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

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-05-10 Thread John Newby
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 dat

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread John Newby
Hi, I don't know if you can remember but I was asking for advice on displaying info to the user using a dataset/datagrid, and you said you used a virtual listview. I am currently having loads of trouble using the dataset/datagrid so I was wondering if you could let me know more about your virtual

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread Noel Frankinet
John Newby wrote: Hi, I don't know if you can remember but I was asking for advice on displaying info to the user using a dataset/datagrid, and you said you used a virtual listview. I am currently having loads of trouble using the dataset/datagrid so I was wondering if you could let me know m

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread John Newby
Yes please, I am using vb.net but I should be able to work through and see whats going on and transfer it to my project. Many thanks for your help. John On 15/06/06, Noel Frankinet <[EMAIL PROTECTED]> wrote: John Newby wrote: > Hi, I don't know if you can remember but I was asking for advice