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 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.
I have the following gridview (ID=Gridview1)
I have added pid (primary key), chkblood,chkurine,chkstool,chkmalaria as datakeynames.
what I want to pull off here is .... when I click select I'll be redirected to this wizard
[Code]....
I did that....now I want to hide / skip steps in the wizard depending on the condition of checkboxes (chkblood, chkurine,chkstool,chkmalaria)
but I cant get the value from these non-primary datakeynames...
i get the following exception (missing primary key) in the line of using Find() method "Table doesn't have a primary key." I've rechecked the Database and all Primary Key columns are set correctly.
DataTable dt = p.GetAllPhotos(int.Parse(Id));
DataTable temp = new DataTable();
temp = dt.Clone();
temp = (DataTable)(Session["currentImage"]);
DataTable dtvalid = new DataTable();
dtvalid = dt.Clone();
DataRow[] drr = new DataRow[1];
drr[0] = dt.Rows.Find((int.Parse(temp.Rows[0]["photoId"].ToString()))+1);
foreach (DataRow dr in drr)
{
dtvalid.ImportRow(dr);
}
dtvalid.AcceptChanges();'
In the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
View 6 RepliesI am working on lazy loading page the problem is
when i bind first time page (10) records then primary properly bind with records and when my next 10 records load using lazy loading then the primary key not change it shows 1st records primary key
check the below code in which i am assigning assetid (primary key) but its not assigning properly...
function OnSuccess(response) {
//alert('testing');
var xmlDoc = $.parseXML(response.d);
var xml = $(xmlDoc);
pageCount = parseInt(xml.find("PageCount").eq(0).find("PageCount").text());
var customers = xml.find("AssetSummary");
[Code].....
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 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
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'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 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)
I 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.
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 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 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 Want to show data for single employee like this like this
Emp Id : xyz
Emp Name : abc
-------------------------------------------------------
Child name Date of birth education
abc 12/12/2000 o levels
I am working on an application that has two tables (amongst others) that are related by a Guid Foreign key. The parent table for this guid key is the aspnet_users table and the child table happens to be my employees table which has amongst other columns EmployeeID, FirstName, LastName, EmployeeType, NationalID etc. ant the referenced UserId column from the parent table. I have managed to get the dropdownlists (for UserId and Employee Type) displaying in my create view but have failed to have it create an employee since the guid value from the Dropdown list for UserId cannot bind when posting the form data. I am using Entity Framework 4 , VS 2010 and .Net 4
View 6 RepliesI want to generate the two crystal reports one is employee and another is project. Now I want to display the two reports in a single crystal report viewer. I've tried using sub-reports but the page header is not available in a sub reports. So I want to display two separate crystalreports in a single viewer.
View 2 RepliesI 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?
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.....
How to upload the photo and display in the image control,in the same employee form...the image is displayed in the right side. I've written the code for upload image,the image will uploaded successfully, I want to display on the same page.
View 1 Replies