ASP.NET - reqiure code for employee attendance

  [)ia6l0 iii replied to Vennela Kumara Raja

  dipa ahuja replied to Vennela Kumara Raja

  sneha kadappa replied to Vennela Kumara Raja

Attendance Sheet Attendance Sheet: I am trying to generate a student and Employee attendance sheet in ASP.net. Plz help me out for that. M nt getting a way to start it. I satisfactory result. Plz help me by giving some idea and help full source code using ASP.net C#. First make a perfect plan on paper of how you want the attendance sheet

primary key not getting hi, i have created one website in asp.net 4.0 . My database table is as follows: EmpID nvarchar - --> Primary Key Empname nvarchar Date of Entry nchar intime nvarchar outtime nvarchar totalworktime int THis table is for entering the Employee Attendance in the database. For that i have designed the webform as per requirement. The problem EmployeeID'" + DropDownList1.SelectedValue + "'with the same date have already been taken, Please select a different Employee ID and try again!"; DropDownList1.Focus(); } else { Label13.Visible = true; Label13.Text = "Employee Id available. . Please proceed with further details"; Label13.ForeColor = System.Drawing.Color.Green; } But it the table) I have placed 1 textbox control for date, and drop down control for employee ID IN save button click, my code is as follows: String conn = "user id = sa EmployeeID'" + DropDownList1.SelectedValue + "'with the same date have already been taken, Please select a different Employee ID and try again!"; DropDownList1.Focus(); } else { Label1.Text = "OK"; } If i enter emp id

Multi Table Query Issue I have a form with two subforms. . .They are for recording attendance and scoring events. te first table is the "EVENT" EventId (pk) startdate / time endDate / Time 2nd is EventAttendance EventID (fk) EmployeeID(fk) 3rd is the Employee Table EmployeeID (Empl;oyeeInfo) You generate and Event ID as soon as you enter in the Event Main Form which collects Date / time for start and Stop times. Th event attendance is recorded by a combobox fed by a sql query to the employee table. The Third part (2nd) Subform is scoring the attendees for a multitude of events http: / / www.webmasterworld.com / databases_sql_mysql / 3521451.htm http: / / www.experts-exchange.com / Programming / Languages / .NET / ASP.NET / Q_23410261.html select Event.EventID, Event.StartDate, Event.EndDate, Employee.FirstName from Event, EventEmployee, Employee where Event.StartDate = @somedate and Event.EventID = EventEmployee.EventID and EventEmployee.EmployeeID = Employee.EmployeeID Create

the documents users just read the data, and no access to download confidential data like attendance sheet and payslips. Employee can read the data and close it, and he will not access to download any copy from the site, how can I do that. thanks Hi. Use ASP.net Membership Provider and login controls. Create appropriate Roles in your web system and give restricted based on who loged in.and what is his / her roles. For getting started with ASp.net and Membership provider watch online videos here http: / / learn.asp.net Satalaj- Performance degradation will happen when you use large ACLs for each list item. Just

AttendanceSheet with gridview in asp.net HI To edit the cell in the grid view follow these steps below 1. Switch update method GridView1.EditIndex = -1; BindGridView(); / / Rebind GridView to reflect changes made } Create Table For Employee & Make 30 Columns, Each Days Of Columns. In Rows Take One ID, In Which Values Are Combination Of "Year + Month". Unique Values For Each Row. When You Enter Employee Id, It Will Display It's Attendance sheet as a Table. In The Each Cell Admin Or Who make entry for Present / Absent of employee. when admin want to show attendacesheet for emoloyee, he / she will enter the ID of employee & system will show attendancesheet of that employee. Create New Account