War and Peace - C# Programming 5 Vol.: Programming in C# Visual Studio - All about SQL, Record reads, writes, DataGridViews (War and Peace - C# Programming Visual Studio 2022)
Format:
Paperback
En stock
1.32 kg
Sí
Nuevo
Amazon
USA
- This is the fifth of a six -volume set on C# Computer Programming. This volume is everything you wanted to know about using SQL databases. (2025.10 Update: General spiffs. Includes dotNet 8.0 support, with NuGet Libraries) Volume 5: 25 SQL Databases - Build the Database Install a free copy of Microsoft's SQL Server, and then build a fully-functional multi-table database. This example shows how to install the database and how to build a name-and-address table with several cross-lookup tables. Naturally, there will be indexes and other goodies. While this chapter is not C# per-se, the database built here is needed for the remaining chapters. 26 Basic SQL commands Write a simple application and use general SQL commands for Inserting, Reading, Updating, and Deleting records. The code examples are well-thought out, with auditing and other features. This chapter is a handy reference for your own work. 27 SQL Record Edits Create a full-featured data-entry panel your end-users will love. This features complete cursor controls, prompts, buttons, error messages, auditing, and other features. This is a complex program, but the results are a data-entry panel that end-users will love. Fluid in every respect. (Even if you have no intention of writing a SQL program, the techniques taught in this chapter are useful in all Windows Forms development. Write your own programs by following these same cook-book approaches.) Events automatically enable and disable buttons as needed, fields are locked down, duplicate keys detected, and a rash of other features make this program easy-to-use. Users will never be confused about how this panel works. This is an admittedly complicated undertaking. I walk you through the steps, one-at-a-time. This chapter spends considerable time showing how to defend your database from the bad guys -- guarding against SQL Injection Attacks and other data problems. Learn how to use parameterized queries, connection-string builders, and stored procedures. You will develop your own utility for pre-auditing and sanitizing data. This utility is called "Strip SQL Injection Attacks", and this is a must for any database program. 28 SQL Data Grids - Write a SQL data-grid which displays records in a tabular form. From here, launch the editing screen built in the previous chapter. 29 SQL Data Grid Cell Editing - This version of a data-grid is written so the records can be edited in the grid, much like a spreadsheet. It includes field-level audits and other features to keep users from doing bad things to good data. 30 SQL Data Entry Forms A more complicated data-entry panel for tracking Names, Addresses, and Contact information (phone numbers, email addresses, etc.). This program combines a regular data-entry screen with two embedded data-grids and it pulls-in the tables from the other chapters. With 'related tables,' and person's name record can have any number of (phonenumber entries), or any number of dates (birthdates, anniversaries, hire-dates, etc.) About this series: This series is being distributed through Amazon Kindle as a multi volume set in order to make printing manageable. All six volumes are 2,100-pages long, with 1,300 illustrations. Thank you for purchasing. I hope you enjoy it as much as I have had writing it.
IMPORTÁ FACIL
Comprando este producto podrás descontar el IVA con tu número de RUT
NO CONSUME FRANQUICIA
Si tu carrito tiene solo libros o CD’s, no consume franquicia y podés comprar hasta U$S 1000 al año.