in

System.Data.SQLite

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

Browse by Tags

  • Re: SQLiteDataAdapter.fill(dataTable) bug

    Anyone has this same problem???
    Posted to Bugs (Forum) by Cyberguy on 12-17-2010

  • Insufficient parameters error when using GridView control (with DataKeyNames and DataSourceID specified)

    I have a problem that I'm guessing has at least something to do with the ASP.NET control life-cycle. I have a GridView control to allow editing of certain records in an SQLite db. I have gotten what I thought to be pretty much the same thing to work on a different page on my site that accesses a...
    Posted to General (Forum) by robg37 on 07-01-2010

  • Re: Reference Select Results by Name?

    You can get the index of the column, based on the column name, by using the SQLiteDataReader.GetOrdinal() member.eg.: SQLiteDataReader rdb = SqlCmd.ExecuteReader(); string DocRef = rdb.GetString(rdb.GetOrdinal("DocReference")); or .... to speed things up, don't get the ordinals inside a...
    Posted to General (Forum) by blesch on 03-01-2010

  • Reference Select Results by Name?

    Based on all of the sample code I have seen and the inline help I see in Visual Studio, it seems to indicate that the SQLitedatareader objects can only reference result columns by index, and not by name. Is that a true statement. I can work with indices, but seems a lot less intuitive and harder to read...
    Posted to General (Forum) by burkeden on 02-28-2010

  • SQLiteDataReader.GetString() Problem

    Ok before i made the swap to sqlite i was simply using an OdbcDataReader and reading every value as a string using GetString(), however with sqlite the program will crash if i use GetString() on a field like a DateTime. So i tried using GetValue() and converting it to a string, however GetValue() crashed...
    Posted to General (Forum) by alex21 on 01-15-2010

  • Database file isn't copying over?

    I'm playing around a bit with trying to get a sqlite database to open and display in a mobile application, and I'm having some trouble getting it going. From what I can tell, the file isn't being copied like it's supposed to. When I go into file explorer on the simulator, there is a file...
    Posted to General (Forum) by andyd273 on 09-14-2009

  • 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

  • no refresh on dialog box while using multi-threaded DataReader on large database.

    Hello, I precise that i read Robert's post speaking about SQLite Provider in multi-thread environnement. I am programming with the compact framework under WinCE 5.0. What i do is very classic. I have an DialogBox (A) to search a user in the database (about 67 000 records in database). After the user...
    Posted to General (Forum) by m3z on 10-22-2008

  • Passing SQLiteDataReader between classes.

    Hello, I am getting System.AccessViolationException when reading from instance of SQLiteDataReader passed to another class. Here is the situation: I have a class called TrustedApp and a static class TrustedAppsDal. I'm creating an instance of TrustedApp class and calling its GetAll method which in...
    Posted to General (Forum) by mcnamara on 07-04-2008
Page 1 of 1 (9 items)
Powered by Community Server (Commercial Edition), by Telligent Systems