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;
using System.Globalization;

namespace AeroNet
{
	/// <summary>
	/// Summary description for CountryForce.
	/// </summary>

	public class CountryForce : Common
	{
		protected int i = 0;

		
		protected void PrintCountry()
		{
			SqlConnection connCountry = new SqlConnection(connString);
			SqlCommand cmdCountry = new SqlCommand(("SELECT countryRus, countryid FROM V_CountryForce"), connCountry);
			connCountry.Open();
			SqlDataReader drCountry;
			drCountry = cmdCountry.ExecuteReader();
			
			while (drCountry.Read())
			{
				i = i + 1;
				Response.Write ("<img src='../images/ball.gif' width='11' height='11'><a class='type' href='../Force.aspx?countryid="+(drCountry["CountryID"]).ToString()+"'>&nbsp;&nbsp;&nbsp;&nbsp"+(drCountry["countryRus"]).ToString()+"</a><br>");
				if (i == 50 || i == 101)
				{
					Response.Write ("</td><td align='left' valign='top' width='200' bgcolor='#ffffff'>");
				}
			}
			drCountry.Close();
			connCountry.Close();				

		
		}	
		private void Page_Load(object sender, System.EventArgs e)
		{
			//Загрузить верхнее меню
			TopMenu();

		}

		#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);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);
		}
		#endregion
	}
}