Forms Data Controls :: Create Attendance In .net
Jan 7, 2011http://www.eggheadcafe.com/community/aspnet/7/10057105/attendance-sheet.aspx
View 11 Replieshttp://www.eggheadcafe.com/community/aspnet/7/10057105/attendance-sheet.aspx
View 11 Repliesi'm trying to design an attendance register for pupils in a class for a term (3 months). I wanted to create columns for each day throughout the 3 months in the students table of the database but i feel this is too ambigous. The register will be marked either 'presence' or 'absence' everyday by the class teacher. there will be a gridview with 3 columns (ID, Name & Current date). The current date will have checkbox to mark presence or absence.
View 4 RepliesI'am developing a attendance software of employees with visual studio 2005 and sql server 2005, in which i have to display the attendance in a gridview withname and date as follows,
NAME (Date)1 2 3 4 5 6 7 8 9 10 .... ... 31
RAM P A P P P A
P- Present
A- Absent
I have tried using asp.net createuserwizard and login control.But i m not able to customized them according to my liking.so i created my own user registration webform and login control with the records getting stored in sql database.I dont know whether its a correct way of using asp.net..but its working.Now I am creating a online attendace system which lets user to enter username, logged in and logged out time of each day in thedatabase .The problem is that my user logins in the morning and closes the website and again logins in the evening and exitsthe website.So how to perform this task since i am using a same login form to enter both login time and logout time?Is this possible?my table has colums id,username,logintime,logout timeThe thing is I am using a login from created earlier to enter the username,logindateandtime,logoutdateandtime fields in the databasein which logintime and logouttime gets values from system.
View 33 RepliesI am currently trying to implement a small class attendance system, where the student names are taken from a database, stored in a List<Student>, and bound to a Repeater control. Each row of the Repeater contains two columns: The first is the student's name, and the remaining column contains a RadioButtonList with three ListItems (Present, Absent, Sick).Now, once the user presses "Submit", I want to be able to store their attendance status based on the user selection. However, after submission, the SelectedIndex is always 0, no matter what option is selected.
View 8 RepliesIn my website there is 1 module in which i m fetching data(Student name, Roll no.) of students from the student master table into gridview... and in that gridview there is 1 checkbox column...
I want that when i will check the checkbox of those students who are present...dat checked students and name should be get entered into another table in database where there wil be present written in front of checked students and absent written in front of unchecked students.....
I tried a lot but I am not getting it.....
From the above table(student info) i wil fetch data in gridview and will mark attendance in the gridview
In the above sample gridview in the student name column the name of the students is fetched from student info table, when I will check the checkbox and select the date and click on the button the students who are checked will be stored with a status present and those who are unchecked are stored as absent in another table
The following is the table(example) is where the data is to be stored in the same manner. It means that total two tables are there in the database.
From 1 table i fetch data of students info in gridview and in another table i wil save the attendance marked in gridview....
designing a tbale for employees attendance which will have empname & the no of days
View 3 RepliesI have attendance system in asp.net which takes employeeid, timein, timeout and date. It is working fine.
Problem arise dealing with night shift. In that case employee will timein on 1-jan-2013 at 9:00 pm and timeout at 2-Jan-2013 3:00 am.
How to deal with that.
I have developed an online HRM package ...
I need to maintain daily attendance of every employee ...
Salary is given on 1st of every month , minimum CL for an employee is 12 days in a year. After 12 days , if he or she absent more than 12 days of CL , then deduct from his or her salary amount to be paid next times.
How can generate employee attendance Reports in table bu sql server database 2005 and vb.net 2005 i'm not using crystal reports
View 1 RepliesI have a one table with the empno, employee time in & time out, data, employee can go out & come in fequently in a day.I want to know that how much time every emp have attend in the company per day.I want to know that how much time every emp have not attend in the company per day(once he enter at morning and he come out in the end of the day)I am enclosing data defination in txt file along with the data in the MS Excel file.The Table Like this
Create table emptime
(
EMPCODE VARCHAR2(5),[code]....
Note: INOUTTIME this will only time like 03:45Am, 15:30PM
CARDDATE this will only Dae like 25-09-2010
how can I generate weekly and monthly attendance report calculating total attendance for each student that I have in mu database table?
View 1 RepliesI have forms authentication for my application which uses aspnet_membership database. I want to further expand this to include recording the time in and time out fro keeping an attendence record of the users.
View 5 RepliesI'm new to ASP.net 3.5 and trying to create a test site so I can figure out how to use it in the real world. I have created a FormView (Formview1) based on a Client table using Linq Data Sources. The page includes a DropDownList to lookup Clients. I have added a list option (<asp:ListOption value="" Text="(Select Client)" and set AppendDataBoundItems=true so my added option is displayed. I decided to try to use Formview with only the Edit and Insert Modes, and I have set the Default Mode = Insert. When you open the page, a blank Client record is displayed.
The Client record contains serveral lookup fields and they have drop down lists for each. When I select a client from the Client DropDownList, is get the following message 'ddlClientType' has a SelectedValue which is invalid because it does not exist in the list of items I had this problem before and decided the best way to handle this (in the interim) was to turn off foreign key constraints for each of the lookup fields (e.g. ClientType) in SQL Server. That worked for 2-3 days. Now the problem has started again.
When I develop in other applications, I would simply create a lookup data source based on a Union Query with the actual data and a blank record. How can you do this using Linq DataSources. Can you get access and modify the queries?
i have web application it should create single HTML page . that one HTML page should send to the customers.how to create HTML page .i created one page but it retriveing single record from the databse values . my problem is i have to pull all the records from the database and papulate the HTML page. but i am getting only onerecord on that page.my code as follows
string type = ds.Tables[0].Rows[i].ItemArray[4].ToString();
string WAIVN = ds.Tables[0].Rows[i].ItemArray[0].ToString();
string status = "cdcr";
[code]....
but iam not getting all records only single record only iam retriving
In one of my application, I have around 2000 records which i am displaying in gridview with normal paging.
Now I want to change this paging facility and would like to show a "more" button at the footer(just like [URL] has). The moment user clicks it, the next set of data will be retreived. This will go on till all the records are fetched.
I wanted to create the Calendar with data from database.
I have a ItemId in the database with DateFrom and DateTo
ItemID DateFrom DateTo
1 10/01/2010 11/20/2010
2 10/14/2010 12/18/2010
I wanted to show these records in Calender. may be just view Only.
i have a dataset filled from the DB, let assume the data in the dataset is: -
[code]....
I want to know how we can create a table (or a layout consisting of div's) and poulate it with data from the database. We do this generally using data controls like gridview, datalist etc. But i am restricted by these controls like there is no inbuilt paging with datalist and there is no repeat column in gridview. I just want complete control over the layout as well as the data that goes into it.
I dont know how to do this. Is there anyway of doing it without using the data controls.
i am creating a grid view at run time.now i want to create controls inside the gridview at run time itself,and how to Bind/Eval it.
View 5 RepliesHas anyone had any success creating GANTT charts using MS chart controls?
View 1 RepliesI would like to find out if there is anyone who would know how to read from a database then returns the same number of records that a stored procedure returns and display those records on the webpage there after pass the ID of the record to a variable to another stored procedure that displays the data related to the record that was clicked, I tried doing this in a asp.net repeater but I can't seem to be able to reference the controls inside the repeater.
<Repeater HTML Code>
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OpenLogs.aspx.cs" Inherits="OpenLogs" EnableEventValidation="false" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
[Code]....
Here is the situation:I have a Datagrid which is going to display a number of rows. I want to click a button on the datagrid and have the following occur
open a row underneath the row clicked, without hiding or replacing that row Open this row so that it spans all of the columns as one continuous row where i can put form fields and/or just data formatted as I would like and not just in columns.Be able to close that new row. While I do most of my work in VB.NET, don't think that is a requirement for answering this.I have managed to currently take the first column (with the "Edit" button) and when clicked to
Hide the rest of the cells in that row Expand the button column to run all the way across the table Unfortunately I loose the clicked row's data, and I've only started getting this to work so I haven't tried too much, or getting data to bind to fields "on the fly"
I'm developing a webshop and need to list products. Each product is displayed in a UserWebControl. I have a method that return the products to be shown. The UserWebCotrol has a product property.What should I use to create the controls on my category page? I need to dynamically create the instances of the UserWbControl and set the product property.
View 4 RepliesI want to create a 3x3 Gridview. How do I do it?
View 3 Replies