C# Database Basics: Moving from Visual Basic and VBA to C# (1)

By: Michael Schmalz

Sign Up Now! Already a Member? Log In
You must be logged into Bookshare to access this title. Learn about membership options, or view our freely available titles.

Synopsis: Working with data and databases in C# certainly can be daunting if you’re coming from VB6, VBA, or Access. With this hands-on guide, you’ll shorten the learning curve considerably as you master accessing, adding, updating, and deleting data with C#—basic skills you need if you intend to program with this language.No previous knowledge of C# is necessary. By following the examples in this book, you’ll learn how to tackle several database tasks in C#, such as working with SQL Server, building data entry forms, and using data in a web service. The book’s code samples will help you get started on your own projects.Create a Windows Forms application with a datagridConnect to multiple data sources, including Access and SQL ServerAdd, edit, and update data in a database you choose and designEnable users to choose their data source at runtimeLearn the roles of DataTable, DataView, BindingSource, Filters, and other objectsUnderstand where variables are declared and how they impact the codeBuild a simple web service that connects to a database