in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
All Tags » DataSet (RSS)

Browse by Tags

  • 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

  • Faled to load dataset designer

    Hi I'm using the latest release of SQL.NET and it's designer for VS2005. The problem occurs when i'm using Dataset designer. In dataset first creation, with a table that dropped from ServerExplorer with SQLite database, it works. but after closing and opening dataset again, it failes with...
    Posted to Bugs (Forum) by SalarWeb on 11-11-2008

  • DataSet.Load and DataTable.Load - very slow

    Lately I've made some performance tests of System.Data.SQLite provider. I've noticed during tests of SELECT command that DataSet.Load and DataTable.Load methods are much slower compared to other methods of reading data (using DbDataReader or with DbDataAdapter.Fill method). I've got following...
    Posted to General (Forum) by KoD666 on 10-29-2008

  • SELECT / GROUP BY / ORDER BY Issue.... ?

    I'm writing a Media Management application, and thought everything was working smoothly until I had to update my media player to make use of alternative data views, and it started breaking when the correct number of tracks for a particular playlist appeared to be incorrect. I've attached the...
    Posted to Bugs (Forum) by VorTechS on 10-10-2008
Page 1 of 1 (10 items)
Powered by Community Server (Commercial Edition), by Telligent Systems