C# Full-Stack Development: OOP and SQL Stored Procedures

In this video, we introduce the SQL environment and explore the basics of T-SQL. Learn how to set up your SQL environment, declare variables with different data types, and use the PRINT statement to display values. We also cover how to write a simple WHILE loop to automate tasks and repeat actions in SQL. Perfect for beginners looking to get started with SQL programming!

In this video, we'll guide you through creating tables and stored procedures in SQL. You'll learn how to define tables with various data types, set primary keys, and insert data. We’ll also cover how to write and execute stored procedures to simplify repetitive tasks and improve query efficiency.

In this video, we’ll guide you through creating an MDI (Multiple Document Interface) application in C#. Learn how to add an MDI parent form, create a normal child form, and set up a menu to display the child form when selected. This video covers the basics of MDI applications, providing a foundation for building complex, multi-window desktop applications in C#

In this video, you'll learn how to add a label and a textbox to a Windows Form in C#. We’ll show you how to position the controls, set their properties, and make them ready for user input—an essential step in creating interactive and user-friendly applications.

In this video, we demonstrate how to create a ClearText function to reset form fields and implement simple validation to check user input before saving. You'll learn how to ensure required fields are filled and how to keep your forms clean and user-friendly

In this video, we create a Country class in C# and demonstrate how to define its properties and basic methods. You'll learn how to create objects from the class, set and retrieve property values, and implement simple functionality like displaying country details. This is a practical step in understanding how classes work in real-world applications.

In this video, you'll learn how to connect your UI to the Country class by creating and accessing a Country object from a Windows Form. We’ll show how to capture user input through textboxes, pass it to the class, and display results—bringing together UI and backend logic for a complete, interactive experience.

In this video, you'll learn how to create a login in Microsoft SQL Server. We’ll walk you through creating a new SQL Server login, assigning it a password, and granting access to database. This is essential for managing user authentication and controlling access to your SQL databases securely

In this video, you'll learn how to work with a connection string in C# by hard-coding it directly in your application. We’ll show you how to write a basic connection string, use it to connect to a SQL Server database, and run simple commands—laying the foundation for future improvements like storing the string in an xml file.

In this video, you will learn how to install Microsoft.Data.SQLClient in your Visual Studio project using the NuGet Package Manager Console. It's a quick and easy guide to get you up and running!

In this video, I walk you through troubleshooting connection string issues in my project. After facing some challenges with the connection setup, I finally resolve them and demonstrate how the database opens successfully using a connection object. Watch as I share the process of identifying the problem and fixing it step by step!

In this video, you'll learn how to retrieve data from a database using a DbDataReader through a Stored Procedure. I’ll guide you through the process of creating and executing the stored procedure, handling the data retrieval efficiently, and reading the results with DbDataReader.

The objective of this section is to guide you through the process of displaying retrieved data on the user interface (UI).

You’ll learn how to effectively retrieve data, handle it in your application, and ensure it’s displayed in a user-friendly way.

By the end of this section, you'll have the knowledge to create dynamic applications that communicate seamlessly with databases, making your UI interactive and responsive to real-time data. This is an essential skill for building data-driven applications.

In this video, I walk you through how to work with an ArrayList in C# and handle exceptions using a try-catch block. You'll learn how to add elements to an ArrayList, access them safely, and manage errors . Watch as I demonstrate how to use error handling to ensure your code runs smoothly even when things go wrong!

In this video, I demonstrate how to loop through a list of countries in C# using a foreach loop. You’ll learn how to create and populate a collection of country names, and then iterate over them to display or process the data. This step-by-step guide will help you understand how to efficiently loop through collections and handle data in your projects!

In this video, I show you how to display a list of countries in a ListView control in C#. You'll learn how to populate the ListView with country names, customize the display, and handle user interactions. Watch as I walk you through the entire process to create an interactive and user-friendly UI for displaying your data!

In this video, I introduce you to the params keyword in C#, showing how it allows you to pass a variable number of arguments to a method. You’ll learn how to use params to simplify method signatures and make your code more flexible, letting you work with arrays or a series of values without having to specify the exact number of parameters. Watch as I walk through real examples to help you understand this powerful feature!

In this video, I demonstrate the params keyword in action in C#. You’ll see how to use params to pass a dynamic number of arguments to a method, making your code more flexible and cleaner

In this video, I introduce the getDBResults() method, our standard approach for making dynamic calls to stored procedures with varying parameters across the entire project. You'll see how this versatile method efficiently handles different parameter types from APIs or classes, ensuring flexibility and consistency when querying the database. Watch as I demonstrate how it simplifies database interactions and serves as the backbone for all database calls in the project!

In this video, I explain the getCountry() method, which is used to retrieve country data from the database or API. You’ll learn how this method simplifies the process of fetching country details based on specific criteria, making it easier to integrate country-related information into your application. Watch as I walk you through the code and demonstrate how to use getCountry() effectively for seamless data retrieval!

In this video, I demonstrate how to pick a selected item from a ListView in C#. You’ll learn how to handle user selection events, retrieve the selected item, and perform actions based on that selection. Watch as I walk you through a practical example, showcasing how to work with ListView controls and interact with the data dynamically in your application!

In this video, I break down the parameters used in an AddEdit stored procedure. You’ll learn how to pass and handle parameters for adding or editing records in the database, and how these parameters work to ensure efficient and secure data operations. Watch as I explain the logic behind setting up and using parameters for CRUD operations, helping you understand how to manage data effectively through stored procedures!

In this video, I show you how to pass values from a C# class to a stored procedure. You’ll learn how to map class properties to stored procedure parameters, ensuring smooth data transfer between your application and the database. Watch as I demonstrate the process of passing values dynamically, making it easier to perform database operations based on the data in your application!

In this video, I walk you through the process of passing values from the UI to a C# class, then to a stored procedure, and finally displaying the results on the UI. You’ll learn how to capture user input, send it to your class, call the stored procedure with the necessary parameters, and display the returned data. Watch as I guide you through each step to ensure smooth data flow between your UI, class, and database!

In this video, I explain the DeleteCountry() method, which is responsible for deleting country records from the database. You’ll learn how this method handles the process of removing a country entry based on specific criteria, ensuring that the operation is both secure and efficient

In this video, I walk you through the process of building a PatientUI, working with stored procedures (SPs), and integrating them with a class in C#. You'll learn how to create a user interface for managing patient data, interact with stored procedures to retrieve and manipulate information, and structure the code using a class to ensure clean, maintainable code

In this video, I demonstrate how to add controls to the frmPatients form. You'll learn how to design the form by integrating various controls like textboxes, buttons, and labels to create an interactive UI for managing patient data. Watch as I walk you through the process of adding and customizing these controls to make the form functional and user-friendly!

In this video, I show you how to leverage code reusability by getting country data onto the frmPatients form. You'll learn how to reuse the existing country functionality, like the 'search countries' form, and integrate it seamlessly into the patient form. Watch as I demonstrate how reusing code speeds up development and ensures consistency across your application!

In this video, I guide you through the process of validating and preparing data before adding it to the database. You'll learn how to check for errors, ensure all necessary fields are filled, and perform any required data formatting. Watch as I demonstrate the steps to ensure your data is clean and ready for successful insertion into the system!

In this video, I demonstrate how to add a patient record to the database using the AddEdit() method. You'll learn how to pass validated data to the database, handle the insertion process, and ensure that the new patient record is successfully saved. Watch as I guide you through the steps of adding data efficiently and securely to your database!

In this video, I walk you through the complete CRUD (Create, Read, Update, Delete) operations for managing patient records. You’ll learn how to implement methods for adding, retrieving, updating, and deleting patient data in the database. Watch as I demonstrate each operation, showing you how to handle patient information efficiently and securely within your application!

In this video, I show you how to display database errors on the UI in a user-friendly way. You’ll learn how to capture errors from the database and present them to users with clear, helpful messages. Watch as I guide you through the process of improving error handling and enhancing the user experience!

In this video, I demonstrate how to debug and step into C# code to identify and resolve issues. You’ll learn how to use breakpoints and step through your code to understand its flow and catch errors. Watch as I guide you through effective debugging techniques to troubleshoot and improve your application!