المشاركات

عرض المشاركات من يوليو, 2025

Core Azure architectural components (regions, availability zones, resource groups)

Lesson 2.2: Core Azure Architectural Components 🔹 Azure Regions Region: A set of datacenters deployed within a specific geographic location. Microsoft Azure is available in geographically distributed regions around the world. Each region is a separate deployment area, such as East US, West Europe, Southeast Asia, etc. Choosing a region close to your users reduces latency and improves performance. 🔹 Availability Zones Availability Zones: Physically separate datacenters within a region. Each zone has independent power, cooling, and networking. Used to enhance availability and fault tolerance for applications and data. You can replicate applications across zones to ensure high availability. 🔹 Resource Groups Resource Group: A container that holds related Azure resources. Resources that share the same lifecycle (e.g., web app, database, storage account) should be grouped together. You can manage resources collectively (monitoring, access control, deletion, etc.)...

Shared responsibility model in the cloud

Shared Responsibility Model in the Cloud In this lesson, you’ll learn about the Shared Responsibility Model, which outlines the division of responsibilities between the cloud provider (e.g., Microsoft Azure) and the customer across different cloud service models (IaaS, PaaS, SaaS). 🔄 What is the Shared Responsibility Model? The Shared Responsibility Model defines which security tasks are handled by the cloud provider and which by the customer. The level of responsibility shifts depending on whether you are using IaaS, PaaS, or SaaS. 🔐 Responsibilities Breakdown Responsibility Cloud Provider Customer Physical security of datacenters ✔️ ❌ Network controls (firewalls, traffic filtering) Depends on model Depends on model Data classification and protection ❌ ✔️ User access management ❌ ✔️ ...

Describe Cloud Computing Models

Describe Cloud Computing Models In this lesson, you’ll explore the three main cloud computing models: Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). 📦 The Three Cloud Models IaaS (Infrastructure as a Service): Provides virtualized computing resources such as virtual machines, storage, and networking. You manage the OS, apps, and data. Example: Azure Virtual Machines. PaaS (Platform as a Service): Offers a platform for building, testing, and deploying applications without managing the underlying infrastructure. Example: Azure App Service. SaaS (Software as a Service): Delivers fully functional applications over the internet. Users just use the software; the provider manages everything. Example: Microsoft 365, Outlook.com. 📊 Comparison Table Model You Manage Provider Manages IaaS OS, Middleware, Apps, Data Hardware, Networking ...

Describe the benefits of using cloud services

Describe the Benefits of Cloud Computing In this lesson, you’ll explore the main benefits that cloud computing offers to individuals and organizations, helping them to be more efficient, agile, and secure. 🌟 Key Benefits of Cloud Computing Cost Efficiency: Reduces capital expenses (CapEx) by eliminating the need for hardware purchases and maintenance. Scalability: Easily scale resources up or down to meet changing workloads. High Availability: Provides reliable access to services and data with built-in redundancy and failover support. Performance: Offers access to high-performance computing infrastructure and globally distributed data centers. Security: Includes built-in security features like encryption, access controls, and compliance certifications. Business Continuity: Supports data backup, disaster recovery, and geographic redundancy. ⚙️ Operational Advantages Agility: Quickly deploy and experiment with new ideas without long p...

Benefits of Using AI on Azure

Lesson 1.4: Benefits of Using AI on Azure In this lesson, you'll discover the main benefits of using Microsoft Azure for building and deploying AI solutions efficiently and responsibly. 🚀 Key Benefits Prebuilt AI Models: Access to ready-to-use Cognitive Services that accelerate AI development without requiring deep machine learning expertise. Customizability: Customize models using your own data with services like Custom Vision, Azure Machine Learning, and Language Understanding. Scalability: Run AI workloads across a global, enterprise-grade cloud infrastructure that supports high availability and autoscaling. Security and Compliance: Built-in support for identity, role-based access control, and compliance with global regulations (e.g., GDPR, ISO). 🔧 Development Efficiency Tooling Integration: Seamlessly integrates with tools like Visual Studio Code, Azure Machine Learning Studio, and Jupyter Notebooks. API and SDK Access: Easy ac...

Introduction to Azure AI services

Lesson 1.3: Introduction to Azure AI Services In this lesson, you'll explore the key AI services offered by Microsoft Azure and how they simplify building intelligent applications without needing deep data science expertise. 🧰 Azure AI Service Categories Azure Machine Learning: A cloud-based platform for building, training, and deploying machine learning models. Azure Cognitive Services: Pre-built APIs for vision, speech, language, and decision-making capabilities. Azure OpenAI Service: Provides access to powerful generative AI models such as GPT for text, image, and code generation. Azure Bot Services: Tools to create, test, and deploy conversational AI bots integrated with other Azure services. 🧠 Azure Cognitive Services Breakdown Vision: Analyze images, recognize objects, detect faces, and extract text using OCR. Speech: Convert speech to text, text to speech, and perform speech translation. Language: Perform sentiment analy...

Types of AI Workloads

Lesson 1.2: Types of AI Workloads In this lesson, you'll learn about the different types of AI workloads and how they are categorized based on the tasks they perform. 📦 Common AI Workloads Machine Learning: Training models on historical data to make predictions or classifications on new data. Anomaly Detection: Identifying unusual patterns that do not conform to expected behavior, often used in fraud detection or equipment monitoring. Computer Vision: Processing and analyzing visual data (images or video), such as recognizing objects or detecting faces. Natural Language Processing (NLP): Interpreting and generating human language, including speech and text. Conversational AI: Building bots and virtual assistants that understand and respond to user input in natural language. 🔁 Training vs Inference Training: The process of teaching an AI model using historical data and labels to adjust internal parameters. Inference: Using a tra...

What is Artificial Intelligence?

Lesson 1.1: What is Artificial Intelligence? In this lesson, you'll be introduced to the concept of Artificial Intelligence (AI), its goals, and how it powers modern solutions across industries. 🧠 Definition of AI Artificial Intelligence (AI): The simulation of human intelligence by machines, especially computer systems, enabling them to perform tasks that typically require human intelligence. Goals of AI: Understanding, reasoning, learning, and self-correction. 🌍 Real-World Applications Healthcare: Diagnosing diseases, analyzing medical images, personalized treatment recommendations. Finance: Fraud detection, credit scoring, algorithmic trading. Retail: Personalized recommendations, inventory forecasting, customer support bots. Transportation: Autonomous vehicles, traffic prediction, route optimization. Manufacturing: Predictive maintenance, quality control with computer vision. 🔧 Categories of AI Capabilities Narro...

Tour of the Report Builder User Interface

Lesson 1.4: Tour of the Report Builder User Interface In this lesson, you'll get familiar with the main components of the Microsoft Report Builder interface to efficiently design your reports. 🖥️ Main Interface Components Ribbon: The top toolbar containing tabs like Home, Insert, Page Layout, Run, and View, with buttons to manage report design and execution. Design Surface: The central canvas where you visually design your report layout by adding tables, charts, text boxes, and other items. Report Data Pane: Located usually on the left side, this pane lets you manage data sources, datasets, parameters, and images used in the report. Grouping and Sorting Pane: Helps organize data within tables or lists by defining groupings and sorting rules. Properties Pane: Displays properties of the selected report item for customization, such as fonts, colors, and layout settings. Preview Tab: Allows you to run and preview the report output with actual ...

Installing and Opening Microsoft Report Builder

Lesson 1.3: Installing and Opening Microsoft Report Builder In this lesson, you will learn how to download, install, and launch Microsoft Report Builder to start creating reports. 📥 Downloading Report Builder Visit the official Microsoft Report Builder download page: Microsoft Report Builder Download . Choose the appropriate version based on your system architecture (usually 64-bit). Click the download button and save the installer file. ⚙️ Installing Report Builder Run the downloaded installer (.exe) file. Accept the license terms and click Next . Choose the installation folder or leave the default. Click Install and wait for the process to complete. Click Finish to exit the installer. 🚀 Launching Report Builder Open the Start Menu and search for Report Builder . Click the Report Builder app to launch it. On first launch, you may be prompted to connect to a report server or start a new report. You can start with a...

What is SQL Server Reporting Services (SSRS)?

Lesson 1.2: What is SQL Server Reporting Services (SSRS)? In this lesson, you'll learn the basics of SQL Server Reporting Services (SSRS), a powerful server-based reporting platform from Microsoft. 📌 Overview SSRS is a server-based reporting platform used to create, manage, and deliver reports. It supports creating paginated reports that are ideal for printing or fixed-layout formats like PDF. Reports can be accessed via a web portal, integrated into applications, or delivered through email subscriptions. SSRS integrates with Microsoft SQL Server but can connect to a variety of data sources. 🎯 Key Components Report Server: The engine that processes and renders reports. Report Manager / Web Portal: A web interface to view and manage reports and subscriptions. Report Designer Tools: Applications like Report Builder and SQL Server Data Tools (SSDT) used to create reports. Report Server Databases: Store report metadata, security i...

What is Microsoft Report Builder?

Lesson 1.1: What is Microsoft Report Builder? In this lesson, you'll get introduced to Microsoft Report Builder — a lightweight report authoring tool for SQL Server Reporting Services (SSRS). 📌 Overview Microsoft Report Builder is a free standalone report authoring tool. It is designed for creating paginated reports (ideal for printing or PDF export). Works seamlessly with SQL Server Reporting Services (SSRS) or Power BI Report Server . It allows users to design, preview, and publish reports without needing Visual Studio. 🎯 Key Features Drag-and-drop report design interface Support for tabular and matrix (pivot-style) layouts Rich data visualizations: charts, gauges, maps Expressions and calculated fields using VB.NET syntax Multiple export options: PDF, Excel, Word, XML, etc. 💡 Why Use Report Builder? Designed for business users and analysts Does not require developer tools or Visual Studio Easy to connect to...

Cleaning and Transforming Data Using Power Query

Lesson 4: Cleaning and Transforming Data Using Power Query In this lesson, you'll learn how to clean and prepare your data using the Power Query Editor in Power BI Desktop. 🧹 What is Power Query? Power Query is a data transformation tool built into Power BI. It allows users to shape, clean, and enrich their data without writing code. Uses a GUI-based editor. Supports over 300 transformations. Runs on the M language under the hood. ⚙️ Opening the Power Query Editor After connecting to a data source, click Transform Data . The Power Query Editor window will open with a preview of your data. You can now apply transformations step by step. 🔧 Common Data Transformations Remove Columns/Rows: Delete unnecessary data. Filter Rows: Keep only relevant records. Change Data Types: Set fields as Date, Text, Number, etc. Split Column: Break a single column into multiple parts. Merge Columns: Combine multiple columns into one. Replace Values: Clean up ty...

Connecting to Data Sources in Power BI

Lesson 3: Connecting to Data Sources in Power BI In this lesson, you will learn how to connect Power BI Desktop to different data sources such as Excel, CSV, databases, and web APIs. 🔗 Common Data Sources Power BI supports a wide range of data sources. The most commonly used include: Excel – Connect to .xlsx or .xls files. CSV/Text – Flat files like .csv and .txt. SQL Server – Connect to relational databases. Web – Fetch data from REST APIs or online tables. SharePoint – Import from lists or files stored on SharePoint sites. 📥 How to Connect to a Data Source Follow these steps to connect: Open Power BI Desktop. Click on Home > Get Data . Choose the data source (e.g., Excel, SQL Server). Navigate to the file or server and click Connect . Select the tables/sheets you want to load. Click Load to import data, or Transform to clean it first. ⚡ Import vs. DirectQuery When connecting to databases, you will be ...

Installing and Exploring Power BI Desktop

صورة
Lesson 2: Installing and Exploring Power BI Desktop In this lesson, you will learn how to download, install, and get familiar with the Power BI Desktop interface. ⬇️ Downloading Power BI Desktop You can download Power BI Desktop from the official Microsoft website or the Microsoft Store: https://powerbi.microsoft.com/desktop Or search for "Power BI Desktop" in the Microsoft Store Once downloaded, follow the installation wizard to complete the setup. 🖥️ Launching Power BI Desktop After installation, open Power BI Desktop. You will see a welcome screen with options to: Get Data Open a recent report Learn tutorials and documentation Click on “ Get Data ” to start connecting to your first data source. 🧭 Exploring the Interface The main interface of Power BI Desktop is divided into several key areas: Ribbon: Contains tabs like Home, View, Modeling, etc. Fields Pane: Shows tables and fields from the connected d...

What is Power BI?

Lesson 1: What is Power BI? In this lesson, you will learn what Power BI is and the key components that make up the Power BI ecosystem. 📦 Power BI Components Power BI is a suite of tools developed by Microsoft for business intelligence and data visualization. It includes three main components: Power BI Desktop – A free Windows application to create reports and dashboards. Power BI Service – A cloud-based service to publish, share, and collaborate on reports. Power BI Mobile – Mobile apps for Android and iOS to view dashboards and stay updated on the go. 🖥️ Power BI Desktop Power BI Desktop is a free application that runs on Windows. It allows users to: Import and clean data from multiple sources (Excel, CSV, SQL, etc.). Create interactive reports using charts, tables, and visuals. Use Power Query for data transformation. It is the main tool for report development before publishing to the cloud. ☁️ Power BI Service Powe...

Entity Framework Core Basics

Lesson 8: Entity Framework Core Basics In this lesson, you will learn about Entity Framework Core (EF Core) , the main Object-Relational Mapper (ORM) for .NET applications. 🗄️ What is EF Core? Entity Framework Core is a lightweight, cross-platform ORM that: Maps C# classes to database tables. Handles CRUD operations automatically. Supports LINQ queries against your data. It works with many databases like SQL Server, SQLite, PostgreSQL, and more. 🔧 Setting Up EF Core To add EF Core, install the NuGet package: dotnet add package Microsoft.EntityFrameworkCore.SqlServer Then create a DbContext to manage your entities. 🏷️ Example Entity and DbContext Here is an example model and context: using Microsoft.EntityFrameworkCore; public class Product { public int Id { get; set; } public string Name { get; set; } public decimal Price { get; set; } } public class AppDbContext : DbContext { public DbSet Products { g...

Introduction to ASP.NET Core

Lesson 7: Introduction to ASP.NET Core In this lesson, you will learn about ASP.NET Core , the modern framework for building web applications and APIs. 🌐 What is ASP.NET Core? ASP.NET Core is an open-source, cross-platform framework for building: Web applications (MVC and Razor Pages). RESTful APIs. Real-time apps (SignalR). It runs on Windows, Linux, and macOS. 🚀 Key Features ASP.NET Core provides: Cross-platform support: Run anywhere. High performance: Optimized for speed and scalability. Dependency Injection: Built-in DI container. Unified development model: For web UI and APIs. Modern hosting: Integrated with Kestrel server. 🛠️ Project Structure An ASP.NET Core project typically includes: Program.cs : Entry point for configuring the app. Startup.cs : (in older versions) Configures services and middleware. appsettings.json : Configuration file. Controllers : API or MVC controllers. Views : R...

Language Integrated Query (LINQ)

Lesson 6: Language Integrated Query (LINQ) In this lesson, you will learn about Language Integrated Query (LINQ) , a powerful feature that lets you query data in a consistent way across collections, databases, XML, and more. 🔍 What is LINQ? LINQ allows you to write queries directly in C# or VB.NET, using familiar syntax to manipulate: In-memory collections (LINQ to Objects). Databases (LINQ to SQL, Entity Framework). XML (LINQ to XML). 📝 Basic LINQ Query Here is an example querying an array of integers: using System; using System.Linq; class Program { static void Main() { int[] numbers = { 1, 2, 3, 4, 5, 6 }; var evenNumbers = from n in numbers where n % 2 == 0 select n; foreach (var num in evenNumbers) { Console.WriteLine(num); } } } ⚙️ Extension Methods Syntax You can also use method syntax with extension methods:...

The .NET Base Class Library (BCL)

Lesson 5: The .NET Base Class Library (BCL) In this lesson, you will discover the Base Class Library (BCL) , the set of core libraries that provides fundamental building blocks for all .NET applications. 📚 What is the BCL? The BCL is a collection of classes, interfaces, and types that cover essential functionality, including: Basic types (strings, numbers, dates). Collections and generics. File I/O. Networking. Reflection and metadata. These libraries are part of System.* namespaces. 🧩 Key Namespaces in the BCL Here are some important namespaces you will use often: System: Core types like String, Int32, DateTime. System.Collections: Non-generic collections. System.Collections.Generic: Generic collections like List<T> and Dictionary<TKey, TValue>. System.IO: Reading and writing files and streams. System.Net: Networking and HTTP communication. System.Linq: Language Integrated Query (LINQ) support. ...

Common Language Runtime (CLR)

Lesson 4: Understanding the Common Language Runtime (CLR) in Depth In this lesson, you will dive deeper into the Common Language Runtime (CLR) , the engine that powers all .NET applications. ⚙️ What is the CLR? The CLR is the runtime environment for .NET code. It manages the execution of programs written in different languages targeting .NET. Compiles Intermediate Language (IL) into native code. Provides memory management and garbage collection. Handles security, type safety, and exception handling. 🔄 Compilation Process When you build a .NET application: Your C# code is compiled into Intermediate Language (IL) . IL is stored in an assembly (DLL or EXE). At runtime, the Just-In-Time (JIT) compiler converts IL to native machine code. This process ensures high performance while keeping platform independence. 🧠 Key CLR Services The CLR offers many services that simplify development: Garbage Collection: Automatically fr...

.NET Architecture and Component

Lesson 3: .NET Architecture and Components In this lesson, you will learn about the architecture of .NET and its main components that make development easier and more powerful. 🏛️ High-Level Architecture .NET consists of several building blocks that work together: Common Language Runtime (CLR): The execution engine that runs your code and provides services like garbage collection and security. Base Class Library (BCL): A set of APIs for common tasks such as collections, file I/O, and data types. Languages: C#, F#, Visual Basic, and more, all compiled to Intermediate Language (IL). Application Models: Web, desktop, mobile, cloud, IoT. ⚙️ Common Language Runtime (CLR) The CLR is the heart of .NET. It performs: Memory management: Automatic garbage collection. Exception handling: Unified error management. Type safety: Ensures code correctness and security. Just-In-Time (JIT) compilation: Compiles IL code to native machine c...

History and Evolution of .NET

Lesson 2: History and Evolution of .NET In this lesson, you will learn how .NET has evolved over time, from its early beginnings to the modern unified platform we have today. 📜 The Beginning Microsoft started working on .NET in the late 1990s to modernize software development for Windows. The first official release was: .NET Framework 1.0 in 2002 This version included the Common Language Runtime (CLR) and Base Class Library (BCL). 🔄 .NET Framework Growth Over the years, .NET Framework received many updates and improvements: ASP.NET: For building web applications. Windows Forms: For building desktop apps. WPF: Rich desktop applications with modern UI. WCF: Services and communication. Entity Framework: Object-relational mapping (ORM). 🌐 The Cross-Platform Revolution With the rise of Linux, macOS, and open-source development, Microsoft introduced: .NET Core 1.0 in 2016: Lightweight, modular, and cross-platform....

What is .NET?

Lesson 1: What is .NET? In this lesson, you will learn what .NET is, why it exists, and how it helps developers build modern applications. 🌟 What is .NET? .NET is a free, open-source, cross-platform development platform created by Microsoft. It enables you to build different types of applications, including: Web applications Desktop applications Mobile applications Cloud services Games Internet of Things (IoT) apps 🛠️ Core Components of .NET .NET Runtime: Executes your application code, manages memory, performs garbage collection, and enforces security. Base Class Library (BCL): A large collection of prebuilt APIs and classes for file operations, networking, data access, collections, and security. Languages: .NET supports C#, Visual Basic .NET (VB.NET), and F#. SDK: Tools, compilers, and libraries to create, build, and run .NET applications. 💡 Why Use .NET? Cross-Platform: Works on Windows, Linux, and macOS...

Visual Basic - بدء عملية الربط (Initiating the Bind)

📘 درس Visual Basic - بدء عملية الربط (Initiating the Bind) 🔹 ما هي عملية الربط؟ عملية الربط (Binding) هي آلية تحميل الـ Assemblies الضرورية للتطبيق في وقت التشغيل. يبدأ CLR البحث عن الـ Assembly المطلوب عند محاولة استدعاء كود أو كائن منه. ✅ خطوات الربط الأساسية يحدد CLR اسم الـ Assembly والنسخة المطلوبة. يبحث عنه في Global Assembly Cache (GAC). يبحث في مجلد التطبيق والمجلدات المعرفة في Probing. إذا لم يتم العثور، تظهر خطأ FileNotFoundException. 💻 مثال تتبع مسار الربط يمكنك تشغيل أداة Fuslogvw المرفقة مع .NET Framework لتتبع كيف تم البحث عن الـ Assemblies ومعرفة أسباب فشل الربط.

Visual Basic - تجهيز وتوزيع تطبيقات .NET Framework (Packaging and Distributing)

📘 درس Visual Basic - تجهيز وتوزيع تطبيقات .NET Framework (Packaging and Distributing) 🔹 ما المقصود بالتجهيز والتوزيع؟ تجهيز التطبيق يعني جمع جميع الملفات المطلوبة (EXE، DLL، الموارد) في حزمة واحدة قابلة للتثبيت أو النسخ على جهاز المستخدم. التوزيع هو عملية نشر هذه الحزمة للمستخدمين النهائيين. ✅ أساليب تجهيز وتوزيع التطبيقات إنشاء ملف Setup باستخدام Visual Studio Installer. نشر ClickOnce. النسخ اليدوي للمجلد الناتج من Build. 💻 مثال إعداد مشروع Setup يمكنك إضافة مشروع جديد من نوع Setup Project في Visual Studio، ثم تحديد: المجلدات التي تحتوي الملفات. شروط التثبيت. إنشاء اختصارات على سطح المكتب. بعد ذلك تولد ملف MSI لتوزيعه.

Visual Basic - استخدام Codebases و Probing في النشر

📘 درس Visual Basic - استخدام Codebases و Probing في النشر 🔹 ما هو Codebase؟ Codebase هو مسار يحدد أين يمكن للنظام العثور على ملفات الـ Assembly إذا لم تكن في المجلد الافتراضي للتطبيق. 🔹 ما هو Probing؟ Probing هو آلية بحث تلقائي يستخدمها CLR للبحث عن الـ Assemblies المطلوبة في مجلدات محددة مثل bin أو مجلدات فرعية تعرفها في التكوين. ✅ مثال على تكوين Codebase وProbing في ملف app.config

Visual Basic - تحديد موقع الـ Assembly (Locating the Assembly)

📘 درس Visual Basic - تحديد موقع الـ Assembly (Locating the Assembly) 🔹 ما هو الـ Assembly؟ الـ Assembly هو ملف التنفيذ الرئيسي لتطبيقك (EXE أو DLL) يحتوي على الكود المترجم، التعريفات، والموارد اللازمة لتشغيل التطبيق. ✅ أهمية تحديد موقع الـ Assembly تحميل الملفات المرتبطة في وقت التشغيل. قراءة المسارات النسبية للموارد. إدارة التكوين والتحديثات. 💻 مثال الحصول على مسار الـ Assembly الحالي Dim location As String = System.Reflection.Assembly.GetExecutingAssembly().Location MessageBox.Show("مسار Assembly: " & location)

Visual Basic - مقدمة حول نشر التطبيقات (Deploying Applications)

📘 درس Visual Basic - مقدمة حول نشر التطبيقات (Deploying Applications) 🔹 ما هو نشر التطبيقات؟ نشر التطبيقات يعني تجهيز ملفات البرنامج لتوزيعها على أجهزة المستخدمين، مع ضمان عمل التطبيق بشكل صحيح بعد التثبيت. ✅ أنواع النشر في .NET نشر يدوي عبر نسخ الملفات. إنشاء حزمة تثبيت باستخدام Setup Project. النشر باستخدام ClickOnce. 💻 مثال مبسط على النشر بـ ClickOnce يمكنك النشر بسهولة من Visual Studio: من قائمة المشروع اختر "Publish". حدد المسار (مجلد - URL - قرص). اتبع معالج النشر حتى النهاية.

Visual Basic - مقدمو البيانات (Data Providers)

📘 درس Visual Basic - مقدمو البيانات (Data Providers) 🔹 ما هو Data Provider؟ مقدم البيانات هو مكوّن برمجي يوفّر الوظائف الأساسية للاتصال بقاعدة البيانات وتنفيذ الأوامر والاستعلامات. يحدد كيفية تواصلك مع أنواع مختلفة من قواعد البيانات. ✅ أمثلة على مقدمي البيانات في .NET SqlClient: الاتصال بـ SQL Server. OleDb: الاتصال بملفات Access أو Excel. Odbc: الاتصال بأنواع قواعد بيانات أخرى باستخدام ODBC. 💻 مثال على استخدام SqlClient Dim conn As New SqlClient.SqlConnection("Data Source=.;Initial Catalog=MyDB;Integrated Security=True") conn.Open() Dim cmd As New SqlClient.SqlCommand("SELECT * FROM Employees", conn) Dim reader As SqlClient.SqlDataReader = cmd.ExecuteReader() While reader.Read() Console.WriteLine(reader("Name").ToString()) End While conn.Close()

Visual Basic - مقدمة حول الوصول إلى البيانات (Introduction to Data Access)

📘 درس Visual Basic - مقدمة حول الوصول إلى البيانات (Introduction to Data Access) 🔹 ما هو الوصول إلى البيانات؟ الوصول إلى البيانات يعني قراءة البيانات من مصدر مثل قاعدة بيانات أو ملف، أو تعديلها وتخزينها. في Visual Basic، يمكنك استخدام ADO.NET لإدارة الاتصال ومعالجة البيانات. ✅ خطوات أساسية للوصول إلى البيانات إنشاء اتصال بقاعدة البيانات. فتح الاتصال. تنفيذ استعلامات SQL. قراءة النتائج أو تحديث البيانات. إغلاق الاتصال بعد الانتهاء. 💻 مثال مبسط على الاتصال بقاعدة بيانات Dim conn As New SqlClient.SqlConnection("Data Source=.;Initial Catalog=MyDB;Integrated Security=True") conn.Open() ' تنفيذ العمليات هنا conn.Close()

Visual Basic - التعامل مع أحداث النماذج (Handling Form Events)

📘 درس Visual Basic - التعامل مع أحداث النماذج (Handling Form Events) 🔹 ما هي أحداث النماذج؟ هي أحداث تحدث أثناء دورة حياة النموذج مثل التحميل (Load)، الإغلاق (Closing)، أو التنشيط (Activated). يمكنك كتابة كود مخصص للتعامل مع هذه الأحداث. ✅ أمثلة على أهم الأحداث Load: عند تحميل النموذج لأول مرة. FormClosing: قبل إغلاق النموذج. Activated: عند تنشيط النموذج. 💻 مثال التعامل مع حدث FormClosing Private Sub Form1_FormClosing(sender As Object, e As FormClosingEventArgs) _ Handles Me.FormClosing MessageBox.Show("سيتم إغلاق النموذج الآن") End Sub