C# Attendance System Full project + SQL Server Database Full Source code

hi friends how are you in this video we will create a small attendance system and see sure this video is targets for beginners and sharp programming to increase their skills to learn new things like connecting to sequel server and creating this awesome application let's see what we are going to build run the application we will have this awesome login form let's login and the password we can select the class of each instructor and the date and you will get each student and the status is present late excuse or not you can edit those anytime let's say this late and then you can save this or you can click anything anytime you want you can add classes add students also you can register you use it in this application and you can go to reports and select a class with a date and get the values you'll get each student how many presences absences lie late and excused he have very nice so if you are ready let's start together [Music] okay France so let's start by creating our project click on file new project and let's select visual c-sharp windows form application I will name it attendance system and let's set the path okay and click OK the first thing I will do to have nice-looking you eyes I will install the Metro framework library so go to solution Explorer and right click on the project manage and you get packages and let's browse for Metro search for Metro and you will find the Metro framework click on head and click install just click ok heat and stood the dependencies except wait for several seconds and awesome so installed it let's go to our form now and right click click on view code go here and make this form and edit the Metro UI for so say Metro framework dot forms dot Metro form very simple now let's go back to our form and see the magic we have this awesome design this is our main application for so let's set the properties got properties here and let's say this is the main or say attendance system very nice and let's start by creating our login and registration forms so simply go searching Explorer again let's add a new windows form and name it login for and add it to my application very nice that's your size this form and let's walsim center screen set to fix tool window and the back color to white and just say he has login I will add a small picture box just for designing purposes and let's add a text box a metro text box for user name one for the password and let's add a label this will be user and this will be the password very nice so here is the main login form let's remove this text from here and set the password character to star sorry for the password box to store and remove this and let's add a button a metro button which is the login button and let's name it natural log in and don't forget to name the text boxes also so this text box user and this text box password very nice now let's add an image for this picture box firstly set the property of a size mode to zoom so we can see the full image inside this picture box and let's select an image I have an image on my desktop so let's select this gift image and click OK and awesome so this has our login form later on in the course we will create a registration form and see how we can do stir users but for now this is the login form let's now implement this code but before we need to create a database for this application so let's open sequel server management studio to create our database ok let's connect to my local instance and here in databases let's create a new database I will name attendance DB and let's set the location all right click ok the same for my log file and create the database very nice open it go to tables and that's create a new table for the user names so I will say user ID it's an integer just identify the user this is the user name it will be and watch our 50 let's set the password to and watch or to lift is an example if the password is somehow long and let's make this column an identity so it will increment automatically by 1 save this table users and click OK so now we have the users table let's open this table our fresh tables now and open users and let's create a new user just to test it is user one and the password one two three and four very nice so now we can test our system using this sample user let's go back to our application to implement the login operation so I want to connect to my data and check if there's a narrow pass word are valid so I can open my main application for what I'm going to do is to go to the main application form here let's name it main form and I will open this phone and go to the form load event and here I will open my login form so let's say open login form login form new login is equal to new login form very simple and just make a dot show dialogue now in this way we will rerun the application the login form will automatically open when you close it the main form will open what we are going to do if the username and password are not valid we will exit the application if it's valid we will allow the user to login let's go to the login button and implement our code but before this I will add a data set for my application so I can connect and read my database just click Add here new item select data and add a data set click and now we can connect to our database let's click on table adapter and click on new connection select server name is bot which means localhost and select attendance dB very nice let's just a connection awesome succeeded click OK and next next ok and let's import my login users table very nice get all columns click on next next and finish very nice so this is the users table here is the table adapter that's connected to my sequel server database and by the way if you are not familiar with sequel server and how to create databases and have to connect with c-sharp please check my course my free course learn sequel server in one video here on my youtube channel you can find a link in the description below let's continue your work now let's create a new query that will return data by user and password so I will select from users were let's get the column name its user ID where user ID is equal to add to user ID which means the variable and password is equal to password so now we can execute this query by username and password if we get data then the user is valid if you don't have any data then the username and password are not so click on next and continue and they will say fell by user and password and say user and pass we can name it whatever you want click on finish now and here is my query let's go to my login form again and now I will create a new instance of the data adapter I will say data the research one table adapters dot users table adapter let's name it user ad a is equal to new adapter very nice so this is a new adapter we can now query our database let's create now a data table that will hold my returned data just say data table DT is equal to user 88 dot get data by user and password and pass the username which is text box which is Metro text box user dot text and Metro text box password dot text very simple we have a small problem oh sorry I used in the query the user ID it must be the username so username sorry just make sure to set user name here and click on next next and finish everything will be ok now awesome so now we got a data table if this data table contains rows then this user and password are valid so I will say F DT the Stroh's dot count if we have some rows greater than 0 then we have data and this is a valid login else it is not valid ok now has the application to close if the user enters on valid username and password and to continue if it's valid what I will do here is I will declare a public property called login flag which will be sorry public rule it's a true/false value and it will be by default false so the validation is false if it is valid here I will select to rule and if it's not valid I've said to false and anyway we will close the form now when we close it let's go back to our main form you can see here when we close it we will check if the new log n the login flag is equal to false then we will close the main form also so we will exit if it's true everything will be fine and we'll continue working let's test this I will run the application I will keep everything is empty so it's an unveiling in oops we have a problem ok ok sorry so this is because we are still loading the form here let's move this code and go to our main form and go to it is activated property and paste the code here so when it's activated to avoid any disposed problems that's wrong again if it's valid you can see we can't access the main form now click on login and we will exit the application very nice let's test if the login is valid now let's run the application I will now enter the user 1 and the password 1 2 3 4 and click on login and awesome and oops we have a problem you can see that we are that the closures are valid but we are always running the login form again and again this is because we run this phone on the activated event I will fix this issue simply by let's close this now I will add a property here called logged in and by default it will be set to zero which is not locked in and if the flag is false the flag is sorry true it will be set to one and now I will put this in an FS statement I will say F logged in is equal to false then activate this form so is equal to zero so whenever this is equal to zero will always open the login form so we'll make our application totally secured let's test this run the code again and enter user 1 and in the password and click login and now our application is working awesome let's finish the login form by adding a simple message box for the user to know I would say message box don't show login okay or anything and here I will say access denied let's do the final test run the application and the credentials now login access denied we close the application let's enter the correct password name username a password and click login login ok and here we are this is our application very nice so this is the login form of our application now we are ready to create our simple attendance system let's close this now and go to our main phone to start designing our phone what I'm going to do here is to add a tab or a tab control and I will dock it inside my fall and let's add two tabs one tab for the attendance and one will be for the report and here we are so we have two tabs one is the attendance here the teacher will enter the students and tendons for a specific date and here we can get reports about students very nice in the attendance tab we will have we allow the teacher the instructor to select the class he wants and the date he want to set their attendance for so we add a date/time control and a combo box let's add two labels as its name it's select class and here select date so simple and you will add a grid data grid view that will load the data so we can edit them and save we still need some buttons but to save and a button to clear records if you want and let's add here a button for the teacher to add a class and button to add students to the class students very nice so this is the attendance section before we can implement the code obviously we need to create our database tables what we will have now here is three tables one will hold the classes you may have multiple classes one will hold the students and one will hold the attendance data or records so let's create a new table and that's at the class ID an integer the class name will be impartial 50 is an example and we will have the user ID for which teacher this class belongs it will be an integer and let's set this as a primary key and it will be an identity so we increment it automatically and let's save it as classes TBL very nice so this is the classes table now let's create a new table for students the student ID and student name it will be am for charge also keep it at 50 and the class ID that the students belongs to very simple students TBR very nice and we still have the records table we will have the student ID or let's add a rec non column just for identifying the records it should be an integer we have the student ID an integer we have the class ID an integer also and we have the date attendance which is date and we have the stay or the status which is absent or attendant or whatever I will set also to an for you are 10 it's enough and this is the attendance records TV are very simple let's refresh now and we have our tables here let's go back to our application and start by implementing this add class button here so we need a class to start working so I create a small form that allows the user to add a class windows form main form add class let's resize it make it fix tool window and 72 screen class simply add a text box which textbox holding the class name and a button very simple this is an empty text box and this is the ad or accept button and let's add a label class name very nice set that back color to white and now we are ready to add our class let's go to our dataset and add the class's data adapter for our table click on next next and get our class's table and add it to my data set so I can add classes click add query insert and let's remove the select statement and this it's auto-generated by Visual Studio add the class and finish very nice you can notice that this query needs two parameters the class name and the user ID so we need to tell the application which user is logged in so to do this what I'm going to do is going here and creating another property called user ID and when you log in here I will set this user ID so let's go back to our login form and set a property create a property here called public or let's use the shortcut user ID and here we will set the user ID and read it from our table it is DT rows 0 which is the first row and get the user ID very simple just parse it as integer very nice so now we have the user ID we can read the tale from our form so simply say this user ID here is or here is equal to new log n dot user ID so I got the user ID from the login form let's create a label showing the user ID the logged in user ID so let's add a label here or let's add a status bar such strip it's here and say status label user and add another label here and this is the state labeled user make it empty and if the login is successful I will say this that table user dot text property is equal to user ID we can get user name but now I don't want to waste time just I am showing the user ID now and my form ok now go back to our form class and go to my code to the click event handler also here we need to pass the user ID as a property to this form so we can add it this is the user ID and when we click on the button we need to enter this data so let's create a new data data adapter from the class named adapter name it anything is equal to new adapter and now we can insert data dot add class this our query or method name textbox metro text box wand or text and the user ID is here very simple I think add the semicolon here the name is wrong okay it's like this and simply close the form when we finish very nice so now we can add a class let's go to our main form to implement this button here double click on this button and we are going to create a new instance of the class form add class the class is equal to new form add class and let's pass the user ID property dot user ID is equal to this dot user ID and let's show the dialog so we can add the class awesome let's just this run the application let's login user 1 and the password login login ok and you can see now this the user ID is shown in the status strip and that's at a class now add class class name let's say biology and click accept let's go to our database classes edit top pros and awesome you can see this biology class is automatically to our table so now we can add classes with this button the second thing we want is an even rate or get the classes and show them inside this comma box here so let's do this go to our main phone and click on this combo box check use data bound items data source from my project data set one class's table display members class name and value member as class ID but you have to know something here that this will get all the classes but we want to get the classes related to this user only the logged in user so we need to filter this data source let's firstly test if everything is ok you can see now and form not event automatically we will have this statement that will fill the data table with the classes Rose let's open the application I will log it again ok this is the application and you can see now we have biology very nice let's now filter this combo box to load only classes related to this user close the application to prevent the filter simply we say this binding source dot filter and filter by user ID is equal to user ID this property hit up to string and be sure to add these sync codes around the user ID and I'm going to do now is moving this code to this section here to the log n section we don't want to load the items except if the user is logged in so let's test this now I will run the application let's enter user 1 1 2 3 4 login ok you can see now we are loading by user let's test this I will close the application again open my database and let's say there's an ID here 2 2 now this class must not load let's run the application again say user 1 1 2 3 4 login ok and you can see now we have no classes since this user ID is 1 2 and the user login is 1 very nice so now we load our classes we are ready to implement the add students button and sign each class we have several students so let's now implement a form or create a form that can add students a certain class I game up and social Explorer go to a tendon system create a clue in this form say students form and edit again set the properties center screen fix to window of course these properties are optional you are not obliged to use them but I prefer to use these to make things easy now I will add a data grid view that will load all the students inside a class and here I will say label class name and add the class name here and again we have the class ID plus ID and this is the IV will be nothing and here is nothing also now we'll we load this form we will get the class ID and the class name and set these labels and then load all the students inside this class if we have students if we don't have students we can fill this table and save the data so let's minimize this and add a button this is a button save so we can save the students inside this class let's go back to our dataset and add the table adapter for students click on max next and students table alright next very nice and now we have a students table adapter let's go back to students form and let's set the data source for this data grid to students table very nice you can see now the student ID student name and the class ID let's go back to our main phone and implement this as students button open it I will say students for students is equal to new students for simple let's show the dialogue very nice so now we can see the students for let's test the application again to make sure everything is ok user 1 the password ok these are classes and as students will open this awesome for very nice now we can start entering student names and the class ID and automatically we click on say if we will we will save the data inside the database all right let's go to this button here and what you can do simply is is good the students binding source and run the Edit method or call it and now let's update the table inside my secret server using this table adapter I will say this adapter dot update data set 1 dot student stable very simple now when we click on the Save button everything we entered here will be saved our database before we test this we need to get the class ID so when we are filling our table we don't want to make wrong inputs of course you can implement this in different way by ending the class ID automatically in the database or preventing a text box and a subject data but here I'm trying my best to make things easy and I'm targeting beginners in c-sharp and sequel server so they can be somehow familiar with different techniques and implementing applications so let's get the class ID from my main form when I click on add students form like so let's go here and I create a property called class ID and another one called class name so I can pass them to this form go now to my main form again or okay and when we click on this button we will set the properties this class name is equal to the combo box combo box dot text property which is a trauma box holding my classes then oh sorry I must set this custom property to string okay let's now set that other property which is the class ID as the selected value of this combo box select value wise racket value simply because when you bound this combo box you set the value number to class ID so again get a socket value from this binding and let's convert to an integer very nice and in the students form when it loads I will set both labels to the properties so let's say this label class name and this label class ID so when we loaded the class ID will be or the label class ID that tax property will be set to class ID dr. string and the second ones the class name which is label class name please if you feel there's anything unclear please contact me comment below the video or contact me directly on my Facebook page I will be with you anytime so this is our form let's test this run the application now log in I'll get okay I will add students now very nice you can see this is the biology class and this is the class ID now we can start adding students so let's start this is student ID I will say it is one one one one student name is Sam and class ID we can read from here it's one very nice so this is our first student let's add a second one one one one two it is Sally in class IDs one let's now save this table click on save and let's go to our sequel server database open the students table and awesome you can see now we have two students their IDs and in the class ID number one which is the biology class so this is the students form we can add students from this form here I will add some more students about ten or fifteen but with some magic one two and three awesome here we have ten students get save and close this form let's go back let's refresh here and awesome we have ten students in the biology class in this way now you can add classes and students awesome now we reach the somehow the final part which is our attendance system part we want to add and save our values our database the attendance values the attendance records what I'm going to do now is when you select a class and a date I will agreement a button now that will load all the values of this day and this class for all students so you can fill them day by day if it's absent it's here or not and so on so let's add a button to get data close this go back to our main form I will add a button set here and let's say it's got values and this button gap and this button will be used to get values according to the class and the date and all the students in this grid so we can fill our attendance records I will go back to my data set and we still have a team adapter responsible for the records the attendance records so let's get the table adapter now here we are get all the data okay very nice and you can see this table you forgot to add the primary key so let's edit this as primary key and this is an identity column save and let's configure it again refresh data very nice you can see we have a student ID the class ID the date attribute and the status now to make things easier for you I will add other two fields the student name and the class name because we don't want to show here in this grid IDs as I told you before this application targets beginners I know somebody of you will tell me you can create an urn join and get the student name and whatever I don't want to make things complicated now I want everything to be clear and simple so I'm going to do I will go to my database again edit this table and add the student name and the class name in this way we can load them inside the table and make things easier so let's go back to our data set configure it next and load the other columns very nice now let's go back to our main form and when we select now these combinations we will get data from that table but here we have a what point will we select a class and a date if we have no records in that table we will create a record for each student because you want to fill the attendance because if we don't have any record we will get an empty table so we can't fill our data so if there is no records we will create a record for each student if there is records then simply we will load these records inside this table and you can edit them very nice so let's go to our data set and create the query and query and then click on next I will say where class ID is equal to plus ID and date as it could add date so we will load data by class and date get data ok let's see what will happen now I will go to my main form I will bind this data source to my students to my attendance record very nice also you can edit the columns and let's hide the react Nam the student ID I will show the student name first the class ID we don't want the date we need and status and remove the class name very nice ok let's maximize this so we can see all the columns now when we click on get values we will load the student names the date and the status also we can hide the date because we have it in the comment box we have in this control here so let's remove the date also and make things easier very nice again it will fill the data automatically I don't want to do this we'll want to fill it manually when I click on this button very nice what I'm going to do firstly as I told you I will check F records exists if yes load them for edit and if not create a record for each student and load for edit I think the ideas somehow simple so firstly let's check if there is data records with this with this class ID and this date I will declare a new adapter attendance adapter is equal to new adapter now say data table DT is equal to area to get data boy and pass the class ID and the date the class ID is simply the combo box selected value and that's convert to integer and date will be from this control here it's a date time picker let's set the value or the format to short we need only the date and let's go and say date time sorry date time picker dot text very simple now if we have data I would say F F DT does froze what camp is above zero then we have records so we can edit else we need to create them create a record for each student here so to create a record for each student you need to get the students first for each class for this class the selected class then we will loop over them and n set records to our attendance records table so the first thing we need is get the class students list let's go to our data set again and create a query that will get the students by class ID create query next select and you'll get students now by where class ID is equal to class ID very nice so now we can get the students by class get by class ID okay and now we can get them go back I will create a new data table to hold the students data students as equal to we need also the adapter students table adapter students adapter is equal to new student table adapter very simple I think now let's get them get by class ID and pass the class ID which is the combo box selected value and as we did we need to convert this to integer cause a class ID is an integer value now we have the students we can loop over them and n set these students records to our attendance record table so I will say for each data row row and this dealer table the trolls insert a new record for this student so we need to create an insert query for the attendance table record go back to the data set and create a new and search query this is an insert query this is a tweet the student ID the class ID the date and the status and the student name student class okay click on next and sub query it's okay now and let's go here and start inserting data this is the adapter you are going to use and we'll say insert query and we to pass the parameters the first thing is a student ID so we'll get this value from this row here because when we create this query get data by class ID we will get the student ID and a student name so the student ID is the first parameter it should name the second parameter the second cell if you want and in the row so we'll say you roll and column zero is the student ID then we need the class ID which is the selected value here we have it then we need date which is this date time record tax property and we need the status I will keep notice it's empty we need to answer them later the student name is the second column in my row row one and I have the class name which is the combobox dot tax property that we are selecting very nice so now we can insert records for all students we can see we need to convert this to string or two integers this is the student ID here and this is the student name very simple and that's it now we inserted the records we will let's remove the pin here now we want to retrieve data after this load and show them in our form so again let's copy this line here and get data now boy selected value and by class ID and time D to you there's a data table and let's set the data grid view data source to this deer table here awesome and let's go back here if we have records we need just to load them so just get this and paste it here we will have the data very nice let's remove this statement and now let's test our code to see if you have any problem I would put a breakpoint here so we can debug our code and see what's happening run our application let's login a user one okay so now we are here let's say this is the date 16 to 2019 I will say get values awesome we are now here all right now we are in this line here half turn that's good data table hit see if there is any records expanded using this small icon and you can see it's empty we have no records so we must go to the second else block here let's continue debugging you can see we are now in this statement here very nice we are working everything is nice let's see the students we must have now 10 students here very nice we got the students of this class and now we will loop over each line and insert data let's see what will happen if everything will be fine we inserted the second line the third line and so on let's see if this insert is working go to our database to the attendance record table and you can see now awesome we have Sam Sally Ali in the biology class and this class ID it is the student ID everything is working fine so let's continue continue and awesome very nice now we have this class and this biology class we have all the students and the stats is empty we can select or import our data very nice let's now close the application and we will see now if we select the class we must go over this block now since we have data let's test this user 1 1 2 3 4 login ok and select the biology get values go after awesome very nice you can see now it's working and everything is fine now we still have something very important which is setting and saving the status now let's implement the Save button so we can save data for these students so let's close this go to my main form again where is my main form it's my main form and go the Save button and before where the code let's go and create an update statement in the records table here so let's create a query next update and I will update that sum of all these here I will update only status and say you were a bit only the status for student were student name is equal to name and class ID is equal to class ID and date is equal to a date so I update the status the student name is equal to name I select and the class ID and the date so in this way we can update the records click on next update and simply now go to my main form and I will loop through the data grid here and update status so simply say for each data grid you roll roll and data grid view 1 the trolls so for each row I will update the status before let's create an adapter let's copy this from here so we can use the query I would say array dot update query and we need to pass the status the string the class ID and the date or the name class I didn't rate so the status is row and let's pass 0 1 2 3 & 4 [Music] it's 4 and the student name is I think it's row 5 yes and we have the class ID let's get it from the combo box and the selected date from the date picker very nice let's convert this all sorry we need to use the cells here the cells it's 4 and here cells dot 5 very nice we need to convert this to strength and this two-string awesome I think this will do that job and when we finish I will load the data again so I can ensure that my data is saved in my database let's execute the query run it log in and okay that's good values I will say Sam as present he is absent and let's say save now oops we have a problem oh sorry I used four on five but I I'm hiding them here so I wanted to use sorry sorry okay let's close this he I want the status which is cell one and this is cells you and lets you get the value another cell it's an object here so I can get the value very simple and now we have a small problem since we are little because a great a great view and if you only updated one student and left the other empty or you left something empty we will have a null problem here it will say you have a null object we can't update so simply say if roll a cell value is not equal to num then update if it's not lived as it is very simple let's test our application now run and say user one and login very nice get values I will say Sam is absent and Mike is present as an example and let's say save now awesome let's go to our database and refresh you can see now Sam is absent and Mike is present so this is the main job here is done we saved our student status in each class and a certain date now let's finish our work by implementing the Clear button we still have the restoration form and the report finally let's close my application now let's close everything close about this now we have this form here very nice the Clear button will clear everything related to those students so simply we'll set and update the status to empty string so let's implement the save the same operation here but we will update the cells by an empty string here simply replace it by empty string and that's it let's run our code to test it let's load those click on clear and very nice now we clear the status now let's implement the report let's go to our main form again two reports tab here and now I will add a list view just to make you learn new things I will the last view control I will set it to details view and edit columns we have a student named number of absences number of late number of excused and present very nice so let's say here student here is presence here is absences or absence anything and here will be late and excused very nice so and this report will show each student how much presence absence late and excused times we have in a certain so I will copy those controls with this button and set it here we need to select the class and the date which is the month we want and here is let's keep it as if there's very nice now we need to create a query that will get for each student in a certain month how many present says Athens's late and excuses he have in that month so let's open out the cassette again dataset and create a new query and this records table select and I will use this query I will get the count of the status were and a selected month for a student name and I selected status very nice so let's click on next now get data boy let's name it report anything fell by report and click on finish and now what I'm going to do is when I press on this get valleys button I will get the students of this class in this month and start looping and getting other numbers and inserting in this list view control so the first thing we will do is to get students of this selection then I will loop through students and get the values and then I will add to list view okay so let's get the students I will use I think I had this before this the students adapter get data by class ID okay so now I have a students here just change this to metric on the box too now we have the students I'm going to look through them and get the values I will say for each row the or for each little role and students don't rose I will look through them let's fix this data role and start executing the queries let's create an adapter for the records to execute the report query ok I would get first alert presence count then the absence then the lathe and then the executors and then I will add to the list of view to make things easy and not to waste more time I think it's now about 1 hour and 10 minutes the tutorial is somehow big so I wanna I will paste the code and explained fastly so I don't want to make this lecture very very long so let's do some magic to create the code 1 2 & 3 Wow don't be frustrated it's very simple I declared 4 variables that will hold the presence/absence late and excuse values for each student and then I am looping through the rows and just executing the query and getting the present value for each student and saving them in each variable then adding the items the ListView item are like the presence absence late and execute it let's test the application I will run it now say user 1 login and let's go through ports and get values awesome you can see I got for each student how many presences absences late and excuses you may ask from where I got these numbers with it I have them when I need some magic I went to my database and filled some values here like presents executed and so on just to test our query so this is it this is the report you can select now any month any date and automatically the application will get the month like here in its - and get my report we still have the registration form so let's go to our application here and let's add a button to gesture let's make it here register and I will add a new registration form windows form register form again let's set the properties fix tool window just very simple let's add text boxes one for the username one for the password and one for the confirm password its labels label 1 this is the username and this is the password [Music] and this is the confirm password okay and that's the button except let's remove data from here and set that password character to asked work for the password boxes and let's name these this is text one this is text path to and this is text user very simple now let's color this too white and when the user clicks on except we will create this user let's go to the accept button go to our dataset to the users table add query to uncertain you user answered where username your password is equal to this very simple I'll create a new Raptor from the users data table adapter is liquid new adapter awesome and let's insert I will say text user dot text and text password dot text and short message box show just raishin successful and close the forum but before we resisted we need to ensure that the two passwords the confirm password box and the initial password box are the same so I would say if text password text is equal or is not equal to text passed to simply say a message box touch show passwords don't match and return so we don't continue our code let's test our station form got my name phone and let's open it here say we just the form which is equal to new rooster phone and show dialog let's open the application I will log in with the user 1 now login ok let's click on register is the station phone let's say user 2 and and on matching password click accept we have a error passwords don't match let's match the passwords now accept awesome station successful let's go to our database our users table and refresh and you can see this the second user very nice let's close the application and try to login with the second user user 2 login okay and you can see we have no classes since that biology class is related to the user 1 and you can see here is user to logged in and we can now add a class and students to this instructor or teacher very nice so this is my small attendance system coded and c-sharp for beginners please if you have any questions you need anything contact me and I will be with you any time thank you for following if you liked the video don't forget subscribe to our channel to like the video and to press on the bell for notifications you can also view our other lectures thank you and see other videos

Channel: C# Coders By H-educate

Views: 77,518

Keywords: c#, c# attendance system, c# project with database, c# project, c# projects, project on c#, c# project code, c# project source code, c# project for beginners, c# project ideas, c# project sample, c# mini project, c# project example, c# simple project, c# project ideas for final year, c# project tutorial, c# programming project, c# project step by step, c# tutorial, learn c#, c sharp tutorial, c# tutorial for beginners, code, c# projects for beginners, c# programming

Id: Ck3cKCGevlM

Length: 72min 5sec (4325 seconds)

Published: Thu Jan 30 2020