السلام عليكم ورحمة الله وبركاته
في أول موضوع أكتبه
أول شي التعديل على قائمة المنيو وحذف شي كان موجود بالقائمة ولم يعمل
وهذا الكود والملف
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="FlightSearch.aspx.cs" Inherits="FlightSearch" Title="Untitled Page" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
Namespace="System.Web.UI" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<asp:Panel ID="Panel1" runat="server" GroupingText="معايير البحث" Height="200px" DefaultButton="SearchButton"
Width="100%" style="display: inline; line-height: 150%; direction: rtl;">
<asp:Label ID="Label1" runat="server" Text="اسم الرحلة:"></asp:Label>
<asp:TextBox ID="NameTextBox" runat="server" Width="351px"></asp:TextBox><br />
<asp:UpdatePanel ID="PlacesUpdatePanel" runat="server">
<ContentTemplate>
<asp:Label ID="Label2" runat="server" Text="من:"></asp:Label>
<asp:DropDownList ID="FromCountryList" runat="server" AppendDataBoundItems="True" AutoPostBack="True" DataSourceID="CountryDataSource" DataTextField="Name" DataValueField="CountryID">
<asp:ListItem Selected="True" Value="-1">Any Country</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="FromCityList" runat="server" AppendDataBoundItems="True" DataSourceID="FromCityDataSource" DataTextField="Name" DataValueField="CityID" OnDataBinding="FromCityList_DataBinding" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
<asp:ListItem Selected="True" Value="-1">Any City</asp:ListItem>
</asp:DropDownList>
<asp:Label ID="Label3" runat="server" Text="إلى:"></asp:Label> <asp:DropDownList ID="ToCountryList" runat="server" AppendDataBoundItems="True" AutoPostBack="True" DataSourceID="CountryDataSource" DataTextField="Name" DataValueField="CountryID">
<asp:ListItem Value="-1">Any Country</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ToCityList" runat="server" AppendDataBoundItems="True" DataSourceID="ToCityDataSource" DataTextField="Name" DataValueField="CityID" OnDataBinding="ToCityList_DataBinding">
<asp:ListItem Value="-1">Any City</asp:ListItem>
</asp:DropDownList>
</ContentTemplate>
</asp:UpdatePanel>
<asp:Label ID="Label5" runat="server" Text="خط الطيران:"></asp:Label>
<asp:DropDownList ID="AirlineDropDownList" runat="server" DataSourceID="AirlineDataSource"
DataTextField="Name" DataValueField="AirLineID" AppendDataBoundItems="True">
<asp:ListItem Selected="True" Value="-1">Any Airline</asp:ListItem>
</asp:DropDownList><br />
<asp:Label ID="Label6" runat="server" Text="التاريخ: من"></asp:Label>
<asp:TextBox ID="FromDateTextBox" runat="server" Width="84px"></asp:TextBox>
<asp:Label ID="Label7" runat="server" Text=" إلى "></asp:Label>
<asp:TextBox ID="ToDateTextBox" runat="server" Width="84px"></asp:TextBox><br />
<br />
<asp:Button ID="SearchButton" runat="server" Text="ابحث عن الرحلات" Height="50px" OnClick="SearchButton_Click" Width="180px" Font-Size="14pt" /><br />
<cc1:CalendarExtender ID="FromCalendarExtender" runat="server" TargetControlID="FromDateTextBox">
</cc1:CalendarExtender>
<cc1:CalendarExtender ID="ToCalendarExtender" runat="server" TargetControlID="ToDateTextBox">
</cc1:CalendarExtender>
</asp:Panel>
<div>
<asp:Panel ID="Panel2" runat="server" GroupingText="نتائج البحث"
Width="100%" style="direction: rtl;">
<asp:Label ID="ResultCountLabel" runat="server" Text="تم العثور على 0 نتيجة"></asp:Label><br />
<asp:GridView ID="ResultsGridView" runat="server" AutoGenerateColumns="False" CellPadding="4"
DataKeyNames="FlightID" DataSourceID="SearchResultsDataSource" ForeColor="#333333"
GridLines="None" Width="100%" AllowPaging="True" AllowSorting="True" HorizontalAlign="Center" OnRowCommand="ResultsGridView_RowCommand">
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="Name" HeaderText="اسم الرحلة" SortExpression="Name" />
<asp:BoundField DataField="Spec" HeaderText="المواصفات" SortExpression="Spec" />
<asp:BoundField DataField="AirlineName" HeaderText="خط الطيران" SortExpression="AirlineName" />
<asp:BoundField DataField="StartCityName" HeaderText="مدينة الانطلاق" SortExpression="StartCityName" />
<asp:BoundField DataField="DestCityName" HeaderText="مدينة الوصول" SortExpression="DestCityName" />
<asp:BoundField DataField="SeatCount" HeaderText="عدد المقاعد" SortExpression="SeatCount" />
<asp:BoundField DataField="Date" HeaderText="التاريخ" SortExpression="Date" DataFormatString="{0:d}" />
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:Button ID="Button1" runat="server" CausesValidation="False" CommandArgument='<%# Eval("FlightID") %>'
CommandName="FlightDetails" OnClick="Button1_Click" Text="التفاصيل..." OnCommand="Button1_Command" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
</asp:Panel>
</div>
<asp:AccessDataSource ID="SearchResultsDataSource" runat="server" DataFile="~/App_Data/Data.mdb"
SelectCommand='SELECT Flights.*, SourceCity.Name AS StartCityName, SourceCountry.Name AS StartCountryName, DestCity.Name AS DestCityName, DestCountry.Name AS DestCountryName, Airlines.Name AS AirlineName FROM ( ( (Flights LEFT OUTER JOIN (Cities SourceCity LEFT OUTER JOIN Countries SourceCountry ON SourceCity.CountryID = SourceCountry.CountryID) ON Flights.StartCityID = SourceCity.CityID ) LEFT OUTER JOIN (Cities DestCity LEFT OUTER JOIN Countries DestCountry ON DestCity.CountryID = DestCountry.CountryID) ON Flights.FinalCityID = DestCity.CityID ) LEFT OUTER JOIN Airlines ON Flights.AirlineID=Airlines.AirlineID ) WHERE ((Flights.Name LIKE ("%" + @FlightName + "%")) OR (@FlightName="GetAllFlights")) AND ((Flights.AirLineID=@AirLineID) OR (@AirLineID=-1)) AND ((StartCityID=@StartCityID) OR (@StartCityID=-1)) AND ((SourceCountry.CountryID=@StartCountryID) OR (@StartCountryID=-1)) AND ((FinalCityID=@FinalCityID) OR (@FinalCityID=-1)) AND ((DestCountry.CountryID=@FinalCountryID) OR (@FinalCountryID=-1)) AND ((Flights.Date >= @StartDate) OR (@StartDate="1/1/1900")) AND ((Flights.Date <= @EndDate) OR (@EndDate="1/1/1900"))' OnSelected="SearchResultsDataSource_Selected">
<SelectParameters>
<asp:ControlParameter ControlID="NameTextBox" Name="FlightName" PropertyName="Text" DefaultValue="GetAllFlights" />
<asp:ControlParameter ControlID="AirlineDropDownList" DefaultValue="-1" Name="AirLineID"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FromCityList" DefaultValue="-1" Name="StartCityID"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FromCountryList" DefaultValue="-1" Name="StartCountryID"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="ToCityList" DefaultValue="-1" Name="FinalCityID"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="ToCountryList" DefaultValue="-1" Name="FinalCountryID"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FromDateTextBox" DefaultValue="1/1/1900" Name="StartDate"
PropertyName="Text" />
<asp:ControlParameter ControlID="ToDateTextBox" DefaultValue="1/1/1900" Name="EndDate"
PropertyName="Text" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="AirlineDataSource" runat="server" DataFile="~/App_Data/Data.mdb"
SelectCommand="SELECT [Name], [AirLineID] FROM [AirLines]"></asp:AccessDataSource><asp:AccessDataSource ID="FromCityDataSource" runat="server" DataFile="~/App_Data/Data.mdb"
SelectCommand="SELECT [CityID], [Name] FROM [Cities] WHERE (CountryID=@CountryID) OR (@CountryID=-1) ORDER BY Name">
<SelectParameters>
<asp:ControlParameter ControlID="FromCountryList" DefaultValue="-1" Name="CountryID"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="ToCityDataSource" runat="server" DataFile="~/App_Data/Data.mdb"
SelectCommand="SELECT [CityID], [Name] FROM [Cities] WHERE (CountryID=@CountryID) OR (@CountryID=-1) ORDER BY Name">
<SelectParameters>
<asp:ControlParameter ControlID="ToCountryList" DefaultValue="-1" Name="CountryID"
PropertyName="SelectedValue" />
</SelectParameters>
</asp:AccessDataSource>
<asp:AccessDataSource ID="CountryDataSource" runat="server" DataFile="~/App_Data/Data.mdb"
SelectCommand="SELECT CountryID, Name FROM Countries ORDER BY Name"></asp:AccessDataSource>
</asp:Content>