01.protected void BindDatacar()
02. {
03. String strSQL = "SELECT car_name FROM car";
04. MySqlDataAdapter da = new MySqlDataAdapter(strSQL, objConn);
05. DataTable dt = new DataTable();
06. da.Fill(dt);
07. DataList1.DataSource = dt;
08. DataList1.DataBind();
09.
10.
11. }
12.
13. private void BindGrid(GridView GridView, string booking_car)
14. {
15. string sql = "Select * from booking Where booking_car ='" + booking_car + "'";
16.
17. MySqlDataAdapter da = new MySqlDataAdapter(sql, objConn);
18. DataTable dt = new DataTable();
19. da.Fill(dt);
20.
21. GridView.DataSource = dt;
22. GridView.DataBind();
23. }
24.
25.
26.
27. protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
28. {
29. GridView GridView1 = (GridView)e.Item.FindControl("GridView1");
30. BindGrid(GridView1, DataList1.DataKeys[e.Item.ItemIndex].ToString());
31. }
