Winforms app accesses SQL database using ADO.NET written in VB.NET
This is a 3 layer application with Winforms as the presentation layer, VB.NET code in the logic layer and ADO.NET to SQL Server on the database layer. I used object data sources to access the data.
Here's what the frontend looks like:
How to get it to work
-
Create a database called ToyStore in Sql Server (App was tested on SQL Server 2014)
-
Execute the Create.txt script to create the schema
-
Execute the Populate.txt script to populate the schema with data
-
Change the connection string in ToyStoreDataDB.vb to link to your database
The create.txt and populate.txt database scripts come from Sam's Teach Yourself SQL in 10 Minutes. I made a couple minor changes to them.
http://www.amazon.com/SQL-Minutes-Sams-Teach-Yourself/dp/0672336073/