From 5a58aea03714c3bb9676f691399e1327519757e9 Mon Sep 17 00:00:00 2001 From: Ian C Date: Sun, 20 Jun 2004 01:08:11 +0000 Subject: First version that works off a straight query. --- TugTable.cs | 114 ------------------------------------------------------------ 1 file changed, 114 deletions(-) delete mode 100644 TugTable.cs (limited to 'TugTable.cs') diff --git a/TugTable.cs b/TugTable.cs deleted file mode 100644 index 3b77c1f..0000000 --- a/TugTable.cs +++ /dev/null @@ -1,114 +0,0 @@ -// 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 -{ - /// - /// Description of TugTable. - /// - public class TugTable - { - public TugTable(OdbcConnection con, Table t) - { - string sql="select "; - bool first=true; - - m_fields=new StringCollection(); - m_fields.AddRange(t.Fields.Split(new char[] {','})); - - foreach (string s in m_fields) - { - if (first) - { - sql+="["+s+"]"; - } - else - { - sql+=", ["+s+"]"; - } - - first=false; - } - - sql+=" from "+t.Name; - - OdbcCommand cmd=new OdbcCommand(sql,con); - OdbcDataReader r=cmd.ExecuteReader(); - - m_data=new ArrayList(); - - while(r.Read()) - { - StringCollection row=new StringCollection(); - - for(int f=0;f