Archief - [PROG]C# Probleem uitvoeren SQL commando met RegEx output

using System;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using System.Data.SqlClient;

namespace RegExTest
{
    class Program
    {

        static void Main(string[] args)
        {
            TextWriter tw = new StreamWriter("Behuizing2.txt");

            SqlConnection myConnection = new SqlConnection("Data Source=DESKTOP\\SQLEXPRESS;User ID=XXXXXXXX;password=XXXXXXXX;Database=Tones;Integrated Security=True");
            myConnection.Open();
            Regex r = new Regex("<td width=\"469\".+?><a.+?>(.+)</a></td>",
                RegexOptions.Compiled);
            Regex e = new Regex("<td width=\"50\" height=\"24\" valign=\"middle\" class=\"blauw\" scope=\"col\"><div align=\"right\">(.+)</div></td>",
                RegexOptions.Compiled);
            String file = File.ReadAllText("Behuizing.txt");
            MatchCollection m = r.Matches(file);
            MatchCollection p = e.Matches(file);

            System.Collections.Hashtable items = new System.Collections.Hashtable();
            System.Collections.Hashtable item;
            int i = 0;

            foreach (Match match in m)
            {

                item = new System.Collections.Hashtable();
                item.Add("naam", match.Groups[1].Value);
                items.Add(i, item);
                i++;
            }
            i = 0;
            foreach (Match match in p)
            {
                ((System.Collections.Hashtable)items[i]).Add("prijs", match.Groups[1].Value);
                i++;
            }
            System.Collections.Hashtable item3;

            foreach (System.Collections.DictionaryEntry item2 in items)
            {

                item3 = (System.Collections.Hashtable)item2.Value;
                Console.WriteLine(((string)item3["naam"]) + " " + ((string)item3["prijs"]));
                tw.WriteLine(((string)item3["naam"]) + " " + ((string)item3["prijs"]));

                SqlCommand myCommand = new SqlCommand("INSERT INTO Componenten (ID,Categorie,Naam,Prijs) VALUES (0,130,"+((string)item3["naam"])+","+((string)item3["prijs"])+")", myConnection);
                myCommand.ExecuteNonQuery();


            }
            tw.Close();
            //Console.ReadKey();
            myConnection.Close();
        }
    }
}

SqlCommand myCommand = new SqlCommand("INSERT INTO Componenten (ID,Categorie,Naam,Prijs) VALUES (0,130,"+((string)item3["naam"])+","+((string)item3["prijs"])+")", myConnection);
                myCommand.ExecuteNonQuery();