Вольф, Тим Р. Война и мир - C# Программирование 5 тома: программирование в C# Visual

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)

Opis:

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.

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 uses 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 A summary view of the most basic SQL command: Insert Records, Update, Delete, Read, and Count. The code examples are well-thought out, with auditing and other features and 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. Complete cursor controls, prompts, buttons, error messages, and other features that every well-designed panel needs.

Events automatically enable and disable buttons, lock down fields, expose user prompts and save and delete records. 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 data from the bad guys -- using parameterized queries, connection-string builders, and stored procedures. In addition, you will develop your own utility for pre-auditing data-entry fields using a program called "Strip SQL Injection Attacks" -- a must for any database program.

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.

28 SQL Data Grids - Write a data-grid which displays SQL 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 that combines a regular data-entry screen with two embedded data-grids. This allows for a single contact record to have any number of (phone number entries), or any number of dates (birthdates, anniversaries, hire-dates, etc.).

About this series: This series is being distributed through 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.

Okładka: Paperback

Liczba stron:458

Autor:Wolf, Tim R.

Język: English: Published; English: Original Language; English

Data wydania: 2022-01-22

Waga: 2.46 gram

Wysokość: 1 cm

Szerokość: 8 cm

Długość: 10 cm

UWAGA: Kupując produkt na tej aukcji zgadzasz się na wydłużony termin realizacji wysyłki (10-14 dni roboczych). Podany towar pochodzi z zagranicznego magazynu, stąd wydłużony czas realizacji który podany jest obok.