Browse by Tags

DataSet generated with GUID column has incorrect type for parameters

First off, thanks for the great work. It's invaluable, but I found one problem in using GUID columns. Given a table with a GUID as the column. CREATE TABLE [Account] ( "AccountId" guid NOT NULL, "IdNumber" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "Slug" nvarchar(255...

Posted to Bugs (Forum) by tstanley on 08-14-2010
JOIN Query that worked on Access not working on SQLite. VB.NET

I have a query that worked in Access. I used this to fill a dataset. I have two tables. I don't want all fields. I also have a custom column using AS to build its value (FileAttributes.DOCNUMSORT & ':' & DOCTABLE.PAGENUMSORT & ':' & DOCTABLE.ID AS TT). Thank you in...

Posted to General (Forum) by Salemanokc on 05-17-2010
SQLiteDataAdapter.Update returns 0 (does not insert data into the database)

Hi everybody! I've been trying to implement a CSV insert with a little trick: I use the OleDb CSV parser to fill my SQLiteDataSet, then I want to use the SQLiteDataSet to update the SQLite database. Unfortunately I've been stuck on this one problem- when I call Update on the SQLiteDataAdapter...

Posted to General (Forum) by lirik on 04-26-2010
Table Relations not usable when using dataset generator

Hi, We're currently using generated table adapters (using the dataset generator) to access our data (one adapter per table). Retrieving rows from a single table works fine, but when relations are used, we encounter serious problems. Example: Suppose we have a table 'Orders' and a table 'OrderRows'...

Posted to General (Forum) by msanders on 11-18-2009
code sample showing how to perform a dataset Update and retrieve the auto-increment IDs???

Hi, Does anyone have a code sample showing how to perform a datasetup Update and retrieve the primary key ID's that sqlite generates for the auto-increment field? I can't quite see/work out how to do this. For example at the moment I'm getting the following error, which I think may be due...

Posted to General (Forum) by callagga on 10-21-2009
what simple/robust data access approach can I use in C# Visual Studio 2008?

Hi, What are the current reliable data access approaches that are available in VS2008 using this ADO.net sqlite integration for a small project with only a handful of tables? For example: * base sqlite classes * Dataset / DataAdapter * LINQ (supported?, robust?) * Entity Framework (supported?, robust...

Posted to General (Forum) by callagga on 10-10-2009
Dataset cannot access to databaseschema VS2008

Hello, i can't add a table to the dataset. The dataset cat read the schema from the table. On VS 2005 works fine. Screenshot:

Posted to Bugs (Forum) by MarioR on 07-07-2009
Re: 'Refresh the data table' on a DataSet

Hello- I've messed around with this some more and determined that the Visual Studio 2008 SQLite designer stuff just doesn't do what its supposed to. Perhaps I've spent to much time in Microsofts SqlCE but, well, nothing works like I expect it to, if at all. Before I waste too much time, could...

Posted to General (Forum) by rsloan on 11-22-2008
SQLiteDataAdapter.Fill(datatable)

Hi everyone i have a problem with the sqlite data adapter when i try to execute fill() method for filling the datatable; when querying the DateTime column in table where that column is NULL. I get the following exception: String was not recognized as a valid DateTime. i found somewhere that...

Posted to Bugs (Forum) by leo_Mostar on 11-21-2008
'Refresh the data table' on a DataSet

Hello, I create a new DataSet by dragging a SQLite 1.0.60 table from the Server Explorer to the empty DataSet canvas. The T_ID column is set for AutoIncrement=True. I then right-click on the adapter, click Configure then Advanced. I check the 'refresh the data table' checkbox, OK then Finish...

Posted to General (Forum) by rsloan on 11-15-2008

Page 1 of 2 (13 items) 1 2 Next >