Hi ,
I am trying to insert the arraylist to database using sql .I have my code below.Can anyone help me with .My issue is that my insert statement doesnt work.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using GermanDict;
using SimpleFrenchDict;
using System.Web;

 namespace DicttoData
    public partial class Form1 : Form
        public Form1()

        private void button1_Click(object sender, EventArgs e)
            SqlConnection cn = new SqlConnection();
            DataSet CustomersDataSet = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter();
            SqlCommandBuilder cmdBuilder;
            DataSet ds = new DataSet();
            cn.ConnectionString = "Server=server;Database=RTLUser;UID=sa;";
            GermanDict.DictList ins = new GermanDict.DictList();
            Hashtable aaa = ins.AllWords;
            StringBuilder insertCommand = new StringBuilder();
            IDictionaryEnumerator en = aaa.GetEnumerator();
            if (aaa.Count > 0)
                while (en.MoveNext())
                    ArrayList al = (ArrayList)en.Value;
                        for (int i = 0; i < al.Count; i++)
                            insertCommand.Append("insert into German" + en.Key + al[i]);

Insert statement should be,

nsertCommand.Append("insert into German values ('" + en.Key + "','" +   al[i]  + "')");
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.