diff options
| author | Ian C <ianc@noddybox.co.uk> | 2004-06-20 01:08:11 +0000 |
|---|---|---|
| committer | Ian C <ianc@noddybox.co.uk> | 2004-06-20 01:08:11 +0000 |
| commit | 5a58aea03714c3bb9676f691399e1327519757e9 (patch) | |
| tree | d87b651ed9941e3983c3d2c9aa7803a46e21f2bb /Query.cs | |
| parent | b620ca42fce451f8966219784ffcccb9bc917a4a (diff) | |
First version that works off a straight query.
Diffstat (limited to 'Query.cs')
| -rwxr-xr-x | Query.cs | 83 |
1 files changed, 83 insertions, 0 deletions
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;
+ }
+}
|