Search according to alphabets

Question

Hi all I am working on asp.net 2.0 and c#. I have got a database where i store the clients information. here i want a page where all the alphabets from A-Z are displayed horizontally. When i click on a particular alphabet say V then all the client name starting with V should be displayedSimilarly with other alphabet.. can anyone help me out with this plz.... ill be very grateful to u all. Thank u. I got a database named tblClientInfo.mdf where the fields are nameaddresscountrystatecity and website. I wan display only Name and the City when that particular alphabet is displayed.

Pankaj Gupta · Answer

For that just add the alphabets horizontally on the page used link button control for that. When user clicks on the any alphabet the button click event will fire and in this event call the database like (select name. city from TABLENAME where NAME like 'a %'.) after getting all the data bind it with the grid.