All pastes #385307 Raw Edit

Mine

public text v1 · immutable
·published 2007-03-07 19:43 UTC
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);