in

System.Data.SQLite

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

Browse by Tags

  • Autoincrement doesn't work (WinForms, DataGridView)

    I can't seem to figure it out, but autoincrement simply doesn't work for me. I have the a schema like this: "CREATE TABLE Trees ( Id INTEGER PRIMARY KEY AUTOINCREMENT, SomeColumn VARCHAR); " I have a DataGridView that binds to the table. When I try to insert a new row, I get "Abort...
    Posted to General (Forum) by Turar on 12-20-2010

  • Concurrency errors on datatime column

    If I include a column in my dataset that I have defined as a datetime data type, I eventually get concurrency errors from the datagridview. The dataset includes as I mentioned a datetime data type. The grid is bound via the usual tableadapter and bindingsource. The grid allows deletes. When the delete...
    Posted to Bugs (Forum) by glennwelker on 02-22-2010

  • How to convert excel datetimes using tableadapter?

    Here's my question: I have an SQLite table containing Excel datetimes e.g. 40057.0069444444 (old OLE format), stored in SQlite db in Double format. Now I want to show them in a TableGridView using a tableadapter. This doesn't work because .net can't convert from Double numbers to the .net...
    Posted to General (Forum) by andy2m on 01-30-2010

  • Update Problem

    I have encountered the following error when using the TableAdapter.Update method: Update requires a valid UpdateCommand when passed DataRow collection with modified rows. The table adapter was obtained by dragging a grid from the data source to the form. The DataGridView had editing, adding and deleting...
    Posted to General (Forum) by rkulp on 07-17-2008

  • DataGridView editing datetime types

    Hi, I'm not sure if this is a bug or it's just me not knowing how to do things. I have a dataset with a table that has a columnt type System.DateTime. I created this dataset using the datase designer in VS2005, while connected to my sqlite.net database. I use the tableadapter.fill method to populate...
    Posted to General (Forum) by AlexG on 05-23-2008

  • SQLite performance with Datagridview

    I did some tests filling a datagridview with an SQLITE table and found out some interesting points, I would like to share with you. Test envirnoment PC : AMD64 X2 Dual Core 5000+ 2GB RAM, XP Pro SP2, VS 2005 Database : table 249.000 records, 6 columns, no key, database size 13,6 MB Version : phx-sqlite...
    Posted to Benchmarks (Forum) by Mark2 on 05-20-2008
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems