how to bind database value to adrotator Control?

Question

I want to bind the below database table to adrotator control ..can any one tell me the reference..
      Name   Class Section DOB         Sex          Address
1    Murali    10    A    15/01/1998    Male    20,rr Street,Chennai-08
2    Arun    10    A    01/04/1998    Male    40,hjh Street,Chennai-43
3    Sekar    10    A    10/02/1998    Male    222,rr Street,Chennai-12
4    Anjali    10    A    18/01/1997    FeMale    78,kbr Street,Chennai-74
5    Devi    10    A    08/12/1997    FeMale    12,ass Street,Chennai-58
6    Kiran    10    B    05/04/1998    FeMale    20,rr Street,Chennai-08
7    Farooq    10    B    /01/1998    Male    40,hjh Street,Chennai-43
8    Stephy    10    B    16/07/1998    Male    120,ff Street,Chennai-18
9    Princy    10    B    15/11/1998    FeMale    20,rr Street,Chennai-08
10    Riyana    10    B    28/06/1998    FeMale    20,rr Street,Chennai-08
11    Anbu    10    C    26/03/1998    Male    58,ww Street,Chennai-05
12    Ravi    10    C    11/11/1997    Male    222,rr Street,Chennai-12
13    Najma    10    C    21/04/1998    FeMale    210,rr Street,Chennai-28
14    Imran    10    C    28/08/1998    Male    12,jj Street,Chennai-08
15    Jancy    10    C    08/08/1998    FeMale    121,kk Street,Chennai-42

selva kumar · Answer

I want to display the whole tables values in database.......

Sanjeeb Lenka · Answer

means you want only name to display or all.

selva kumar · Answer

I want to display the record through c# code ...Need Some more reference....

Sanjeeb Lenka · Answer

http://www.ezineasp.net/post/Using-ASP-Net-Adrotator-Control-with-SQL-DataSource.aspx

selva kumar · Answer

But it deos't Bind Values....Can u tell me correct reference..

Sanjeeb Lenka · Answer

add a ScriptManager and an UpdatePanel. Drag and drop an AdRotator into the UpdatePanel. . In the code-behind file let us write a method to fetch information from the database table. private DataTable FetchFromDB() { string sql = select * from TableName; SqlDataAdapter da = new SqlDataAdapter(sql ); DataTable dt = new DataTable(); da.Fill(dt); return dt; } The above method fetches table information from the table and returns it as a database. You have to mention the DataSource of the AdRotator to this method in your Page_Load event. AdRotator1.DataSource = FetchFromDB(); AdRotator1.DataBind();