public class klan
	{
		private string i_Bordplanszone = "";
 
		public klan() { }
 
		public klan(string Bordplanszone)
		{
			this.Bordplanszone = i_Bordplanszone;
		}
 
		public string Bordplanszone
		{
			set { i_Bordplanszone = value; }
			get { return i_Bordplanszone; }
		}
 
	}

	public class common
	{	
		public static klan FindBordplanszone(int KlanID)
		{ 			
			//åbning af connection til DB
			OdbcConnection Connection1 = new OdbcConnection(common.strConnect2());
			Connection1.Open();
			OdbcCommand Command1 = null;
			OdbcDataReader MyDataReader = null;
			
			//udfyldelse af MyDataReader
			Command1 = new OdbcCommand("SELECT klanBordplanszone FROM klaner WHERE klanID = " + KlanID, Connection1);
			MyDataReader = Command1.ExecuteReader();
			
			klan myKlan = new klan();			
			
			while (MyDataReader.Read())
			{												
				myKlan.Bordplanszone = MyDataReader.GetString(0);
			}			
							
			MyDataReader.Close();	

			//lukning af forbindelse til DB			
			Connection1.Close();
			return myKlan;
		}