Comments by pryashrma (Top 63 by date)

why don't u use Menu Server Control

Thank You!!! got d point!
The error generated, as AttendanceId is Auto Incrementing so can't insert it explicitly.
Problem Resolved!!!!

Thanks for d help! but problem not yet resolved.. Could U plz help?

My Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: ps
-- Create date:
-- Description:
-- =============================================
CREATE TRIGGER dbo.trgInsertAttendance
ON dbo.tblAttendance
INSTEAD OF INSERT
AS
BEGIN
SET NOCOUNT ON
IF EXISTS
(
SELECT 1
FROM dbo.tblAttendance T
INNER JOIN INSERTED I
ON T.AttendanceDate = I.AttendanceDate
AND T.EmpCode = I.EmpCode
)
BEGIN
-- Do dupe handling here
PRINT 'Duplicate Attendance'
RAISERROR('Cannot Mark Attendance.. As Attendance already Marked for the day!',16,1)
return
END

-- actually add it in
INSERT INTO
dbo.tblAttendance
SELECT
*
FROM
INSERTED I
END
GO

but it is generating following ERROR:
Msg 8101, Level 16, State 1, Procedure trgInsertAttendance, Line 28
An explicit value for the identity column in table 'dbo.tblAttendance' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Tried like this, but it is totally wrong:
CREATE TRIGGER dbo.trgBeforeInsert
ON dbo.tblAttendance
AFTER INSERT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for trigger here
IF EXISTS (SELECT tblAtt.AttendanceDate , tblAtt.EmpCode
FROM dbo.tblAttendance tblAtt
JOIN inserted AS i
ON tblAtt.AttendanceDate=i.AttendanceDate and tblAtt.EmpCode =i.EmpCode
where tblAtt.AttendanceDate=i.AttendanceDate and tblAtt.EmpCode =i.EmpCode
)
BEGIN
RAISERROR ('Attendance Alreday Marked!', 16, 1);
ROLLBACK TRANSACTION;
RETURN
END;
END
GO
commit;

tried d link... but problem not resolved

It is Public...
just try yourself once

USE [dbAttendance]
GO

/****** Object: Table [dbo].[tblAttendance] Script Date: 03/07/2013 10:14:55 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[tblAttendance](
[AttendanceId] [bigint] IDENTITY(1,1) NOT NULL,
[EmpCode] [varchar](50) NOT NULL,
[ProjectName] [varchar](50) NOT NULL,
[Status] [char](1) NOT NULL,
[AttendanceDate] [date] NOT NULL,
[AttendanceBy] [varchar](50) NOT NULL,
[DOE] [datetime] NOT NULL,
[ApprovedBy] [varchar](50) NULL,
[ApprovedOn] [datetime] NULL,
[ApprovedFlag] [char](1) NOT NULL,
[Comments] [nvarchar](1500) NULL,
CONSTRAINT [PK_tblAttendance] PRIMARY KEY CLUSTERED
(
[AttendanceId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Present-P; Absent-A; Leave-L; Tour-T; Holiday-H; Sunday-S;' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblAttendance', @level2type=N'COLUMN',@level2name=N'Status'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Pending-P; Approved-A; Rejected-R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'tblAttendance', @level2type=N'COLUMN',@level2name=N'ApprovedFlag'
GO

got it!

Thanks for replying!

Problem not yet resolved, now the query is generating n rows for n attendance dates for each employee... Any suggestions...
EmpCode ProjectName 1 2 3 4 5
------- ----------- - - - - -
A100 p1 NULL NULL P NULL NULL
A100 p1 NULL NULL NULL P NULL
A100 p1 NULL NULL NULL NULL P
A100 p1 NULL NULL NULL NULL NULL
A101 p3 NULL NULL P NULL NULL
A101 p3 NULL NULL NULL P NULL
A101 p3 NULL NULL NULL NULL L
A102 p3 NULL NULL P NULL NULL
A102 p3 NULL NULL NULL P NULL
A102 p3 NULL NULL NULL NULL A
.
.

and I more request.... could u plz explain why ' max(status) ' was used????

Thanks for the suggestion, I tried but sql express is throwing following error:Incorrect syntax near the keyword 'FOR'.

I have no idea for resolving the error

Query:

SELECT [EmpCode], [ProjectName],[1] , [2],[3],[4],[5]
FROM
(SELECT Day([AttendanceDate]) as d1, [EmpCode],[ProjectName],[AttendanceDate] , [Status]
FROM [tebs].[dbo].[View_Attendance]) p
PIVOT(
[Status]
FOR d1 IN ( [1] , [2],[3],[4],[5]) ) AS pvt
ORDER BY
pvt.[EmpCode], pvt.[ProjectName];

Could u plz help!

i don't want to use html reports... but your idea of customizing cell is great! Thanks

please provide code

try using OnRowBound event

you're welcome

plz refer updated question

not working... could u plz explain the functionin of top 1

Thanks for trying

Thanks alot

cannot find control for total field

instead of storing image..u can upload it in particular folder and save image url in database, and then simply bind imageUrl in image control... like
imgPhoto.ImageUrl=dtall.Rows[0]["userimgUrl"].ToString()

please specify how u r creating gridview... either auto genratin columns or through designing them

does it generates any error... include exception message in catch

inherits="classname in codebehind"

replace Inherits="NewTestProject._Default"
with
Inherits="_Default"

it doesn't stop browser from showing the prev. page on 'back' btn click

it doesn't stop browser from showing the prev. page

don't have problem with logout code...
problem is to restrict browser from showing previous page, when back button is clicked if user logouts

don't have problem with logout code...
problem is to restrict browser from showing previous page, when back button is clicked

this is the logout code... but it doesn't restrict browser from showing previous page, when back button is clicked

Thanks for your comments

before assigning value to Payment Amount textbox, check the value
or
use try..catch

not getting your point..
want to print '%' symbol
or problem is with the calculation

does this line help you-

this.dataGridView1.Columns["UnitPrice"].DefaultCellStyle.Format = "F3";

sorry can't help

does cell[5] of grid view contains multiple controls

i found no error.. try debugging again or add jst above the ending brackets-Response.Write("outtime:"+txt_outtime.Text);

try this
set
Mask="99:99:99"

please provide the save function

does value of database field "ID" and variable "i" are same?

are you asking the query for 'GridView' control

Thanks for the help

calendar popups but cannot b clicked.. anyway thanks for trying

right

Thanks for the help

Thanks for trying

Thanks for trying

Thanks for trying

Thanks for the help! it worked. The problem was that i was missing the RowIndex of the Selected Row

i have button- btnAddDetails just below the textbox- txtCustName in grid Item template, and on btnAddDetails_Click event i am trying to fetch the value

how can i use them to fetch the textbox value

i want to use the textbox value further, so could you plz explain how can i store its value in a string variable in .aspx.cs page

please explain