Beispiel #1
0
        static void Main(string[] args)
        {
            StreamReader    reader      = new StreamReader(FILENAME);
            string          inputLine   = "";
            List <TakenBMI> takenBMIs   = new List <TakenBMI>();
            TakenBMI        newTakenBMI = null;

            while ((inputLine = reader.ReadLine()) != null)
            {
                inputLine = inputLine.Trim();
                if (inputLine.Length > 0)
                {
                    string[] inputArray = inputLine.Split(new char[] { ':' });
                    switch (inputArray[0].Trim())
                    {
                    case "Name of House":
                        newTakenBMI = new TakenBMI();
                        takenBMIs.Add(newTakenBMI);
                        newTakenBMI.Name_of_House = inputArray[1].Trim();
                        break;

                    case "Townland":
                        newTakenBMI.Townland = inputArray[1].Trim();
                        break;

                    case "Near":
                        newTakenBMI.Near = inputArray[1].Trim();
                        break;

                    case "Status/Public Access":
                        newTakenBMI.Status_Public_Access = inputArray[1].Trim();
                        break;

                    case "Date Built":
                        newTakenBMI.Date_Built = inputArray[1].Trim();
                        break;
                    }
                }
            }
            reader.Close();
        }
        static void Main(string[] args)
        {
            StreamReader    reader      = new StreamReader(FILENAME);
            string          inputLine   = "";
            List <TakenBMI> takenBMIs   = new List <TakenBMI>();
            TakenBMI        newTakenBMI = null;

            while ((inputLine = reader.ReadLine()) != null)
            {
                inputLine = inputLine.Trim();
                if (inputLine.Length > 0)
                {
                    string[] inputArray = inputLine.Split(new char[] { ':' });
                    switch (inputArray[0].Trim())
                    {
                    case "Name of House":
                        newTakenBMI = new TakenBMI();
                        takenBMIs.Add(newTakenBMI);
                        newTakenBMI.Name_of_House = inputArray[1].Trim();
                        break;

                    case "Townland":
                        newTakenBMI.Townland = inputArray[1].Trim();
                        break;

                    case "Near":
                        newTakenBMI.Near = inputArray[1].Trim();
                        break;

                    case "Status/Public Access":
                        newTakenBMI.Status_Public_Access = inputArray[1].Trim();
                        break;

                    case "Date Built":
                        newTakenBMI.Date_Built = inputArray[1].Trim();
                        break;
                    }
                }
            }
            reader.Close();
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());

            con.Open();
            string SQL = "INSERT INTO Houses (Name, Townland, Near, Status, Built)" +
                         "VALUES ('@name', '@town', '@near', '@status', '@built')";
            SqlCommand com = new SqlCommand(SQL, con);

            com.Parameters.Add("@name", SqlDbType.NVarChar);
            com.Parameters.Add("@town", SqlDbType.NVarChar);
            com.Parameters.Add("@near", SqlDbType.NVarChar);
            com.Parameters.Add("@status", SqlDbType.NVarChar);
            com.Parameters.Add("@built", SqlDbType.NVarChar);

            foreach (TakenBMI takenBMI in takenBMIs)
            {
                com.Parameters["@name"].Value   = takenBMI.Name_of_House;
                com.Parameters["@town"].Value   = takenBMI.Townland;
                com.Parameters["@near"].Value   = takenBMI.Near;
                com.Parameters["@status"].Value = takenBMI.Status_Public_Access;
                com.Parameters["@built"].Value  = takenBMI.Date_Built;

                com.ExecuteNonQuery();
            }
        }