How can i do store Names by the First letter of their alphabets?

Posted Date: 29 Jun 2012 Posted By:: premkumar Member Level: Silver Member Rank: 1212 Points: 5 Responses: 1

hi frnds,
Hi i have two tables named category(id,categoryname)and ShareHolders(id,first name ,surname,and gender)

the category table contains the Alphabets From A to Z
In Shareholders Table i need to Store the Name According to their First Letter of their name in the table,

Note and also while Displaying for user...i have one dropdownlist it has option(1,2,5,10 and all)in that by selecting 1 it should display only records starts with Alphabets A,

if it is 3 Then it Should Display the names which Stats Alphabets A,B,C

and further So on

i hope u can understand my issues....

PLease help me to get rid...

Thanks & Regards

Prem Kumar.A

Responses

#678127 Author: RayalaHariKishore Member Level: Gold Member Rank: 52 Date: 29/Jun/2012 Rating: Points: 1
hi, you can sort according to alphabet while retreiving the data from database. Rayala HariKishore try..try..try...you achieved it. http://rayalaharikishore.wordpress.com/

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : How can i restrict the duplicate id while inserting data into the database?
	Previous : Cannot able to access AsyncFileUpload??/showing error below??
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages