My Notes

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...

 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     ...