Comments by arindamrudra (Top 148 by date)

Do you want to display in the Gridview like "1988-02-05" instead of "1988-02-05 12:00:00 AM" and then want to get the same in the print preview.

In code behind you cant use EVAL in c#. Use Eval and a ternary operator in your .ascx file

table structure
CREATE TABLE [dbo].[tbAD_Jobg8Adverts](
[iJobg8AdvertsID] [bigint] IDENTITY(1,1) NOT NULL,
[JobReference] [nvarchar](1000) NULL,
[ClientReference] [nvarchar](200) NOT NULL,
[Classification] [nvarchar](200) NULL,
[SubClassification] [nvarchar](200) NULL,
[Position] [nvarchar](200) NULL,
[Description] [nvarchar](max) NULL,
[Location] [nvarchar](200) NULL,
[Area] [nvarchar](200) NULL,
[PostCode] [nvarchar](50) NULL,
[Country] [nvarchar](200) NULL,
[EmploymentType] [nvarchar](200) NULL,
[StartDate] [nvarchar](200) NULL,
[Duration] [nvarchar](200) NULL,
[WorkHours] [nvarchar](200) NULL,
[VisaRequired] [nvarchar](255) NULL,
[PayPeriod] [nvarchar](200) NULL,
[PayAmount] [nvarchar](200) NULL,
[PayMinimum] [nvarchar](50) NULL,
[PayMaximum] [nvarchar](50) NULL,
[Currency] [nvarchar](50) NULL,
[PayAdditional] [nvarchar](200) NULL,
[Contact] [nvarchar](200) NULL,
[ApplicationFormXML] [nvarchar](max) NOT NULL,
[JobSource] [nvarchar](200) NULL,
[AdvertiserName] [nvarchar](200) NULL,
[AdvertiserType] [nvarchar](200) NULL,
[sVisitorUserIDs] [varchar](max) NULL,
[isActive] [bit] NULL,
[ActivationDate] [nvarchar](200) NULL,
[ExpiryDate] [nvarchar](200) NULL,
[JobUrl] [nvarchar](1000) NOT NULL,
[AdditionalInfo] [nvarchar](4000) NULL,
[JobExternalLink] [varchar](1000) NULL,
CONSTRAINT [PK_Jobg8Adverts] PRIMARY KEY NONCLUSTERED
(
[iJobg8AdvertsID] 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

ALTER TABLE [dbo].[tbAD_Jobg8Adverts] ADD CONSTRAINT [DF_tbAD_Jobg8Adverts_isActive] DEFAULT ((1)) FOR [isActive]
GO

ALTER TABLE [dbo].[tbAD_Jobg8Adverts] ADD DEFAULT ('') FOR [JobUrl]
GO
============
--view
============
ALTER VIEW [dbo].[vwExternalJob_OrderByActivationDateDesc]
AS
SELECT
ROW_NUMBER() OVER
(ORDER BY (CAST((CAST(ActivationDate AS CHAR(10))) AS DATETIME)) DESC) AS RowNumber,
iJobg8AdvertsID,
JobReference,
ClientReference,
Classification,
SubClassification,
Position,
[Description],
Location as LocationOnly,
Area,
PostCode,
Country,
(dbo.ufn_GetJobg8JobLocation(Area,Location,Country)) AS Location,
EmploymentType,
ActivationDate,
Duration,
WorkHours,
VisaRequired,
PayPeriod,
([dbo].[ufn_GetJobg8JobSalary](PayAmount,PayMinimum,PayMaximum, Currency,PayPeriod)) AS PayAmount,
PayMinimum,
PayMaximum,
Currency,
PayAdditional,
Contact,
ApplicationFormXML,
JobSource,
AdvertiserName,
AdvertiserType,
sVisitorUserIDs,
IsActive,
ExpiryDate,
JobURL,
([dbo].[ufn_GetExternalJobResponseCounts](iJobg8AdvertsID,'SUCCESS')) AS ResponseCount
FROM dbo.tbAD_Jobg8Adverts
WHERE IsActive=1

============
--Query
============
ALTER PROCEDURE [dbo].[usp_GetExternalJobsForAdmin]
@PageSize INT,
@CurrentPage INT
AS
BEGIN
DECLARE @UpperBand INT, @LowerBand INT, @Pages INT
SET @LowerBand = (@CurrentPage - 1) * @PageSize + 1
SET @UpperBand = (@CurrentPage * @PageSize)
SET DATEFORMAT 'dmy'
BEGIN
SELECT @Pages = COUNT(*) FROM dbo.vwExternalJob_OrderByActivationDateDesc
SELECT RowNumber,
iJobg8AdvertsID,
JobReference,
ClientReference,
Classification,
SubClassification,
Position,
[Description],
LocationOnly,
Area,
PostCode,
Country,
Location,
EmploymentType,
ActivationDate AS StartDate,
Duration,
WorkHours,
VisaRequired,
PayPeriod,
PayAmount,
PayMinimum,
PayMaximum,
Currency,
PayAdditional,
Contact,
ApplicationFormXML,
JobSource,
AdvertiserName,
AdvertiserType,
sVisitorUserIDs,