467,077 Members | 1,143 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,077 developers. It's quick & easy.

how to change the case of data in data list while retreive frm database

helo every1,
pls solve my problem
i m showing data in data list using asp.net 2003
My problem is

FirstName // column name in datalist
RAVI
ANIL
AMIT

I want this data is show like this

FirstName // column name in datalist
Ravi
Anil
Amit
Apr 24 '07 #1
  • viewed: 1213
Share:
3 Replies
100+
change the case of the column except the first character.

cut the first character of the length and change after string to lowercase(string) function.

and add the first letter to the string and display .

you can do it with a loop so every field can change this mode.

try it.
Apr 24 '07 #2
thanks
u ans is not working properly but it give enough idea about how to solve this problem

the solutin is :

UPPER(SUBSTRING(FirstName,1,1)) + LOWER(SUBSTRING(FirstName,2,LEN(FirstName)))

change the case of the column except the first character.

cut the first character of the length and change after string to lowercase(string) function.

and add the first letter to the string and display .

you can do it with a loop so every field can change this mode.

try it.
Apr 25 '07 #3
100+
Thanx

frnd i send only the idea for that problem.

thanx for the code.


grow
Apr 25 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Vivek Sharma | last post: by
10 posts views Thread by mattmerc@bellsouth.net | last post: by
5 posts views Thread by Jason | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.