IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'ddf_TelerikDateColumn')
DROP FUNCTION ddf_TelerikDateColumn
GO
CREATE FUNCTION ddf_TelerikDateColumn (@Column_name varchar(100))
-- select dbo.ddf_TelerikTextBoxColumn('varchar',50,1)
Returns varchar(max)
AS
begin
declare @out varchar(max) = ''
SET @out = ' RadGridView1.Columns.Add(oTelerikGrid.createGridViewDateColumn("' +
replace(@Column_name,'_',' ') + '", "' +
@Column_name + '", ' +
'False, True)) '
return (isnull(@out,@Column_name))
end
go
grant exec on ddf_TelerikDateColumn to public
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'ddf_TelerikTextBoxColumn')
DROP FUNCTION ddf_TelerikTextBoxColumn
GO
CREATE FUNCTION ddf_TelerikTextBoxColumn (@Column_name varchar(100),@character_maximum_length int, @isIdentity bit)
-- select dbo.ddf_TelerikTextBoxColumn('varchar',50)
Returns varchar(max)
AS
begin
declare @out varchar(max) = ''
if @character_maximum_length > 300 begin set @character_maximum_length = 300 end
SET @out = ' RadGridView1.Columns.Add(oTelerikGrid.createGridViewTextBoxColumn("' +
replace(@Column_name,'_',' ') + '", "' +
@Column_name + '", ' +
format(@character_maximum_length,'f0') + ', ' +
format(@character_maximum_length,'f0') + ', ' +
'False, True))'
return rtrim(isnull(@out,'x'))
end
go
grant exec on ddf_TelerikTextBoxColumn to public
IF EXISTS (SELECT *
FROM sysobjects
WHERE name = N'ddf_TelerikDecimalColumn')
DROP FUNCTION ddf_TelerikDecimalColumn
GO
CREATE FUNCTION ddf_TelerikDecimalColumn (@Column_name varchar(100), @isIdentity bit, @numericScale int)
-- select dbo.ddf_TelerikTextBoxColumn('varchar',50,1)
Returns varchar(max)
AS
begin
declare @out varchar(max) = ''
SET @out = ' RadGridView1.Columns.Add(oTelerikGrid.createGridViewDecimalColumn("' +
replace(@Column_name,'_',' ') + '", "' +
@Column_name + '", ' +
'"{0:f' + convert(varchar(10),@numericScale) + '}",' +
'80, False, ' +
iif(@isIdentity = 1 ,'False','True') + '))'
return rtrim(isnull(@out,@Column_name))
end
go
grant exec on ddf_TelerikDecimalColumn to public