1. S

    SQLite in vb display all rows.

    I am doing a school preoject and have looked into a lot of things but cannot seem to find a way to display all rows of a database. i have been using .ExecuteScalar but it will only display the first result. I cannot post my code in case i am accused of copying as this is an important project for...
  2. mohammed.kan000

    This causes two bindings in the collection to bind to the same property

    when i start Project and click on search button every things ok but when click once again this error is show (This causes two bindings in the collection to bind to the same property this my code Imports System.Data.SQLite Public Class Form1 Private dbcomand As String = "" Private...
  3. P

    Return rows from sqlite query function

    I used to be fairly proficient with vb and c# but haven't used either of them in 10 or twenty years. I have a need to use sqlite in vb.net (vs2015) but I simply cannot remember (or find out) how to have a generic function read the database and return a result containing multiple rows. Supplying...
  4. S

    Choosing a Server-less Database for a Desktop Application

    I'm about to start coding a Windows Form application using Visual Studio 2019. The application will provide hobby collection management and a few other hobby related functions. Since it will be used mostly (if not entirely), by non-technically savvy adults without any IT infrastructure or...
  5. G

    Question Can I use SQLITE with Reportviewer

    I have used SQL Server to create an local database in a vb.net application. SQL are giving me all sorts of headaches. I want to migrate to SQLITE. My Questions is can I still use ReportViewer in my application with SQLITE ?
  6. C

    Available Small C# SQLite Project that needs to modified and fixed

    Hi, I have a small SQLite Database that is buggy and needs to be fixed and some functions added. It would also be great if someone could translate this project into VB.net. This is NOT a Corporation or Established Business I am an individual person that is willing to pay a fair amount for a...
  7. C

    Question Is it possible to return all items in a List/Queue without Iterating over them?

    Ok, I have a very specific situation that this would be useful for. I have a DataTable with a large number of columns(200+) that I am doing a bulk insert for in SQLite, since it does not support Update Table like SQL Server does. I want to know if there is a way after I iterate over all the...