I am designing a validation form which has a textfiled for inserting Employee ID and a submit button for parsing inserted value. On clicking that button the SubmitButton_Click() validate the inserted value against SQL Server database. The database has a table name EMPLOYEE containing ID and Name of employees. Now I have designed the .aspx page but stuck in the rest of the job.
View 6 RepliesI want to bind data(For ex: Employee name, Employee ID from Employee) to a dropdownlist and the data should be displayed in dropdownlist as two columns. I don't want to separate this columns by using any special characters like | or '-'. I want to display them as different columns in a dropdownlist.
How can i achieve this using .net and the data i need to retrieve using SQL server 2008.
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 Intime and Outtime of each employee for all the days of 1st,2,3,4 week.There will be a off for 1 day or 2 days for each employees.Based on this i need to calculate consisitency days off assignmanet i.e no of matching days off among employees in percentage.If there are 100 emplyees out of 100 employees 50 people may get week off on the same day(for example sunday).I want result in percentage.result like this
Consistency Days of assignment Across 4 weeks 3 weeks 2weeks
0 2% 0% 0%
1 98% 100% 100%
2 0% 0% 0%
Here 0,1,2 are macthing days off.Across 98% of employees getting 1 days matching in off i.e 98% of employee might off in sunday.For this we need calculate matching days off for all the days from sunday to saturday across 4,3 2 weeks Here 98% of employees getting off in same day.0 indicates 0 days,1 is 1days and 2 is 2 days(for example 50 percentage of people will get off in saturday and sunday)
query to find the 5th highest salary from an employee table?
View 2 Repliesi wrote a stored procedure to display the number of days in the particular month.if the person is taking a leave from 26jan to 03feb,using this stored procedure i will split the days as per the months..now i want to pass the employee id in the stored procedure and retrive the total days of the january month this is my code
this is my stored procedure
ALTER PROCEDURE datecheck
@EmpId int,@startdate datetime,@enddate datetime
as
begin
[Code]....
i am having dropdownlist in my webpage,if i select the employee id and month january it will retrive the january days for the particular employee.....
login 3 users for a apllication at a same time from different id's & appllied a leave from different id the leave is apllying for same id
View 13 RepliesI have a textbox in one grid-view column where upon entering a particular value and losing focus of the textbox, should post to the server to get the text validated through a server-side method. If the entry is valid, a result set to fill rest of row cells would be returned, else the bgcolor of the textbox needs to be changed to Red.
I tried posting back through the obvious way, i.e. making the textbox's autopostback as true and wiring up a server-side OnTextChanged event handler to validate the entered value.
It is working with this setup, but is also affecting the remaining page controls behaviour. For example, if I click a button in some other grid after entering some text in the textbox, the OnTextChanged handler gets called thus preventing the button's click event, which I also wish to call to execute its functionality.
can u tell me what datatype i should use for TimeIn and TimeOut of the employee in database.
In frontend i am storing TimeIn and TimeOut as object.
I am building the employee portfolio where each employee enters his/her data. at this stage am I building the image crop where an employee uploads image and then crops it. I am getting this error: Input string was not in a correct format.
Here is the code:
namespace Testing {
public partial class Wizard : System.Web.UI.Page {
String path = HttpContext.Current.Request.PhysicalApplicationPath + "images";
protected void Page_Load(object sender, EventArgs e) {
}
[Code] ......
I am doing office management system in web. here i want to display the employee login and logout time in calender (like reminder notice) every day. how to display all the database value to calender date wise.
View 2 RepliesWithin my web application the users complete a application which stores all of their company details into a database, within the application their is a section to complete details for all of their employees.
The admin has the ability to view each company's application in full for reference, now I want to display the employee details on a sperate web page using the GridView control. Unfortunately when creating a datasource for the GridView I am unable to use a varible (currentCompanyId) to pass the employee's companys id into the query to display the correct employee's for the correct application.
Does anybody know another apporach to this? Or maybe there is a better way to do this altogether?
I am uploading excel file to database.In the excel file EmpFirstName,EmpLastName,Dates but i dont have EmpNo.can i use FirstName and LastName as primary key.
If not what is the other choice for selecting primarykey.
Excel File Data
FirstName Lastname Date
I have Creating Employee Module through Wcf. i want To upload image of employee. But Image is not Uploaded how we can Solve This Problem.
View 2 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
I'm looking for a control I can use in an ASP.NET app for scheduling work shifts. My primary requirement is to have locations on a y-axis, dates on the x-axis, and then at each intersection, have a block divided into shifts, and each shift containing a short (1-3) list of employees working that shift.
View 2 RepliesI am looking to create an employee hierarchy in a trace tree and have 2 specific fields in my table ( employee , reports to )
Now a sample data looks like follows
Employee Reports to
User A Manager A
Manager A Senior manager A
User B Senior Manager A
User C Manager A
so on and so forth
Now how do I get a trace tree so that when i click on Senior manager A I get Manager A and User B , and then expand manager A to get user A and User C.
I use an asp Login control with WebControlCaptcha as shown in the above code. The problem is that the captcha control always returns false when UserValidated method is called. I tried to use captcha control on another webpage without the login control it works.
protected void Login1_Authenticate(object sender, AuthenticateEventArgs e)
I am trying to configure NHibernate on my console application in which I am trying to map an Employee class to a table Employee.I am getting below exception which I have no clue:
Class:
class Employee
{
public int id;
public string name;
[code]...
I want to make a new row inserted for the qualification of employee. the add button will add new button qualification for the employee. How can I do that....
View 1 RepliesI can't seem to get any sort of validator to fire when validating my DropDownList. I just want to make sure that it isn't left at "--Select--" when the user presses the Add button on the page. I've tried a range validator and required field validator and neither seem to fire at all. My DropDownList contains ID which is an int that is hidden and Name which is a string that is displayed. The ID is -1 for "--Select--". I use these all the time and can't understand why the page in this new solution is any different from other solutions I have done in the past. What have I missed?
View 18 RepliesI have 2 text boxes one for first name and one for last name. If the user enters a first name then the last name cannot be empty. Is there a validation control i can use and how can i display the message in the validation summary.
View 5 RepliesWe are developing an Intranet application that looks up some data for a user through hooks into Active Directory. However, our Network guys don't always enter in a users email address when creating a new user. Therefore, our user database is missing the email address for over half of our users. We have over 10,000 users, therefore asking them to enter 5000+ email addresses into each missing email address field in Active Directory isn't an option. I already know how to validate that an email address is correctly formatted using Regex. What I need is a way to lookup the email address entered in the email address textbox and see if it exists on Outlook/Exchange (or looking up the email address using the First Name/LastName would work). If it does exist then the address is valid, if it is invalid then the user typed in the wrong address. I've tried to do something with CDO, but have had no luck. We use Outlook 2003 and ASP.NET 2.0.
View 4 RepliesI have a textbox that is set to readonly so users won't try to type something in it. It is then populated when a treenode is clicked. I want to validate what is in the box after it's populated from the treenode click but if i have it set to readonly, in the codebehind it shows up as an empty string. if i take the readonly off it shows up populated. what would you do about this?
View 4 RepliesI have several fields for my custom form, When i create new Validator for that textbox1, it mess up with the alignment of my fields and takes the text or the texbox to another place. I tried absolute positioning, but when i run the page i see that the validator text showin in the wrong place, What should i do to keep the layout of my page beautiful while i using validations for each field in my form?
View 6 Replies