Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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 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 listview please. > > Also would the virtual listview allow for > amendments/deletion/insertion of > data and recognise the change and update the database accordingly. > > Many thanks > > John > > On 10/05/06, Noel Frankinet <[EMAIL PROTECTED]> wrote: > >> >> 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 thanks. >> > >> >John. >> > >> > >> > >> > >> >> > >> >No virus found in this incoming message. >> >Checked by AVG Free Edition. >> >Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: >> 9/05/2006 >> > >> > >> Hello, >> I use a virtual listview directly on top of sqlite3, its in c++ but it >> works very well (even on PDA). It could easily be turned in an activeX >> (its ATL/WTL, no MFC). >> >> Best wishes. >> >> >> -- >> Noël Frankinet >> Gistek Software SA >> http://www.gistek.net >> >> > > > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/2006 > > Hello, My virtual list is WTL C++ code, it runs on top of a Cdataview class that does all the work. It works on PC and PDA, and yes, beiing virtual, it reflects insert and deletes quite well (a trigger does the Window Updating). I can send you that code (3 .h files) but it won't be free of dependency from other part of my project. I hope to one day make it into a separated project but I don't have the time right now, Are you interested ? Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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 more about your virtual listview please. Also would the virtual listview allow for amendments/deletion/insertion of data and recognise the change and update the database accordingly. Many thanks John On 10/05/06, Noel Frankinet <[EMAIL PROTECTED]> wrote: 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 thanks. > >John. > > > > > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006 > > Hello, I use a virtual listview directly on top of sqlite3, its in c++ but it works very well (even on PDA). It could easily be turned in an activeX (its ATL/WTL, no MFC). Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.8.4/364 - Release Date: 14/06/2006 Hello, My virtual list is WTL C++ code, it runs on top of a Cdataview class that does all the work. It works on PC and PDA, and yes, beiing virtual, it reflects insert and deletes quite well (a trigger does the Window Updating). I can send you that code (3 .h files) but it won't be free of dependency from other part of my project. I hope to one day make it into a separated project but I don't have the time right now, Are you interested ? Best wishes -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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 listview please. Also would the virtual listview allow for amendments/deletion/insertion of data and recognise the change and update the database accordingly. Many thanks John On 10/05/06, Noel Frankinet <[EMAIL PROTECTED]> wrote: 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 thanks. > >John. > > > > > >No virus found in this incoming message. >Checked by AVG Free Edition. >Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006 > > Hello, I use a virtual listview directly on top of sqlite3, its in c++ but it works very well (even on PDA). It could easily be turned in an activeX (its ATL/WTL, no MFC). Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net
Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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. > > > >
Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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. >
RE: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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.
Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider
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 thanks. John. No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 9/05/2006 Hello, I use a virtual listview directly on top of sqlite3, its in c++ but it works very well (even on PDA). It could easily be turned in an activeX (its ATL/WTL, no MFC). Best wishes. -- Noël Frankinet Gistek Software SA http://www.gistek.net