Click here to Skip to main content
15,916,189 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionJavaScript and Server Code Pin
Amit Kumar G30-Sep-06 11:06
Amit Kumar G30-Sep-06 11:06 
AnswerRe: JavaScript and Server Code Pin
Guffa1-Oct-06 0:38
Guffa1-Oct-06 0:38 
QuestionI can't use a Local Resource value Pin
shapper30-Sep-06 11:02
shapper30-Sep-06 11:02 
AnswerRe: I can't use a Local Resource value Pin
minhpc_bk1-Oct-06 15:35
minhpc_bk1-Oct-06 15:35 
QuestionUppercase Pin
shapper30-Sep-06 11:01
shapper30-Sep-06 11:01 
AnswerRe: Uppercase Pin
Guffa30-Sep-06 12:16
Guffa30-Sep-06 12:16 
AnswerRe: Uppercase Pin
albCode1-Oct-06 1:58
albCode1-Oct-06 1:58 
GeneralRe: Uppercase Pin
Amit Kumar G1-Oct-06 13:01
Amit Kumar G1-Oct-06 13:01 
Use the below user defined function......

Select dbo..INITCAP('amit')
output --> Amit

Cheers
Amit

CREATE function INITCAP (@inString varchar(4000) )
/* INITCAP returns char, with the first letter of each word in uppercase, all other letters in lowercase. Words are delimited by white space or characters that are not alphanumeric */
returns varchar(4000)
as
BEGIN
DECLARE @i int, @c char(1),@result varchar(255)
SET @result=LOWER(@inString)
SET @i=2
SET @result=STUFF(@result,1,1,UPPER(SUBSTRING(@inString,1,1)))
WHILE @i<=LEN(@inString)
BEGIN
SET @c=SUBSTRING(@inString,@i,1)
IF (@c=' ') OR (@c=';') OR (@c=':') OR (@c='!') OR (@c='?') OR (@c=',')OR (@c='.')OR (@c='_')
IF @i<LEN(@inString)
BEGIN
SET @i=@i+1
SET @result=STUFF(@result,@i,1,UPPER(SUBSTRING(@inString,@i,1)))
END
SET @i=@i+1
END
RETURN @result
END



QuestionBusiness Entity Set Pin
TheEagle30-Sep-06 9:38
TheEagle30-Sep-06 9:38 
AnswerRe: Business Entity Set Pin
minhpc_bk1-Oct-06 15:33
minhpc_bk1-Oct-06 15:33 
GeneralRe: Business Entity Set Pin
TheEagle2-Oct-06 16:50
TheEagle2-Oct-06 16:50 
GeneralRe: Business Entity Set Pin
minhpc_bk2-Oct-06 19:55
minhpc_bk2-Oct-06 19:55 
GeneralRe: Business Entity Set Pin
TheEagle4-Oct-06 12:28
TheEagle4-Oct-06 12:28 
GeneralRe: Business Entity Set Pin
minhpc_bk4-Oct-06 15:01
minhpc_bk4-Oct-06 15:01 
GeneralRe: Business Entity Set Pin
TheEagle4-Oct-06 20:36
TheEagle4-Oct-06 20:36 
GeneralRe: Business Entity Set Pin
minhpc_bk4-Oct-06 21:13
minhpc_bk4-Oct-06 21:13 
GeneralRe: Business Entity Set Pin
TheEagle5-Oct-06 8:30
TheEagle5-Oct-06 8:30 
QuestionGoogle and Asp.Net Pin
shapper30-Sep-06 2:50
shapper30-Sep-06 2:50 
QuestionNeed different Asp.Net Project Titles. Please help Pin
lavanya_satheesh30-Sep-06 0:59
lavanya_satheesh30-Sep-06 0:59 
Questiondetection when browser is manually closed Pin
248912830-Sep-06 0:38
248912830-Sep-06 0:38 
AnswerRe: detection when browser is manually closed Pin
Not Active30-Sep-06 7:20
mentorNot Active30-Sep-06 7:20 
QuestionMessagebox Problem in Window Service Pin
monika_vasvani30-Sep-06 0:30
monika_vasvani30-Sep-06 0:30 
AnswerRe: Messagebox Problem in Window Service Pin
Parwej Ahamad30-Sep-06 0:55
professionalParwej Ahamad30-Sep-06 0:55 
Questionproperty ScrollToCaret() set in javascript. Pin
Parwej Ahamad29-Sep-06 23:58
professionalParwej Ahamad29-Sep-06 23:58 
Questionasp.net scheduler Pin
Maksi29-Sep-06 22:46
Maksi29-Sep-06 22:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.