How to bind Records by Order using Asp.Net C# or Sql

Hi Friends ,

 

I am creating a project for ngo trust.A sponsor have to make birthday wishes for their adopted childs.its one or more than one.

 

my Requirement is in birthday home page i have 3 children (it can be less or more)

 

1.if i click 2 nd child the next page should bind 2nd child first then other two childs details . the problem is i am using slider.

 

2.if i click 3rd child to wish the next page should bind 3 rd child first then bind other two childs details on the slider one by one.

 

now i have bind 3 childrens order by birthdate . but how can i bind Clicked child firts and others next .

 

anyone know kindly suggest me to done this task.

 

thanking you

Paul.S

 

this is the Sql query which is am using