OdbcConnection con = new OdbcConnection(ConnectionString);
myOdbcDataAdapter.Fill(myDataSet);

//добавляю данные:
DataRow newRow = myDataSet.Tables[0].NewRow();
................................

myDataSet.Tables[0].Rows.Add(newRow);

//Затем надо это отправить в базу

            OdbcCommand myInsertCommand = con.CreateCommand();
         //   OdbcCommand myDeleteCommand = con.CreateCommand();
            myInsertCommand.CommandText = "INSERT INTO ved (col1, col2, col3, col4, col5)  VALUES (?, ?, ?, ?, ?)";
            myInsertCommand.Parameters.Add("col1", OdbcType.Int, 12, "col1");
            myInsertCommand.Parameters.Add("col2", OdbcType.Text, 2, "col2");
            myInsertCommand.Parameters.Add("col3", OdbcType.Int, 5, "col3");
            myInsertCommand.Parameters.Add("col4", OdbcType.Int, 7, "col4");
            myInsertCommand.Parameters.Add("col5", OdbcType.VarChar, 3, "col5");

           myOdbcDataAdapter.InsertCommand = myInsertCommand;
           myOdbcDataAdapter.Update(myDataSet);