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
Loading
selva kumarPosted Jul 4, 2013, 8:10 AM
Sanjeeb LenkaPosted Jul 4, 2013, 7:21 AM
selva kumarPosted Jul 4, 2013, 7:13 AM
Sanjeeb LenkaPosted Jul 4, 2013, 6:36 AM
selva kumarPosted Jul 4, 2013, 6:09 AM
Sanjeeb LenkaPosted Jul 4, 2013, 5:34 AM
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();