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(); } }