We had already set some general options for the data grid view, but now that we’ve dropped a data source into the data grid view and have some columns, let’s edit the columns. Let’s start with the first column, ID. We don’t need to change the ReadOnly status because the data grid view’s overall ReadOnly…
At this point, we have dropped a data source onto the form, and Visual Studio has done its code generation thing. We should be able to run the application and, even though we haven’t entered any data, we should at least get an empty form. So press F5 or click on the Start button. Hey,…
Ok, so we have the data source and the form we’ve created. The data source contains the Clients table, and the form is a copy of Form1 that we have called ClientList. Let’s go ahead and change the form’s Text property of ClientList to “Client List.” Now we can drag the Clients table from the…
Continue reading Bringing the Data Source and the Form Together
Create a new Data Source based on a database. You’ll need to add a new connection too. Since you installed dotConnect, SQLite should appear as an option when you add the new connection. Locate and select the database TheBooks.db. Save the connection as TheBooksConnectionString, if you’d like. Then select the Clients tables and call the…
You know, that was a pretty cool form we made. The DGV can display rows from a table, and the sidebar on the left can have buttons and links. It seems like it could be used in different places. Can we keep it and just use a copy? In C#, you can base a form…
There should already be a Form1 in your project, created automatically by Visual Studio when you created the WinForms projects. There’s nothing in the form, and before putting things in it, we’re going to set a few properties on the form itself. First, size the form to something like 800 x 600. Then, set the…
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…