Note: This post was written in 2012 for Visual Studio 2010. The
.sdf (SQL Server Compact) format used here has since been discontinued by Microsoft and is no longer supported in modern Visual Studio versions. If you’re starting fresh today, consider SQLite, LocalDB, or SQL Server Express instead.
There are already thousands of tutorials on the web for this kind of thing, and most of them are unnecessarily complicated. They use too many columns and too much code, which just ends up confusing beginners. So I’m going to show you how to build your first database VB app the simple way — three columns only (ID, Name, City), and almost everything done through drag and drop. No heavy coding needed.
Steps
Since we’re building a Windows Forms application, choose Windows Forms Application as the project template.
I’ve named the project dbapp, but you can call it whatever you like.
Continue reading Creating A Simple Database Application In Visual Studio ’10 (Drag & Drop Way)