Bind Data by Alphabets

[Imran Khan Pathan]

Hi friends. I want to bind data by alphabets order. Like this

A-G H-O P-V W-Z

abc hic per wwl
adc isk qrs wll
bsc jksl rjk xxs
ckl kal snn xvf
dik lmm tnn xgh
elk mdn unv ynf
fis nop vlls ygn
ghs ols vll zla

Start with A to G in one column,H to O second,P to V in third and W to Z in forth in DataList

please don't forget to vote on the post that helped you.

[Lost User]

from where you are getting your data :confused:

The Developer - CEH

[Imran Khan Pathan]

The Developer wrote:

from where you are getting your data

From Sql Server database.

please don't forget to vote on the post that helped you.

[Blue_Boy]

use Order by Col1 asc,col2 asc,col3 asc ... etc

---

I Love T-SQL "Don't torture yourself,let the life to do it for you."

[Imran Khan Pathan]

Blue_Boy wrote:

use Order by Col1 asc,col2 asc,col3 asc ... etc

I have only two field in DataBase Table One is ID and Second one is Title. Now,I want to bind title by Alphabets as I posted.

please don't forget to vote on the post that helped you.

[Lost User]

use a loop to read data and then add each read data to the column u want to add to by alph.

The Developer - CEH

[Imran Khan Pathan]

I got solution My Sql Query Looks like this

select Title from tblLegalPracticeArea where title between 'a%' and 'h%'
..............

:rose:

please don't forget to vote on the post that helped you.

[Baran M]

you can use datalist.RepeatColumns to make a column into multiple and RepeatDirection which you can specify as vertical or horizontal. :)

[Imran Khan Pathan]

Baran M wrote:

you can use datalist.RepeatColumns to make a column into multiple and RepeatDirection which you can specify as vertical or horizontal.

I know that but we can not bind column by alphabets as I wanted. Anyways,I have already done it

please don't forget to vote on the post that helped you.