rendered paste body
StringBuilder sql = new StringBuilder();
sql.Append("Select * From myTable");
string tableName = "myTable";
DataRow row;
OleDbDataAdapter adapter = new OleDbDataAdapter(sql.ToString(), adoConGrainPlan);
OleDbCommandBuilder cmdBldr = new OleDbCommandBuilder(adapter);
DataSet ds = new DataSet();
adapter.Fill(ds, tableName);
bool update = true;
if (update)
{
row = ds.Tables[tableName].Rows[1];
row.BeginEdit();
}
else
{ // new row
row = ds.Tables[tableName].NewRow();
}
row["myString"] = "new string" + Math.PI;
row["myFloat"] = Convert.ToSingle(row["myFloat"]) + 1;
row["myDouble"] = myDouble;
row["myBoolean"] = myBool;
if (update)
{
row.EndEdit();
}
else
{
ds.Tables[tableName].Rows.Add(row);
}
adapter.Update(ds, tableName);