درباره دوره

نوشتن برنامه بصورت حرفه ای با #C تحت ویندوز

– برنامه نویسی گرافیک با #C
– آشنایی با طراحی و ساخت بانک اطلاعاتی SQL
– رابط #C با لایه بانک اطلاعاتی
– ارتباط #application C با سایر application های معروف مثل Excel ,Access ,Arc GIS, 3DsMax

پیشنیاز

مبانی برنامه نویسی #C

سرفصل

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

Sql server advanced tools using in C# code

Data manipulating more efficiently using professional Sql commands
Creating powerful structures in sql server to hold , retrieve and secure and safe off
Creating stored procedures,UDF,triggers and views
Introduction of JOIN in sql command

Relation to database more efficiently

Making a secure an understandable relation between data base and application
Updating application’s relation in case of any change in database
Using high speed access to database by Tsql

Adding widely used applications to C# Windows apps

How to add other libraries to visual studio such as working with barcode reader and Captcha sequrity texts
Using added libraries in code
Get output of C# windows application in famous applications user need like Excel, AutoCAD and etc…

Professional Layout using Modern Metro Style Forms(windows 8 and 10 themes)

How to get metro dlls
How to add metro references
Using metro forms and controls in C#

Office programming in C# windows forms

Making an application with each office application’s layout and their functionalities

Reading data from office applications and writing

Call and execute office from C# code

Building DLL library in C# that are callable by other managed applications

Create and Use Assemblies Using the Command Line

Determine If a File Is an Assembly

Load and Unload Assemblies

Share an Assembly with Other Applications

Embedding Types from Managed Assemblies

Embedding Type Information from Microsoft Office Assemblies

مدرس / مدرسین

لیلا شکری

پردازش تصویر و استخراج داده از هیستوگرام تصاویر به زبان C#
تدریس دوره طراحی تحلیل و ساخت نرم افزارهای شغلی تحت ویندوز متصل به وب
تدریس دوره طراحی تحلیل و ساخت وب سایتهای net و PHP مجهز به بانک اطلاعاتی
تدریس مفاهیم و اصول پیکر بندی بانکهای اطلاعاتی
برنامه نویسی حرفه ای بانک اطلاعاتی SqlServer و Professional Administrative Tools
تدریس دوره مبانی برنامه نویسی زبان C , C++ basics and OOP
تدریس دوره مبانی برنامه نویسی زبان Python , IronPython
و …