برنامه نویسی #C تحت ویندوز(Windows Application)

Windows Application Programming in C#.NET

Introduction to Windows Forms

• Create a form and add controls to it
• Create an inherited form by using Visual Inheritance
• Organize controls on a form

Deploying Windows Forms Applications

• Use strong-named assemblies in .NET applications.
• Use application configuration files to configure and use Microsoft Windows Installer 2.0 to package and deploy .NET applications.
• Control Class
• Buttons
• Text Boxes Labels, Literals
• Image Controls Picture Box Control
• Panel Control C#.NET 4.0 Syllabus www.ipsr.org ipsr solutions ltd
• Combo Box Control
• List Boxes
• Dropdown Lists
• Date Time Picker Control
• Link Labels
• Check Boxes
• Check Box Lists Radio Buttons
• Radio Button Lists
• Rich Text Box Control
• Tab Control
• Tool Strip Control
• Menu Strip Control

Creating Custom Control

• Create New Controls for Forms
• Create a Control from an Existing
• Control and Add Functionality

Introduction of DataBase Concept and SQL Server

• Introduction of 3 main Steps for software developing : Analysis / Design / Implementation(It refers to software engineering concepts)
• Structure of DataBase, Table and any object’s in Sql Server
• DDL commands in Sql (create, alter…)
• DML commands in Sql (select ,insert , update)a) Introduction to SQL
  b) Evolution of ADO.NET after Native Drivers, ODBC Drivers

c) About Managed Providers
d) Important Objects in Managed Provider

a) Creating Database using VS.NET
b) Establishing Connection with Database
c) Connection String Formats

a) Executing simple Insert, Update and Delete Statements

b) Executing Select Statement and using SqlDataReader

a) Prepared Statements
b) Stored Procedures

a) Managing Transactions
b) Asynchronous Execution of Sql Statements
c) To write provider independent code

• Functions in Sql
• Stored procedures in Sql
• Views and Joins of Tables in Sql
• Constraints to perform security and data validation in Sql
• Joining Sql server abilities with ADO.net solutions

Joining Sql server abilities with Entity Frame work solutions

Introduction of Entity Frame work as the Most Modern way of Using Data in Application

• Building Entity Data Models
• Introduction to Entity Data Models
• Modifying the Entity Data Model
• Customizing the Entity Data Model

• Querying Entity Data
• Retrieving Data by Using LINQ to Entities
• Retrieving Data by Using Entity SQL
• Retrieving Data by Using Entity Client Provider
•  Retrieving Data by Using Stored Procedures
• Unit Testing Your Data Access Code

• Creating, Updating, and Deleting Entity Data
• Understanding Change Tracking in the Entity Framework Modifying Data in an Entity Data Model

• Building Optimized Solutions by Using Object Services
• The Stages of Query Execution
• Change Tracking and Object Materialization
• Using Compiled Queries
• Using Design-Time Generated Entity Framework Views
• Monitoring Performance
• Performing Asynchronous Data Modifications

• Customizing Entities and Building Custom Entity Classes
• Overriding Generated Classes
• Using Templates to Customize Entities
• Creating and Using Custom Entity Classes

Using Data in Windows Forms Applications /Using Sql Server’s commands

• ADO.NET (Working with Database)
• Describe the objects in the ADO.NET object model.
• Add and configure ADO.NET objects in a Windows Forms application.
• Access and modify data from a database by using Datasets.
• Connection Object
• Command Object
• Data Readers
• Data Sets & Data Adapters
• Execute non-query, Execute scalar
• Execute reader
• Data Grid View Control
• Data Bindings of data base controls

Creating MDI Applications

•  MDI Applications
• MDI Parent and MDI Child Forms
• Manage Menus

Securing Windows Forms Applications

• Describe the .NET Framework security model.
• Use code access security to secure an application.
• Use role-based security to control access to an application.

Building Setup Applications

• Installation Package
• Customize a Setup Project

• Control Installation of an Application

• Specify Conditions of an Install
• Custom Actions for after an Installation

Exception Handling

• Exception Class

• Try, Catch, Finally
• Working with Exception Handling