Service Computing Archives - Student Notes

SQL Server CRUD Operations with C#

Posted by admin on Sep 12, 2025 in Service Computing | 0 comments

Complete CRUD Operations in SQL Server

1. Create SQL Server Database and Table

First, create the database and the Students table.


CREATE DATABASE CrudDB;
GO

USE CrudDB;
GO

CREATE TABLE Students (
    Id INT PRIMARY KEY IDENTITY(1,1),
    Name NVARCHAR(100),
    Age INT,
    Email NVARCHAR(100)
);

2. C# Application for CRUD Operations

This C# code demonstrates how to perform Create, Read, Update, and Delete operations on the Students table.


using System;
using System.Data;
using System.Data.SqlClient;

Spring Boot Contact Management App: Controller Logic

Posted by admin on Apr 6, 2025 in Service Computing | 0 comments

Contact Management App: Controller Logic

package ca.sheridancollege.controllers;

@Controller

HomeController

This class handles the requests.

@Autowired DatabaseAccess da; @Autowired UserDetailsServiceImpl userDetailsService;

@GetMapping("/")

goHome()

Navigates to the add contact page.

return "addContact.html";

@GetMapping("/addContact")

addContact()

Adds a new contact to the database.

@RequestParam(required = false) String name,
@RequestParam(required = false) int phoneNumber,
@RequestParam(required = false)

Set Up a BIND9 DNS Server on Ubuntu

Posted by admin on Mar 28, 2025 in Service Computing | 0 comments

Understanding the Domain Name System (DNS)

The Domain Name System (DNS) is a standard technology for managing the names of websites and other internet domains. DNS technology allows you to type names into your web browser, like example.com, and your computer automatically finds that address on the internet. A key element of the DNS is a worldwide collection of DNS servers.

What is a DNS Server?

A DNS server is any computer registered to join the Domain Name System. A DNS server runs special-purpose

DNS Server Setup: BIND9 Configuration and Zone File Management

Posted by admin on Mar 20, 2025 in Service Computing | 0 comments

The Domain Name System (DNS)

The Domain Name System (DNS) is a standard technology for managing the names of Web sites and other Internet domains. DNS technology allows you to type names into your Web browser like engine.com and your computer to automatically find that address on the Internet. A key element of the DNS is a worldwide collection of DNS servers. A DNS server is any computer registered to join the Domain Name System. A DNS server runs special-purpose networking software, features a public

Algorithms: Binary Search, Hashing, Insertion, QuickSort, ShellSort

Posted by admin on Feb 28, 2025 in Service Computing | 0 comments

Binary Search Algorithms in C#

Recursive Binary Search

Recursive Binary Search


public TipoElem Buscar(ArrayList x, TipoElem key, int low, int hi)
{
    if (low <= hi)
    {
        int mid = (low + hi) / 2;
        if (key == (TipoElem)x[mid])
            return (TipoElem)x[mid];
        else if (key < (TipoElem)x[mid])
            return Buscar(x, key, low, mid - 1);
        else
            return Buscar(x, key, mid + 1, hi);
    }
    else
        return new TipoElem("NO SE ENCONTRO");
}

Research Methodology: Principles and Process

Posted by admin on Feb 27, 2025 in Service Computing | 0 comments

Research Methodology: Meaning and Objectives

Research methodology refers to the systematic approach to investigating, analyzing, and interpreting information in a scientific study or research project. It encompasses the techniques, procedures, and tools used to gather and evaluate data, enabling researchers to answer specific research questions or test hypotheses.

Primary Objectives of Research Methodology

Identifying Research Problems: It helps in clearly defining and understanding the research problem

« Older Entries