From 5a58aea03714c3bb9676f691399e1327519757e9 Mon Sep 17 00:00:00 2001
From: Ian C <ianc@noddybox.co.uk>
Date: Sun, 20 Jun 2004 01:08:11 +0000
Subject: First version that works off a straight query.

---
 Query.cs | 83 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 83 insertions(+)
 create mode 100755 Query.cs

(limited to 'Query.cs')

diff --git a/Query.cs b/Query.cs
new file mode 100755
index 0000000..2404703
--- /dev/null
+++ b/Query.cs
@@ -0,0 +1,83 @@
+// 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;
+	}
+}
-- 
cgit v1.2.3