CODEWITHSUNDEEP
c#sql-server-ce
mlg
mlg

Reputation: 1182

SQL Server CE Insert/Update Multiple Rows

I am trying to insert huge multiple rows in a single transaction. But the SQL Server database is not getting reflected with the update. Below is my code snippet. What am I doing wrong?

private void Form1_Load(object sender, EventArgs e)
{
    string conString = Properties.Settings.Default.Database1ConnectionString;
    Database1DataSet.Table1DataTable dt  = new Database1DataSet.Table1DataTable();
    for (int i = 0; i < 5; i++)
    {
        dt.AddTable1Row(i.ToString(), "name" + i.ToString());
    }
    // Open the connection using the connection string.
    using (SqlCeConnection con = new SqlCeConnection(conString))
    {
        try
        {
            var cmd = con.CreateCommand();
            con.Open();
            cmd.CommandType = CommandType.TableDirect;
            cmd.CommandText = "Table1";
            var rs = cmd.ExecuteResultSet(ResultSetOptions.Updatable)
            var rec = rs.CreateRecord();
            foreach (DataRow dr in dt.Rows)
            {
                rec.SetString(0, dr["ID"].ToString());
                rec.SetString(1, dr["Name"].ToString());
                rs.Insert(rec);
            }
            rs.Close();
            rs.Dispose();
            cmd.Dispose();
        }
        catch (Exception ex) { }                            
    }
}

Upvotes: 0

Views: 1275

Answers (1)

ErikEJ
ErikEJ

Reputation: 41799

You are facing this: http://erikej.blogspot.com/2010/05/faq-why-does-my-changes-not-get-saved.html

Upvotes: 1

Related Questions