// TLReader - reads access database containing tug info
// Copyright (C) 2004  Ian Cowburn
// 
// This program is free software; you can redistribute it and/or
// modify it under the terms of the GNU General Public License
// as published by the Free Software Foundation; either version 2
// of the License, or (at your option) any later version.
// 
// This program is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU General Public License for more details.
// 
// You should have received a copy of the GNU General Public License
// along with this program; if not, write to the Free Software
// Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
//
using System;
using System.Data;
using System.Data.Common;
using System.Data.Odbc;
using System.Collections;
using System.Collections.Specialized;
using System.Windows.Forms;

namespace TLReader
{
	/// <summary>
	/// Description of Query.	
	/// </summary>
	public class Query
	{
		public Query(OdbcConnection con, string columns, string query)
		{
			m_fields=new StringCollection();
			m_fields.AddRange(columns.Split(new char[] {','}));
			
			OdbcCommand cmd=new OdbcCommand(query,con);
			OdbcDataReader r=cmd.ExecuteReader();
			
			m_data=new ArrayList();
			
			while(r.Read())
			{
				StringCollection row=new StringCollection();
				
				for(int f=0;f<m_fields.Count;f++)
				{
					string val="No data";
					
					if (!r.IsDBNull(f))
					{
						val=r.GetValue(f).ToString();
					}
					
					row.Add(val);
				}
				
				m_data.Add(row);
			}
			
			r.Close();
		}
		
		public int Count
		{
			get {return m_data.Count;}
		}
		
		public StringCollection Fields
		{
			get {return m_fields;}
		}
		
		public StringCollection Row(int row)
		{
			return (StringCollection)m_data[row];
		}
		
		private ArrayList			m_data;
		private StringCollection	m_fields;
	}
}