Member Avatar for abhishekkp

Hello
I'm doing a mini project of student management system.
i need to take the attendance of all the students and store it in sql server.
plz help me i need to submit my project on 25th of this month.
i am left out with only this form :(
or if have any form ready email me :
plz help me it really urgent:(
thank you...

  • 5 Contributors
  • 5 Replies
  • 784 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Netcode

Dani AI

Generated

A focused, practical plan to finish the attendance piece (VB6 + SQL Server). already has a Students table, so the next step is a small, well-normalized Attendance table, a reliable save/update pattern, and a resilient UI save flow. This complements the UI hints from and the encouragement from and by concentrating on data integrity, concurrency, and easy rollback if something goes wrong.

-- Students table assumed existing.
CREATE TABLE Attendance (
  StudentID      INT        NOT NULL,
  AttendanceDate DATE       NOT NULL,   -- use DATETIME if your SQL Server predates 2008
  Status         TINYINT    NOT NULL,   -- 1=Present,0=Absent,2=Late
  Notes          NVARCHAR(250) NULL,
  ClassID        INT        NULL,
  CONSTRAINT PK_Attendance PRIMARY KEY (StudentID, AttendanceDate),
  CONSTRAINT FK_Att_Student FOREIGN KEY (StudentID) REFERENCES Students(StudentID)
);
CREATE INDEX IX_Attendance_Date ON Attendance(AttendanceDate);

Implementation tips for VB6: treat the attendance save as a single transaction. Query Attendance for the chosen date (and ClassID if you have sessions). Let the UI present a checkbox/status per student, then on Save begin a transaction, DELETE Attendance rows for that date+class, and INSERT the new rows. That simple delete-then-insert pattern avoids row-by-row upserts and primary-key conflicts. Use ADODB.Command with parameters or call a stored procedure to avoid SQL injection and to keep SQL logic on the server.

Common pitfalls and checks: ensure you compare dates without time (use DATE column or CAST/CONVERT when comparing), add an index on AttendanceDate for fast lookups, and include CreatedBy/CreatedAt if you need auditing. If multiple sessions can occur the same day, include a SessionID/ClassID in the primary key. Wrap DB calls with error-handling and rollback on failure so partial saves do not corrupt the attendance for a day.

Recommended Answers

All 5 Replies

Member Avatar for abu taher

sorry for that, no man do this for you. every body can support you but all thing you have to do. if you really want it then I think you will pay for this...................

Member Avatar for shelexelex

Just paste what you've done so far and we will help you with the rest

Member Avatar for abhishekkp

i have collected all the students information from one form and the details will be saved in the student table i have done nothing for the attendance thing i have no idea what to do for this attendance form:(

Edited by abhishekkp because: n/a
Member Avatar for BitBlt

On your form, create a list box, make it multi-select. Make a datetime picker above. Make a "Save" button.

On form load, fill the list box with student names from the database. When the datetime picker changes, check the database for student attendance rows. Selectively mark the listbox rows as "selected" or not depending on if the student attended that day. Let the user click the student names on and off until they are happy. Save the data to the database when they click the "Save" button.

That gives you a general idea of how that form should operate. From this narrative, you should be able to figure out how to write the code.

Best of luck!

Member Avatar for Netcode

i have done nothing for the attendance thing i have no idea what to do for this attendance form

You need to show some effort. You can get a picture of what an attendance sheet (on paper) looks like and try computerizing it. When you start something, the concept and idea would keep coming. Keep us posted if you need more help

Best Wishes

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.