We have enough of a database to get started, so fire up Visual Studio and create a new Windows Forms App under Visual C#. What should we call it? I know! QuickBooks. Oh, wait… that’s taken. FastBooks? SpeedyBooks? I wound up calling it just plain TheBooks. My project now looks like this: This is all…
Now let’s use SQLiteStudio to add a table called Invoices, like this. Note that SQLite doesn’t actually have a date type. Instead, you use SQLite’s date functions to convert back and forth to string or numeric types. If you store dates as strings in TEXT fields, SQLite uses ISO format, which makes the date easily…
Using SQLiteStudio, add a database called TheBooks (no space) and add a table called Clients. Configure the table like this: CREATE TABLE Clients ( ID INTEGER PRIMARY KEY, Name VARCHAR (32) NOT NULL, Address1 VARCHAR (32) NOT NULL, Address2 VARCHAR (32), Address3 VARCHAR (32), Address4 VARCHAR (32), Contact1 VARCHAR (32), Contact2 VARCHAR (32), Contact3 VARCHAR…
Setting up SQLite turned out to be a lot easier than I thought, though I first went through a lot of false starts. I downloaded Microsoft’s System.Data.SQLite, but I couldn’t create DataSets in Designer. I installed and uninstalled a lot of things, but finally, it seemed the only thing I needed was a driver, just…
As you know, the database world is divided into SQL databases and other SQL databases. That’s only a slight exaggeration. Even Microsoft Access understands SQL. There are two broad kinds of SQL: server-based and client-based. Server-based SQL is software that runs on a server. You send the server an SQL query, and the server returns…
The internet is full of tutorial, examples, and answers to questions, but it’s very hard to find a complete applications built step by step. I’ve not found any, in any case, so I thought it would be fun and satisfying and perhaps even helpful to document building a complete application, step by step — sort…