Posts

Full Stack Web Development

  HTML Tutorial CSS Tutorial JavaScript Tutorial React Tutorial Bootstrap 5 Tutorial Node.js Tutorial Node.js Tutorial Key Components of Full Stack Development 1. Front-End (Client Side) This is what the user sees and interacts with. Languages & Technologies: HTML (Structure) CSS (Styling) JavaScript (Interactivity) Popular Frameworks/Libraries: React.js Angular Vue.js SASS / Tailwind CSS / Bootstrap 2. Back-End (Server Side) Handles the business logic, database interactions, and authentication. Languages & Frameworks: Node.js (JavaScript) Express.js Python (Django, Flask) Ruby on Rails Java (Spring Boot) PHP (Laravel) Database Management: SQL Databases: MySQL, PostgreSQL NoSQL Databases: MongoDB, Firebase

Bootstrap

Bootstrap 5 Tutorial https://www.w3schools.com/bootstrap5/ https://www.w3schools.com/html/default.asp

Reading Substring value from string excel data in c#

1. Form1.cs  using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; using System.IO; using System.Data.SqlClient; namespace mspc {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }         private SqlConnection cn = new SqlConnection(Properties.Settings.Default.cnstr);         public void ConnectionOpen()         {             try             {                 if (cn.State != ConnectionState.Open) cn.Open();             }             ca...

Jorhat JMC sp_Display_batch_students_attendance_percentage_report update

 USE [JMC6] GO /****** Object:  StoredProcedure [dbo].[sp_Display_batch_students_attendance_percentage_report]    Script Date: 06-06-2025 16:18:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER procedure [dbo].[sp_Display_batch_students_attendance_percentage_report] @batch_id uniqueidentifier, @class_from_date date, @class_upto_date date as begin UPDATE dbo.class SET class_start_time = ISNULL((SELECT MIN(adtLog) FROM class_faculty_view WHERE (class_id = dbo.class.class_id)), dbo.class.class_end_time) WHERE (dbo.class.class_id = dbo.class.class_id) DECLARE  @from_date datetime, @upto_date datetime set @from_date = @class_from_date set @upto_date = DATEADD(DAY,1,@class_upto_date) set @upto_date = DATEADD(SECOND,-1,@upto_date)   SELECT id       ,enroll_id       ,roll_no       ,enroll_name       ,department_id       ,department_name     ...

Download SQL Server Management Studio (SSMS)

Image
Download SSMS   Download SQL Server Management Studio (SSMS) 20.2.1 https://learn.microsoft.com/en-us/ssms/download-sql-server-management-studio-ssms

Nodemon (automatically restarting the Node.js server)

 npm ps1 is not loaded because of running script is desable how to solve ChatGPT said: The error you're encountering is typically related to the execution policy in PowerShell, which restricts the running of scripts for security reasons. By default, PowerShell doesn't allow scripts to run unless the execution policy is set to allow them. To resolve this issue, you need to change the execution policy to allow scripts to run. Here are the steps to fix this issue: Open PowerShell as Administrator : Press Windows + X and choose Windows PowerShell (Admin) or Command Prompt (Admin) . Check the current execution policy (optional): In the PowerShell window, run this command to check the current execution policy: powershell Copy Get-ExecutionPolicy It will likely return Restricted , which is preventing the script from running. Set the execution policy to allow scripts : To allow scripts to run, use the following command: powershell Copy Set-ExecutionPolicy RemoteSi...