Problem with SQLDataAdapter and update
<p>Problem is when I add second datarow to dataset.  If I remove // comments I only get 1 row add instead of 80</p>

<pre><code>SqlDataAdapter indicatorsExp = new SqlDataAdapter();
string sqlExp = "SELECT * FROM BusinessApplications.tbl_WPI_Site_Indicators_Exp " +
                "where Year = '" + year + "' and  Month = '" + month + "'";
indicatorsExp.SelectCommand = new SqlCommand(sqlExp, conn);
SqlCommandBuilder cbexp = new SqlCommandBuilder(indicatorsExp);
indicatorsExp.InsertCommand = cbexp.GetInsertCommand();
DataSet dsExp = new DataSet();
indicatorsExp.Fill(dsExp, "explanations");
DataTable explanations = dsExp.Tables["explanations"];

//.......
foreach (ISite site in sites)
{
    DataRow drexp1 = explanations.NewRow();
    try
    {
        drexp1["PlantId"] = site.ID;
        drexp1["Month"] = month;
        drexp1["Year"] = year;
    }
    catch { }
    DataRow drexp2 = explanations.NewRow();
    try
    {
        drexp2["PlantId"] = site.ID;
        drexp2["Month"] = month;
        drexp2["Year"] = year;
    }
    catch { }

    explanations.Rows.Add(drexp1);
    indicatorsExp.Update(dsExp, "explanations");
//    explanations.Rows.Add(drexp2);
//    indicatorsExp.Update(dsExp, "explanations");

    }
</code></pre>
