diff options
Diffstat (limited to 'TugTable.cs')
-rw-r--r-- | TugTable.cs | 114 |
1 files changed, 114 insertions, 0 deletions
diff --git a/TugTable.cs b/TugTable.cs new file mode 100644 index 0000000..3b77c1f --- /dev/null +++ b/TugTable.cs @@ -0,0 +1,114 @@ +// 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 TugTable. + /// </summary> + 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<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 string Get(string field,int index) + { + StringCollection d=(StringCollection)m_data[index]; + + return d[m_fields.IndexOf(field)]; + } + + public string Get(string field,string index_as_string) + { + return Get(field,Convert.ToInt32(index_as_string)); + } + + public StringCollection Row(int row) + { + return (StringCollection)m_data[row]; + } + + private ArrayList m_data; + private StringCollection m_fields; + } +} |