using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace AeroNet
{
///
/// Summary description for AirlinesList.
///
public class AirlinesList : Common
{
protected string L;
protected void PrintAirlinesTitle()
{
// Соединение с SQL-сервером
SqlConnection connAirlinesTitle = new SqlConnection(connString);
//Создать команду
SqlCommand cmdAirlinesTitle = new SqlCommand(("SELECT ID, Name, IATA, ICAO, L FROM V_Airlines WHERE L='"+L+"' ORDER BY Name ASC"), connAirlinesTitle);
//Открыть соединение
connAirlinesTitle.Open();
//Создать DataReader и считать данные
SqlDataReader drAirlinesTitle;
drAirlinesTitle = cmdAirlinesTitle.ExecuteReader();
while (drAirlinesTitle.Read())
{
Response.Write (" | ");
Response.Write (""+(drAirlinesTitle["IATA"]).ToString()+" | ");
Response.Write (""+(drAirlinesTitle["ICAO"]).ToString()+" | ");
Response.Write (""+(drAirlinesTitle["Name"]).ToString()+" | ");
Response.Write (" |
");
}
//Закрываем DataReader и соединение
drAirlinesTitle.Close();
connAirlinesTitle.Close();
}
private void Page_Load(object sender, System.EventArgs e)
{
//Загрузить верхнее меню
TopMenu();
//Получить L из строки запроса
if (Request.QueryString["L"] == null)
{
L = "A";
}
else
{
L = Request.QueryString["L"];
}
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
///
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
///
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
}
}