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.
Thanks
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()
{
InitializeComponent();
}
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;";
cn.Open();
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]);
}
}
}
cn.Close();
}
}
}