Quick C # Database Programming outline

 Objectives:MasterC #Basic syntax, Reuse the code.

• Prerequisites: C # Getting Started Classic Section 3.1-section 3.2-section 6.1-section 6.3 Section 4.1 Section 4.3, competent persons can finish chapter 1-7 • Learning Environment: any version of VS2005-VS2010, sql2005 or 2008 almost all the invoicing software, financial software, management software must use the database, so database programming is a technology that every developer must master. Beginners are very mysterious about database programming and find it difficult to start with. In fact, this is an illusion that it can be done in one day, and it is very easy. If you don't believe it, try it. Of course, I only want to talk about the knowledge used in this project, and read "C # Getting Started classic" for other things I didn't talk about. Our goal is to learn C # And database in 7 courses.Get started with a two-tier architecture to learn object-oriented and three-tier architecture later. Encapsulate database operation functions and call them directly in the code, which is very easy to use. This allows beginners to write code in one step according to the practices of professionals.

• 1. Basic concepts. Use Hello world to understand basic concepts such as variables, types, namespaces, and assemblies. • 2. Basic Windows programs, forms creation, buttons, menus, and text boxes. Program name: Human Management System. • 3. Database Design: Learn to connect to the database, design a human data table, and learn SQL query statements to implement the query function in the program. • 4. Learn to add and delete SQL statements and add and delete functions in the program. • 5. Learn to modify SQL statements and implement the modification function in the program. • 6. Design User data tables and create login windows to Implement User Login functions. • 7. Permission control. Different users can log on to the system and perform operations differently. And follow the 4, 5 method to implement the user management interface.