IBE.SQL.EliteDBIO.getStations C# (CSharp) Method

        public string[] getStations(string System)
        {
            String sqlString;
            DataTable Data;
            String[] retValue = new String[0];
            Int32 RowCounter;

            try
            {
                Data = new DataTable();
                
                sqlString = "select St.Stationname from tbSystems Sy, tbStations St" +
                            " where Sy.ID         = St.System_ID" +
                            " and   Sy.Systemname = " + DBConnector.SQLAString(DBConnector.SQLEscape(System));

                Program.DBCon.Execute(sqlString, Data);

                Array.Resize(ref retValue, Data.Rows.Count);
                RowCounter = 0;

                foreach (DataRow currentRow in Data.Rows)
                {
                    retValue[RowCounter] = (String)currentRow["Stationname"];
                    RowCounter++;
                }

                return retValue;
            }
            catch (Exception ex)
            {
                throw new Exception("Error while getting names of stations in a system", ex);
            }
        }