استفاده از پایگاه داده ACCESS در C#
فصل اول : مقدمه
1-مقدمه .......................................................................................................................................................2
مطرح شدن به عنوان یک زبان صنعتی ..................................................................................................2
C# چیست ؟........................................................................................................................................3
کد مدیریت یافته .................................................................................................................................3
روش یادگیری ....................................................................................................................................4
خلاصه ................................................................................................................................................4
فصل دوم : آغاز كار با C#
آغاز کار با C#.......................................................................................................................................7
1-2- نامگذاری متغیر ها ..............................................................................................................................15
2-1-2- قواعد نامگذاری ...........................................................................................................................20
3-1-2- توصیه های برای نامگذاری متغیرها ................................................................................................21
2-2-1- انواع داده ای ساده .........................................................................................................................21
3-2- عملگر ها ..........................................................................................................................................21
1-3-2- دسته بندی عملگرها ......................................................................................................................21
2-3-2- ساختار دستورات و عملگرها .........................................................................................................22
3-3-2- علائم سجاوندی ...........................................................................................................................22
4-2- تبدیل نوع ..........................................................................................................................................27
5-2 تقدم عملگرها .....................................................................................................................................27
فصل سوم : ساختار کنترلی
1-3- دستور IF............................................................................................................................................30
2-3- دستور SWITCH ..............................................................................................................................33
3-3- دستورات تکرار .................................................................................................................................39
1-3-3- WHILE .......................................................................................................................................40
2-3-3- DO…While ..............................................................................................................................42
3-3-3-FOR .............................................................................................................................................44
4-3-3- Foreach ....................................................................................................................................47
4-3-دستورات پرش ...................................................................................................................................49
فصل چهارم : متد
1-4- فرم کلی متد ......................................................................................................................................52
1-1-4- دستور کلی return......................................................................................................................53
2-4- روش پاس دادن آرگومان به متد ........................................................................................................57
3-4-فراخوانی متد ......................................................................................................................................60
4-4- سربارگذاری متد ................................................................................................................................61
5-4- نکات کلیدی .....................................................................................................................................61
6-4- متد main..........................................................................................................................................63
7-4- متد static.........................................................................................................................................66
فصل پنجم : آشنايي با كلاسها در C#
2-5- چند ریختی ........................................................................................................................................73
3-5- name space ................................................................................................................................76
6- ویژگی ها در C# ...................................................................................................................................77
فصل ششم : ويژگيها در C#
فصل هفتم : مروري بر ADO .NET
1-7-روش برنامه نویسی در ADO.NET......................................................................................................93
2-7-CONNECTIONSTRING ..............................................................................................................97
3-7- تفاوت ADO,ADO.NET ................................................................................................................95
4-7- استفاده از DATA-COMMAND ..................................................................................................96
5-7- استفاده از DATA SET .....................................................................................................................97
6-7- Component های دسترسی به اطلاعات .........................................................................................99
7-7- مبانی و اصول اولیه Data-Reader .................................................................................................99
8-7- مبانی و اصول اولیه dataset...........................................................................................................100
9-7- data reader یا data set .........................................................................................................103
10-7- موارد استفاده مفید از dataset ....................................................................................................104
11-7- علل استفاده از dataset و علل عدم استفاده ................................................................................105
12-7- OIEDB چیست ؟..........................................................................................................................106
13-7- معرفی اعضای کلاس OIEDB ......................................................................................................107
فصل هشتم : آشنایی با Access
8-تعريف كلي از اكسسAccess ..........................................................................................................109
1-8-تكنيكهاي كار در اكسس ...............................................................................................................110
2-8-طراحي جدولTable ......................................................................................................................111
3-8-قواعد نامگذاري فيلدها .....................................................................................................................112
4-8- Table Wizard .........................................................................................................................113
5-8-آشنايي با خصوصيات فيلدها در محيط طراحي...................................................................................114
6-8- انواع عملگرها...................................................................................................................................117
7-8- آشنايي با تنظيم خصوصيات محيط ورود دادهData sheet View................................................118
8-8-انواع عملگرها....................................................................................................................................121
9-8-آشنايي با طراحي Query ...............................................................................................................122
10-8-آشنايي باطراحي فرمForm............................................................................................................128
11-8-گزارش چيست؟..............................................................................................................................130
12-8- طرز كار Report Wizard .......................................................................................................131
فصل نهم : دستورات SQL
1-9-دستور Select..................................................................................................................................133
2-9- استفاده از توابع در select .............................................................................................................134
3-9- دستور insert ................................................................................................................................137
4-9- دستور update .............................................................................................................................138
5-9- دستور delete ...............................................................................................................................140
فصل دهم : استفاده عملی از ACCESS در C#
منابع ..........................................................................................................................................................152