protected void Page_Load(object sender, EventArgs e) { if (Session["Admin"] == null) { Response.Redirect("frmAdminLogin.aspx"); } if (!IsPostBack) { ClsAdminBookings VehicleObj = new ClsAdminBookings(); DataSet ds = VehicleObj.DiplayVehicleaId("select VehicleId from tblVehicle"); DdlVehicleId.Items.Clear(); DdlVehicleId.Items.Insert(0, "Select"); for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { DdlVehicleId.Items.Add(ds.Tables[0].Rows[i][0].ToString()); } } }